完全备份
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
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分钟通话, 中国电信官方发货