I am testing standby mode versus norecovery mode. I have a primary server A and a secondary server B. server B is setup in norecovery mode as a secondary db to A. I made a duplicate copy of server B now called C. C is running just as B but there is no connection to the primary A. How can I stop C from constant restoriung mode so I can set it up as a standby db to A?
Hi, Welcome to the Forums!! Do you mean your database is showing in "Restoring mode' ? if so, you can run restore database [dbname] with recovery Or else please elaborate!
Yes. It is staying in recovery mode. We need to verify that it is working and data will bew there if we need to swap to it. This is a copy of the main secondary server. What we want to do is setup a second secondary server to run in standby mode. this way we can run queries against the data to verify that it is working.
http://msdn.microsoft.com/en-us/library/ms189970.aspx and How to: Add a Secondary Database (SQL Server Management Studio) fi
