RE: purge the tran log
I always use the following script and it works great. After the script finishes and the logfile is still bigger then you want, just run it again for a couple of times... SET NOCOUNT ON DECLARE @LogicalFileName sysname, @MaxMinutes INT, @NewSize INT -- *** MAKE SURE TO CHANGE THE NEXT 4 LINES […]
2004-03-24