在线等待！在c#中备份数据库？

Question

Create a stored procedure to do the backup work.
Call the stored procedure from the program.The following SP will backup the northwind database:CREATE PROCEDURE [backup_database] 
AS
declare @BackupFile varchar(100)-- Directoryto store the backup file
select @BackupFile = 'c:\zx\northwind_db_' + Convert(varchar(10),Datepart(yy,getdate())) + right('00'+convert(varchar(10),Datepart(mm,getdate())),2) + right('00'+convert(varchar(10),Datepart(dd,getdate())),2) + '.dmp'EXEC sp_dropdevice 'northwind_backup_device'
EXEC sp_addumpdevice 'disk', 'northwind_backup_device', @BackupFile
BACKUP DATABASE northwind TO northwind_backup_device
GO

Answer 1

see
http://expert.csdn.net/Expert/topicview.asp?id=1206543