Post reply

Backup problem

  • April 25, 2007 at 11:20 am

    #173743

    SQL Server 2000 with sp4

    I have a databse with 16 Gig and the log file already with 30GIG

    well, I try to backup the log and then shrink, didin't work

    I try to backup the intire database it's goingo to 29GIG and error

    what Am I suppose to do?

    any ideas?

    thanks

  • April 25, 2007 at 12:23 pm

    #702464

    I would start with the log file first and do

    BACKUP LOG dbName

    WITH TRUNCATE_ONLY

    then shrink just the log file first, could be the log file is filling when you try to shrink.

  • April 25, 2007 at 12:31 pm

    #702468

    I did that and I'm getting this error:

    The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed.

    The replication it's not running right now, it run everyday at 3AM !!!

     

  • April 25, 2007 at 12:41 pm

    #702472

    OK that would make sense. With replication you will either need to kick off and complete before you can do this or setup a job to do the work shortly after the replication ends at 3 AM. If you use sp_repldone then those records pending replication may not exist in your replicated set and you will have to restart replication over to correct.

  • April 25, 2007 at 1:27 pm

    #702478

    Yeah I ran the sp_repldone and it works, I was able to shrink the log file

    thanks for your help

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply