Dev asked for assistance w/ truncating a log file for one of the databases. He’ve tried most of everything:
setting the recovery mode in SIMPLE
shrinking the database
setting the recovery mode back in FULL
dbcc shrinkfile (logicalname,%)
dbcc shrinkdatabase (dbname)
dbcc shrinkfile (logicalname, emptyfile) — to empty out the transaction log
tried to drop the log files and create a new one
I’ve tried:
updating the status of the db
backup the database while it was in full mode
truncated the log
shrinked the db
When I truncate the log, the message said something about all the logical log files are in use. Next step was to:
detach the database
reattach
and then run: dbcc shrinkdatabase (dbname, 40)
ran a sp_spaceused:
Was:
x_Log1 42943872 KB — 42gb
x_Log2 32769024 KB
x_Log3 32413632 KB
Now:
x_Log1 767816 KB — 767mb
x_Log2 1024 KB
x_Log3 1024 KB