Administering secondary database in log shipping

• Keith Lewis

  SSC Rookie

  Points: 37

  More actions

  May 5, 2006 at 6:40 am

  #172423

  Is there a way to bring the secondary database out of standby/read-only mode and make changes to the database(such as make the files bigger) and then put it back into standby/read-only mode and start log shipping again without doing a restore using the primary's backup?   I have tried making a backup of the secondary and restoring with that but the logs will not apply then.  

  Any guidance would be appreciated.

• May 8, 2006 at 8:00 am

  This was removed by the editor as SPAM

• mike mcneer

  Ten Centuries

  Points: 1189

  More actions

  May 10, 2006 at 10:25 am

  #637052

  Unfortunately I think you already have the answer. Drop recreate, re-import backup.

  MM