Post reply

Truncate the log

  • September 12, 2005 at 11:18 pm

    #115162

    Hi,

    I have copied Data and Logfiles from production to Test setup. Production is on Transactional repliction.

    At the test setup wheh i try to truncate the log am getting the following 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."

     

    I don't have replication copnfigured at the Test setup, i want to truncate the transaction log also.

    i have tried sp_repldone null,null,0,0,1 at the Test setup. this faild because test setup was not a publisher.

     

    I had similar situation before also and i have done dbcc rebuild_log which is very risky command and i don;t want to do that here now!!

     

    Cany anybody suggest me any alternate way to truncate the log at my test setup

     


    subban

  • September 13, 2005 at 12:35 am

    #589244

    You must stop the replication agent before you copy the database to the test server, after that make sure all log file in the production server has been restore in the copy of your database.

  • September 13, 2005 at 1:24 am

    #589252

    ok thankx..

    But can we do something on the test setup (that i have already copied??)

     


    subban

  • September 13, 2005 at 1:46 am

    #589260

    I think you must detach your database, after that delete the log file and then attach the database. (This way will create a new log file)

  • September 13, 2005 at 1:47 am

    #589261

    I think you must detach your database, after that delete the log file and then attach the database. (This way will create a new log file)

  • September 13, 2005 at 1:58 am

    #589265

    I have two log files . so it will not create new log files while attaching


    subban

  • September 14, 2005 at 3:29 am

    #589630

    please..................

    any solution for this ???


    subban

  • September 14, 2005 at 3:52 am

    #589633

    Delete one of your log file, so after that you can dettach and attach again your database with only one log file

  • September 14, 2005 at 11:26 pm

    #590003

    I need to truncate my primary log file.......which i am not able to delete

     

     


    subban

  • September 20, 2005 at 8:35 am

    #591357

    Can you post the error message for sp_repldone?

    karl

    Best regards
    karl

Viewing 10 posts - 1 through 9 (of 9 total)

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