Backup SQL Server Database

[zisohel]

How can I take database (SQL Server 2000) backup from asp.net using C#.

-Zahir

[brin351]

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).

[zisohel]

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.

[Troy Mac]

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.

[axion_sa]

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