Showing related tags and posts across the entire site.
-
[quote user="DenSter"] Useful command to truncate transaction log: BACKUP LOG <MyDatabase> WITH TRUNCATE_ONLY This will get rid of all committed transactions in the log file, and leave you with a mostly empty file. At this point, the file is still the same size. Truncating the file only...
-
Interesting, have not had any problems with it.
-
[quote user="babrown"] Management Studio provides a nice interface for shrinking files. (Right Click (database name) - task - shrink - files). [/quote] Tried that one, but it didn't work! :(
-
Management Studio provides a nice interface for shrinking files. (Right Click (database name) - task - shrink - files).