August 5, 2003 at 1:27 pm
I know to shrink and backup a transaction log, its
something like a three step process truncate, shrink, truncate could someone help me here?
August 5, 2003 at 3:56 pm
Because of active portions of the log, the process I usually follow is:
1) truncate
2) shrink
3) shrink again
4) shrink... please!
5) SHRINK damn you!
6) ok, this is your last chance... SHRINK!!
(mutter under breath)
7) detach db
8) rename LDF file
9) attach db specifying just the MDF (let it create a nice new LDF)
Cheers,
- Mark
Cheers,
- Mark
August 6, 2003 at 9:44 am
True that the Shrink transaction Log is not always is immediate. But, I have been successful most of the times by using the following sequence of steps.
BACKUP LOG dbname WITH TRUNCATE_ONLY
GO
CHECKPOINT
GO
BACKUP LOG dbname WITH TRUNCATE_ONLY
GO
CHECKPOINT
-- By then my Log would have given up
I would then shrink the TLog file using
DBCC SHRINKFILE ('file_name', size in MB)
Try this, it should force the log entries to disk and freeup space.
Have a good one
-Sravan
August 6, 2003 at 10:09 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply