Post reply

Issues with Merge Replication

  • May 25, 2011 at 3:47 am

    #250793

    The Merge Replication runs between sql server 2005(Publisher) to sql server 2000(Subscriber)

    Most of the time the following error raised. and after sometime automatically it resolved. and so..on...

    Error:

    "The log file for database 'GDR' is full. Back up the transaction log for the database to free up some log space. (Source: MSSQLServer, Error number: 9002)

    Get help: http://help/9002"

    I have checked:

    The log file is in auto growth, 40% of log space are still free, The disk has 39 GB of free space,

    Can somebody help me to solve the issue?

    Thanks,

    TAPAS

  • May 26, 2011 at 5:11 am

    #1330171

    Today I am watching the log , it is only using 10 % of the space, But still having the same error.

    please somebody reply!!!!!!

    Thanx...

  • May 26, 2011 at 5:19 am

    #1330177

    Are you looking at the publisher or subscriber? Either can result in this error.

    A subscriber db can have its log file in simple mode.

  • May 26, 2011 at 6:59 am

    #1330280

    I am telling about publisher. and the subscriber DB is in full recovery mode.

    Thanks..

    Tapas

  • May 26, 2011 at 4:33 pm

    #1330707

    Run this on the Publisher and Subscriber and post the output.

    DBCC SQLPERF(logspace)

    Where are you seeing the error message? SQL Error log? Windows Event log?

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

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