sqlserver数据库命令行备份与强制还原

::完整备份

declare @filename nvarchar(100) set @filename='e:\\databack\\data'+convert(char(8),getdate(),112)+'.bak'  print @filename BACKUP DATABASE [local] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'aWkSQLBAK', NOSKIP, STATS = 10, NOFORMAT

::完整备份基础上进行差异备份

declare @filename nvarchar(100) set @filename='e:\\databack\\data'+convert(char(8),getdate(),112)+'.bak'  print @filename BACKUP DATABASE [local] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'aWkSQLBAK', NOSKIP, STATS = 10, NOFORMAT,Differential

::强制还原

RESTORE DATABASE local FROM DISK = 'E:\databack\data20130629.bak' WITH REPLACE，NORECOVERY\RECOVERY, MOVE 'local_Data' TO 'E:\Program Files\Hintsoft\PubwinServer\database\local_Data.mdf', MOVE 'local_log' TO 'E:\Program Files\Hintsoft\PubwinServer\database\local_log.ldf'