How can I take database (SQL Server 2000) backup from asp.net using C#.
-Zahir
Printable View
How can I take database (SQL Server 2000) backup from asp.net using C#.
-Zahir
Normally you'd back up using sql server either on the same machine or to a remote sql server. Using asp.net you'd have to get all records in all tables and write them to another database or file (text or xml etc).
Thanks for your response but I don't want to take backup from the SQL Server. I need to take backup from the front-end.
I believe there is a command line that can be used to do a back up... I cannot remember the executable name but search the web for command line SQL backup. Although this may only be true with Oracle, which I haven't touched in over 5 years.
Or you could execute the T-SQL commands that the interfaces, be it command line or Enterpise Damager, run i.e. BACKUP and RESTORE...
http://www.sqlteam.com/item.asp?ItemID=26689