UNSOLVED

agosar

updated

19 years ago

A

agosar

2 Posts

0

343

September 18th, 2007 23:00

REPLISTOR & SQL 2005 64 BIT REPLICATION FAILS

Hi Everyone,

We are using replistor 6.2 64-bit edition for replicating sql 2005 x64 on two servers running on win2k3 64 bit edition. The problem we facing while attaching the database on the 2nd server . It gives error as ' SQL DATABASE CANNOT BE ATTACHED, DATABASE IS ALREADY BEEN RESTORED' . The first server database is in read-only mode. 1st server is getting database updated via log shipping from a different Production server.

Any suggestion how to attach the database in this scenario?

Thanking you,
  • dramjass

    151 Posts

    122

    0

    Posted December 12th, 2007 07:00

    Are you trying to attach and have SQL services started on the Target machine while the Source is still replicating?