Tuesday, March 27, 2012

Backup SQL database from ASP.NET Pages

Is there possibility to make backup of MS SQL database directly from ASP.NET pages?

Yes, if you create a DTS package to backup the database you can always call that package in code:

http://www.c-sharpcorner.com/UploadFile/fbulovic/DTSnCS12062005072324AM/DTSnCS.aspx

Hope this helps

|||

If you're using SQL Server 2005, you can also use SQL Management Objects (SMO) to write code to directly backup the database. TheBacking Up and Restoring Databases and Transaction Logs help topic in BOL has the general information and links on the objects to use.

Don

No comments:

Post a Comment