SQL 语句备份系统和还原系统

 

1.

//备份,@name地址,
string strSql = @"declare @name varchar(250) set @name = 'D:\YZ_Backup\DataBackups\YZ_' + convert(varchar(50),getdate(),112)+'.bak' BACKUP DATABASE[jxc] TO DISK = @name WITH NOFORMAT, NOINIT, NAME = N'YZ-完整数据库备份', SKIP, NOREWIND, NOUNLOAD";

　　

 

 

2.

            //还原,[jxc]数据库名称,
            string strSql = @"ALTER DATABASE [jxc] SET OFFLINE WITH ROLLBACK IMMEDIATE 
                                ALTER DATABASE [jxc] SET OFFLINE WITH ROLLBACK IMMEDIATE 
                                ALTER DATABASE [jxc] SET OFFLINE WITH ROLLBACK IMMEDIATE 
                                use master 
                                    RESTORE DATABASE [jxc] 
                                    FROM DISK='D:\YZ_Backup\DataBackups\" + BakName + "' ALTER DATABASE [jxc] SET ONLINE WITH ROLLBACK IMMEDIATE ";