Unable to Setup Mirror on 1 Specific Database

[JohnBates]

Hi all,

I'm not a mirroring expert but I have been using SQL Server mirroring for awhile now. I have hit a situation with 1 database that baffles me.

I restore the db and the tlog and the state goes to "restoring" (as is normal).

The problem is that after enabling mirroring on the Mirror server, the database state changes to 'In recovery...'


BEGIN
RESTORE DATABASE WFM40
FROM DISK = 'E:\Microsoft SQL Server\Backups\OnDemand\WFM40_20090113162956.bak'
WITH
NORECOVERY,
MOVE N'WFM40' TO 'E:\Microsoft SQL Server\Data\WFM40.mdf',
MOVE N'WFM40_log' TO 'E:\Microsoft SQL Server\Data\WFM40_1.ldf'
END

BEGIN
RESTORE LOG WFM40
FROM DISK = 'E:\Microsoft SQL Server\Backups\OnDemand\WFM40_20090113163502.trn'
WITH NORECOVERY;
END

BEGIN
ALTER DATABASE WFM40
SET PARTNER='TCP://PNCLRMDB:5022'
END

Now the dataabse on the Mirror server shows "In recovery...." whereas the other databases I've configured for mirroring had 'Restoring' at this point (I think)

If I go ahead and set the mirror for the Primary:
Ran on primary:

BEGIN
ALTER DATABASE WFM40
SET PARTNER='TCP://PNCLRMDBCO:5022'
END

I get this error"

Msg 1408, Level 16, State 0, Line 2
The remote copy of database "WFM40" is not recovered far enough to enable database mirroring.

I have dropped the database (at the mirror) restored and still get this situation.
What am I doing wrong?

Thanks, john

 

[mrdenny]

Backup and restore another log file, or another log backup has already been done and needs to be restored to the mirror machine.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog