阅读背景:

C# sqlserver 数据库备份与还原(winform版)

来源:互联网 

数据库备份与还原的sql语句

//数据库备份
backup database northwind to disk='c:\dbbackup\northwind.bak';
//数据库还原
//数据库还原
use master;
alter database northwind set offline with rollback immediate 
restore database northwind from disk='c:\dbbackup\northwind.bak' 
alter database northwind set online with rollback immediate;//数据库备份
backup database northwi



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: