FIX: Transaction Log Space Grows on Standby Server (279505)
The information in this article applies to:
This article was previously published under Q279505
BUG #: 55450 (SQLBUG_70)
SYMPTOMS
The percentage of log space reported as in use may be incorrect on a standby server that is being used by log shipping or as a hot standby server when the logs are restored using the WITH STANDBY option. This behavior is observed only when an index creation operation spans a log backup on the primary server that is subsequently restored on the standby server. You will see a higher value reported for the percentage of log space in use on the standby server than on the primary server.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0.
For more information, click the following article number to view the article in the Microsoft Knowledge Base: 274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
| Modification Type: | Major | Last Reviewed: | 3/14/2006 |
|---|
| Keywords: | kbBug kbfix KB279505 |
|---|
|