BUG: Tables Not Displayed in SEM After Backing Up TableLast reviewed: April 16, 1997Article ID: Q165281 |
The information in this article applies to:
SYMPTOMSAfter you back up a table on SQL Enterprise Manager (SEM), user tables are not displayed in the Server Manager window. This problem is more apparent when you click the Table Device radio button before the Initialize Device radio button and dump a table to a new backup device or a backup device that is being initialized. You do not experience this problem when you append to an existing dump device.
WORKAROUNDTo work around this problem, close and reopen SQL Enterprise Manager to view all the tables.
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.5 Service Pack 2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONIf the backup device has more than one dump on it and you follow the steps again, only this time clicking the Initialize Device radio button before the Table Device radio button in the Backup/Restore screen, you will still see the tables. NOTE: If sqltrace is on, you will not see the tables, regardless of whether or not you click the Initialize Device radio button first. In SQL Server 6.5 (no service packs), you do not experience any problems unless sqltrace is on, in which case you see similar problems.
|
Additional query words: sql65
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |