SQL Server Performance

How to make database back to standby mode

Discussion in 'SQL Server 2005 Log Shipping' started by cplimmy, Sep 23, 2009.

  1. cplimmy New Member

    Hi all,
    I can use (restore database ‘databasename’ with recovery) to restore the standby database to non-standby.
    But, how can I make the database back to standby mode?
    thanks in advance.
  2. arunyadav Member

    Hello,
    There isn't a way to put a database into stand-by mode without restoring the database from a backup at the same time.
  3. cplimmy New Member

    Hi Arun,
    Thanks for explanation.
    rgds,
    CP

Share This Page