Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts

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

Friday, February 10, 2012

Backup Guidelines for Recovery

Thomas,
the pages on MSDN are more or less identical to BOL
(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/replsql/replbackup_8enn.asp).
Perhaps you have some specific questions regarding
transactional backups?
Regards,
Paul Ibison
No. thanks
On Wed, 28 Jul 2004 06:21:17 -0700, "Paul Ibison"
<Paul.Ibison@.Pygmalion.Com> wrote:

>Thomas,
>the pages on MSDN are more or less identical to BOL
>(http://msdn.microsoft.com/library/default.asp?
>url=/library/en-us/replsql/replbackup_8enn.asp).
>Perhaps you have some specific questions regarding
>transactional backups?
>Regards,
>Paul Ibison