Post reply

Restore DB that insert record to linked server by DDL

  • November 29, 2007 at 6:51 pm

    #121304

    Hello..

    I have restore problem.

    In my production server there's a DB that have DDL.

    This DDL insert to another DB on linkedserver.

    I have a full DB backup.

    When I try to restore on my local PC (i don't have linked server), i've got an error message

    “Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction”

    Is this error caused by DDL that insert to DB on linked server ?..

    How can I restore to my local PC ?

    thanks

    Ronsi

  • November 29, 2007 at 7:40 pm

    #755770

    Sorry...

    I missed the 'trigger' word 🙂

    I re-write my post :

    Hello..

    I have restore problem.

    In my production server there's a DB that have DDL Trigger

    This DDL insert to another DB on linkedserver.

    I have a full DB backup.

    When I try to restore on my local PC (i don't have linked server), i've got an error message

    “Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction”

    Is this error caused by DDL Trigger that insert to DB on linked server ?..

    How can I restore to my local PC ?

    thanks again..

    Ronsi

  • November 29, 2007 at 11:37 pm

    #755819

    do a checkpoint then try to backup and restore hjope this solves.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 3 posts - 1 through 2 (of 2 total)

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