Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from Sep 1 '11 at 14:26

This question came from our site for professional and enthusiast programmers.

@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 '11 at 12:42
Sorry, I misread your question. Take a look at this:… – Derek Kromm Sep 1 '11 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 '11 at 11:58
Yes, that is correct – Derek Kromm Sep 2 '11 at 12:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.