SQL Server Performance

Stop secondary db restore

Discussion in 'SQL Server 2005 Log Shipping' started by DSO, Oct 17, 2008.

  1. DSO New Member

    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?
  2. ghemant Moderator

    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!
  3. DSO New Member

    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.
  4. satya Moderator

Share This Page