BUG: Edit Database May Show Incorrect Values with a Log Size Over 2 GB

ID: Q175412


The information in this article applies to:
  • Microsoft SQL Server version 6.5

BUG #: 16781 (NT: 6.5)

SYMPTOMS

If a database is created with a log size of over 2 GB, the Edit Database dialog box in SQL Enterprise Manager may incorrectly report Log Size as zero.


WORKAROUND

To work around this problem, use the following query to return the log size in MB for the database:


   select (sum(size)/512) from master..sysusages
   where dbid = db_id('<database_name>') and segmap = 4 


STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: SEM disk space free 0

Keywords : kbenv SSrvEntMan kbbug6.50
Version : WINNT:6.5
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: April 17, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.