SELECT file_id, name FROM sys.database_files
BACKUP LOG [databaseName]
TO DISK=‘nul:’ WITH STATS= 10
DBCC SHRINKFILE(‘templog’, 0, TRUNCATEONLY)
SELECT file_id, name FROM sys.database_files
BACKUP LOG [databaseName]
TO DISK=‘nul:’ WITH STATS= 10
DBCC SHRINKFILE(‘templog’, 0, TRUNCATEONLY)
You must be logged in to post a comment.