--完整备份

declare @db_name varchar(100)

set @db_name = 'WSS_Content_Test';

declare @db_location varchar(100)

set @db_location = 'D:\spbr0002\0000000B.bak'; --保证有此文件夹

backup database WSS_Content_Test

to disk = @db_location

with name = @db_name,stats=5,noinit,noskip,noformat,norewind;

--差异备份

--with name = @db_name,stats=5,noinit,noskip,noformat,norewind,differential;

declare @db_name varchar(100)

set @db_name = 'WSS_Content_Test';

declare @db_location varchar(100)

set @db_location = 'D:\spbr0002\0000000B.bak'; --保证有此文件夹

if exists(select * from master..sysdatabases where has_dbAccess(name)=1 and name=@db_name)

begin

    alter database WSS_Content_Test

    set single_user with rollback immediate

end

restore database WSS_Content_Test

from disk = @db_location

with stats=5,file=1,replace,norewind,nounload,recovery;