Microsoft KB Archive/165281

= BUG: Tables Not Displayed in SEM After Backing Up Table =

Article ID: 165281

Article Last Modified on 3/1/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Service Pack 2

-



This article was previously published under Q165281



BUG #: 16697 (NT: 6.50)



SYMPTOMS
After 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.



WORKAROUND
To work around this problem, close and reopen SQL Enterprise Manager to view all the tables.



STATUS
Microsoft 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 INFORMATION
If 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

Keywords: kbbug kbpending kbusage KB165281

-

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

© Microsoft Corporation. All rights reserved.