大全:
// Create Instance of Connection and Command Object
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"].ToString());
string sBackup = "BACKUP DATABASE " + myConnection.Database + " TO DISK = 'c:\\sql.bak' WITH NOINIT";
SqlCommand myCommand = new SqlCommand(sBackup, myConnection); // Open the database connection and execute the command
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close(); return true;
http://expert.csdn.net/Expert/topicview.asp?id=1206543
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
完全备份
BACKUP DATABASE @dbname TO @logicalname WITH NOINIT , NOUNLOAD , NAME = @backup_name, NOSKIP , STATS = 10, NOFORMAT
差异备份
BACKUP DATABASE @dbname TO @logicalname WITH NOINIT , NOUNLOAD , DIFFERENTIAL, NAME = @backup_name, NOSKIP , STATS = 10, NOFORMAT恢复数据库
完全恢复
restore database @dbname from disk = @physical_name1 with file = @file1, nounload , stats = 10, recovery
差异恢复
restore database @dbname from disk = @physical_name1 with file = @file1, nounload , stats = 10, norecovery
// Create Instance of Connection and Command Object
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"].ToString());
string sBackup = "BACKUP DATABASE " + myConnection.Database + " TO DISK = 'c:\\sql.bak' WITH NOINIT";
SqlCommand myCommand = new SqlCommand(sBackup, myConnection); // Open the database connection and execute the command
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close(); return true;
http://expert.csdn.net/Expert/topicview.asp?id=1206543
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
完全备份
BACKUP DATABASE @dbname TO @logicalname WITH NOINIT , NOUNLOAD , NAME = @backup_name, NOSKIP , STATS = 10, NOFORMAT
差异备份
BACKUP DATABASE @dbname TO @logicalname WITH NOINIT , NOUNLOAD , DIFFERENTIAL, NAME = @backup_name, NOSKIP , STATS = 10, NOFORMAT恢复数据库
完全恢复
restore database @dbname from disk = @physical_name1 with file = @file1, nounload , stats = 10, recovery
差异恢复
restore database @dbname from disk = @physical_name1 with file = @file1, nounload , stats = 10, norecovery
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货