备份语句(压缩):
backup database 数据库名 to disk='E:/备份名称.bak' with STATS = 1,compression
还原语句:
restore database 数据库名 from disk='E:/备份名称.bak'
restore database 数据库原名 from disk='E:/备份名称.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10;
restore database 数据库原名 from disk='E:/备份名称.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10;