This here is for everyone who has ever needed to shrink that transaction log and couldn't. This script shrank a 3 gig transaction log to 600 MB in about a minute and a half.
Supposedly this was found on MSDN, but I have never been able to find much of any value on MSDN without bleeding from my...
We are performing a migration from BTrieve to SQL 7. Last night while inserting the results of a two table join that resulted in a table of 14.6 million records, we found that increasing the size of the tempdb, while allowing automatic growth of the log file, with "Truncate on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.