DECLARE @fileName nvarchar(100)
SET @fileName='E:\DataBase_backup\pivot_full_back_' + REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(100), GETDATE(), 121), ' ', ''), ':', ''), '-', ''), '.', '') + '.bak'
PRINT 'Backup to ' + @fileName + '...'
--执行备份
BACKUP DATABASE [pivot] TO DISK = @fileName
WITH FORMAT, INIT, NAME = N'pivot_full', SKIP, NOREWIND, NOUNLOAD, STATS = 10;
BACKUP LOG [pivot] TO DISK = @fileName
WITH NOFORMAT, NOINIT, NAME = N'pivot_log', SKIP, NOREWIND, NOUNLOAD, STATS = 10;
GO
----还原备份数据库
alter database [DATA180425] set offline with rollback immediate
go
restore database [DATA180425]
from disk = 'E:\DataBase_backup\DATA180425_full_back_20180616142229013.bak&#