BUG: Tables Not Displayed in SEM After Backing Up Table

Last reviewed: April 16, 1997
Article ID: Q165281
The information in this article applies to:
  • Microsoft SQL Server, version 6.5 Service Pack 2
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 : kbbug6.50.sp2 kbusage SSrvEntMan
Version : 6.5.SP2
Platform : WINDOWS
Issue type : kbbug
Resolution Type : kbpending


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 16, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.