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.
    cplimmy, Sep 23, 2009
    #2

  2. arunyadav New 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.
    arunyadav, Sep 23, 2009
    #3

  3. cplimmy New Member

    Hi Arun,
    Thanks for explanation.
    rgds,
    CP
    cplimmy, Sep 24, 2009
    #4

Share This Page