SELECTTOP1 b.type, b.first_lsn, b.last_lsn, b.checkpoint_lsn, b.database_backup_lsn
FROM msdb..restorehistory a
INNERJOIN msdb..backupset b ON a.backup_set_id = b.backup_set_id
WHERE a.destination_database_name ='TRACK_DEEJ'ORDERBY restore_date DESC
1、查询日志文件ID或name
select*from sys.database_files;2、收缩日志文件到指定大小
USE ecology
GO
ALTERDATABASE ecology SET RECOVERY SIMPLEWITH NO_WAIT
GO
ALTERDATABASE ecology SET RECOVERY SIMPLE
GO
USE ecology
GO
-- 单位为M,清理为1G日志文件 “数据库日志名称”请查看以下图片中的日志逻辑名称DBCC SHRINKFILE (N'ecology_log',1024, TRUNCATEONLY)
GO
USE ecology
GO
ALTERDATABASE ecology SET RECOVERY FULLWITH NO_WAIT
GO
ALTERDATABASE ecology SET RECOVERY FULL
GO