Thursday, February 9, 2012

ASP.NET 2.0 and SQL Server Express Backup

I′m developing an application that uses SQL Server Express as the Back-End, i want to provide to the user an inteface where he can make backup of the database or restore a backup file, i really don′t know where i can begin with this task or what′s the best approach for doing stuff like this, i need some guidance here because we finish with the application and we are just adding some usefull features to the user.

If somebody has any idea, i am willing to learn and listen carefully. thnaks to everybody.

Thanks to everybody, CesarSadIf you are running under Full Trust, you can make use of the SMO library. See, for example,Using SMO for Backup,Restore and Security Purposes orGetting Started with SMO in SQL 2005 - Backups|||I try with the"Getting Started with SMO in SQL 2005 - Backups" sample and it doesn't show me the SQL Express instances, i got installed a SQL Server Standard and a SQL Express instance and the sample app only shows me the Standard instance.

I dont know if this got something to do with the "full trust"(i'm sorry but i dont know what it is).Could you be more specific ?.

Cesar

No comments:

Post a Comment