SQL Server Performance

Log Shipping Restore Fails

Discussion in 'SQL Server Log Shipping' started by biged123456, Aug 18, 2005.

  1. biged123456 New Member

    I had log shipping running for a couple days secussfully. It runs every 5 minutes. Between 9pm and about 11pm, we update the DB with significant amounts of data. The TL copy process (east coast to west coast) is large enough to cause my data sync errors to go off. Most nights, the TL finally gets to the west coast and then they are restored without problem. This is completed usually by 2am.

    Last night, we rebooted the standby server to patch it. This morning, the restore jobs are in error and we have found that the restores have not been secussful since the reboot. The error in the SQL error logs is:
    Database 'PROD' (database ID 7) was marked for standby or read-only use, but has been modified. The RESTORE LOG statement cannot be performed..

    The PROD database is in read only mode and has a status of 2098176 in sysdatabases. I originally setup shipping for standby mode, so I would expect the DB to be in read only when updates are not happening, but I don't know that the status is correct now.

    I can certainly just setup log shipping again, but I would prefer to figure out what happen first.

    Any ideas?
  2. satya Moderator

    What kind of patch you've applied to the standby server?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. biged123456 New Member

    Woops. Forgot to check back on this. I ended up opening a case with Microsoft on this. It was determined that for some reason, when SQL started up, it recovered my database. They were not sure why, but offered to run profiler to see if it happens again. Not really something I was interested in. We resetup log shipping and all has been well...
  4. satya Moderator

    Well sometimes it works out if you do the process from scratch [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>

Share This Page