BUG: Tables Not Displayed in SEM After Backing Up Table

• Microsoft SQL Server, version 6.5 Service Pack 2

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.