Loading

sql server logical logs clean up

Deenadhayalan Subramani

6y686

hi, we did want to clean up large db and used general sql queries to delete data which filled up logical log files, now we disabled logical logs and dont know how to clean up existing logs which is causing lot of space problem. we dont want those logs and need to clean up. any thoughts pl.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
BACKUP LOG {Database Name} TO DISK='NUL'

Then run:
DBCC SHRINKFILE({Logical Filename})

{Logical Filename} is the Logical File Name of your database file which can be found in Database Properties under the File tab. Use the Logical Filename with a File Type of LOG.

Remember to take a full backup afterwards because this breaks the chain of transaction log backup