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

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




<brettmanning24@xxxxxxxxx> wrote in message news:1188476294.790894.4490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: replication
    ... mode, when a session begins, the mirror server synchronizes the mirror ... database with the principal database as quickly as possible. ... substantial if the principal server is under a heavy work load or the ...
    (comp.databases.ms-sqlserver)
  • RE: Database Mirroring or Log Shipping?
    ... Log Shipping nothing but moving tlog from Primary to Secondary once restored ... "Because the mirror database is in a recovering state, ... snapshots are not an option for us b/c we have SQL 2005 STD. ...
    (microsoft.public.sqlserver.replication)
  • Re: ldf file is corrupt or missing - how to restore
    ... If your database is the partner in a mirroring session you have to restore the log with the "no recovery" option. ... On our mirror server the .ldf file is corrupt, but we have an actuel backup ...
    (microsoft.public.sqlserver.replication)
  • RE: Database Mirroring or Log Shipping?
    ... "Because the mirror database is in a recovering state, ... snapshots are not an option for us b/c we have SQL 2005 STD. ... Maybe Log Shipping is an alternative, but thought that I read that Log ...
    (microsoft.public.sqlserver.replication)
  • Setup Mirroring for the first time - Large DB
    ... Hi, I have a 500GB database I need to mirror across a 100MB WAN, I have ... Prior to establishing the database mirroring session, ... restored on the mirror server, and be in the Restoring state. ... of transaction log backups, you need a way to copy all the transaction log ...
    (microsoft.public.sqlserver.replication)