up vote 1 down vote favorite
share [g+] share [fb]

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

link|improve this question
83% accept rate
@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: stackoverflow.com/questions/448088/… – 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
feedback

migrated from stackoverflow.com Sep 1 '11 at 14:26

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.