Microsoft KB Archive/311115

= INF: Correction for Microsoft SQL Server 2000 Resource Kit =

Article ID: 311115

Article Last Modified on 9/14/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q311115



SUMMARY
This article contains a correction and information about an error message that relates to the Microsoft Press book &quot;Microsoft SQL Server 2000 Resource Kit&quot;; ISBN 0-7356-1266-8.



MORE INFORMATION
In the &quot;Microsoft SQL Server 2000 Resource Kit&quot;, page 385, in the &quot;Generating Database Backups from the Secondary&quot; topic, the first sentence of the topic states:

Since the log shipped database is only a small increment of time out of sync with the primary database, it is a good idea to use it to generate the full database backups.

The preceding statement implies that you can back up the log shipped database on the secondary server, which is incorrect. The log shipped database on the secondary server is in a read-only state and you cannot use that database to generate any type of SQL Server backup.

The Log Shipping process leaves the database on the secondary server in either a STANDBY or a LOADING status depending upon which option you select when you configure Log Shipping. Both STANDBY and LOADING are read-only states, which prevents any writes to the transaction log. Because the backup process needs to log its operations (backup history), and changes to the transaction log are disallowed, SQL Server does not allow you to perform backups performed against a log shipping secondary database.

Keywords: kbinfo KB311115

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.