recovery mode to standby mode

• Joe-420121

  Hall of Fame

  Points: 3152

  More actions

  January 14, 2008 at 3:22 pm

  #185532

  I have setup sql 2000 log shiping. The db size is 300GB. By mistake, when try to restore the BAK, I did not choose stand by option. The log ship needs the db in stand by mode to apply LOG. How to bring the db to stand by quickly without restoring the whole BAK file again which takes 4 hours.

  Pls help. Thanks in advance.

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  January 14, 2008 at 3:24 pm

  #767898

  If the database was recovered, you have to do a restore.