sql server replication: The remote copy of database is not recovered far enough to enable database mirroring. -- sql server replication

Re: The remote copy of database is not recovered far enough to enable database mirroring.

Ekrem_Önsoy
8/30/2007 12:00:00 AM

sql server replication:

How about taking a up to date transactional log backup from the primary and
restore it in norecovery mode to the mirror database and then finalize the
setting up your database mirroring operation?

--
Ekrem Önsoy

[quoted text, click to view]

The remote copy of database is not recovered far enough to enable database mirroring.

brettmanning24 NO[at]SPAM gmail.com
8/30/2007 5:18:14 AM

Hi,

I am having problems setting up database mirroring (SQL Server 2005).
I made a backup of my database and transaction log, I restore this on
my Mirror server. I established the end points and I set the partner
on my mirror server, I then received the error "The remote copy of
database "DBNAME" is not recovered far enough to enable database
mirroring". when attempting to set the partner on my primary server.

The database status on the mirror is "RESTORING".

Please can someone help!

Thanks,

Brett

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.