1

I'm trying to configure a mirror for a Test database between two SQL Server 2008 R1 SP1 Servers: A1 and A2

I'm doing a full backup of Test database on A1 and then trying to restore it on A2 with NORECOVERY option but database stucks in Restoring... mode. I've also tryed using WITH REPLACE option but no use

What might be wrong? The database is only one table with one row, i don't have any transactions it's just newly created database

4
  • @Derek but will i be able to set partner after in order for mirror to active? I'm following sql server standart mirroring guide
    – Troydm
    Sep 1, 2011 at 12:42
  • Sorry, I misread your question. Take a look at this: stackoverflow.com/questions/448088/…
    – Derek
    Sep 1, 2011 at 12:46
  • So you are saying it must be in restoring state when it's a secondary database that is not currently used and the primary database is active?
    – Troydm
    Sep 2, 2011 at 11:58
  • Yes, that is correct
    – Derek
    Sep 2, 2011 at 12:16

0

You must log in to answer this question.

Browse other questions tagged .