BUG: Edit Database May Show Incorrect Values with a Log Size Over 2 GB (175412)
The information in this article applies to:
This article was previously published under Q175412
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbenv KB175412 |
|---|
|