T-SQL 备份和恢复Sql Server数据库

备份数据库
完全备份
BACKUP DATABASE @dbname TO @logicalname WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
差异备份
BACKUP DATABASE @dbname TO @logicalname WITH NOINIT , NOUNLOAD , DIFFERENTIAL, 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