SqlCommand myCommand = new SqlCommand(db_query, new SqlConnection(ConnStr));
myCommand.Connection.Open();
SqlDataReader dr = myCommand.ExecuteReader();
备份我用存储过程:
ALTER PROCEDURE dbo.[backup]
@BackupPath nvarchar(255),
@DataBaseName nvarchar(255)
AS
BACKUP DATABASE @DataBaseName TO DISK = @BackupPath
RETURN
恢复:
string strSql="Alter Database ["+System_Biz.DataBaseName+"] Set Offline with Rollback immediate; ";
strSql=strSql+"RESTORE DATABASE ["+System_Biz.DataBaseName+"] FROM DISK = '"+System_Biz.RegainPath+"';";
strSql=strSql+"Alter Database ["+System_Biz.DataBaseName+"] Set OnLine With rollback Immediate";
string strconnection="server=localhost;User ID=sa;password="+System_Biz.DataBasePassword+";database=master;";
注意恢复时必须用sa账号