How to make database back to standby mode

  • Hi All,

    before my database was in standby i make it online using

    restore database <name> with recovery

    but now again i want to put my database in standby

    can any one tell me how i can do this.

  • You'll have to restore the most recent back with standby

    The probability of survival is inversely proportional to the angle of arrival.

  • rajeshjaiswalraj (11/15/2013)


    Hi All,

    before my database was in standby i make it online using

    restore database <name> with recovery

    but now again i want to put my database in standby

    can any one tell me how i can do this.

    why did you bring the standby database online, is it part of a log shipping plan?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply