October 18, 2004 at 2:41 am
Hi Guys,
Have a bit of a problem.
The disk with my T Log on it has run out of space.
I've tried Backup with Truncate_only
and Shrinking. But the file is not reducing.
Tried creating a secondary file on another drive and I got the 3023 eror.
Any thoughts on how to deal with this.
Can't run sp_repldone as this is a live server.
Many Thanks...Graeme
October 18, 2004 at 7:12 am
You can use this to try and shrink the log
http://www.sqlservercentral.com/scripts/contributions/26.asp
October 18, 2004 at 9:33 am
be sure to check that the log reader agent is running. If you have transactions marked for replication and the log reader doesn't put them in the distribution database, then the transaction log won't shrink.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply