--1.完整备份
DECLARE @File NVARCHAR(255)
SELECT @File='D:/数据库备份/'+REPLACE(CONVERT(NVARCHAR(10),GETDATE(),120),'-','')+'.bak'
BACKUP DATABASE [数据库] TO DISK = @File WITH NOFORMAT, INIT,
NAME = N'数据库完整备份',
SKIP, NOREWIND, NOUNLOAD, STATS = 10;
GO
--2.日志备份,截断事务日志
DECLARE @File NVARCHAR(255)
SELECT @File='D:/数据库备份/'+REPLACE(CONVERT(NVARCHAR(10),GETDATE(),120),'-','')+'_Log.bak'
BACKUP LOG [数据库] TO DISK = @File WITH NOFORMAT, INIT,
NAME = N'数据库-事务日志 备份',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
--3.设置恢复模式为简单
ALTER DATABASE [数据库]
SET RECOVERY SIMPLE;
GO
--4.收缩事务日志
DBCC SHRINKFILE (db_Log, 1);
GO
--5.设置恢复模式为完整
ALTER DATABASE [数据库]
SET RECOVERY FULL;
GO