Error: 'Table 'sysfiles1' not found' when trying to read offline logs on a SQL Server 2008 Expres (4238968)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error: 'Table 'sysfiles1' not found' when trying to read offline logs on a SQL Server 2008 Expres
Description

On a SQL Server 2008 Express database, when trying to read offline log files, the following error appears:
'Table 'sysfiles1' not found'

There are no problems reading online logs though
Cause

When reading the backup file, Log Reader is based on the backup info, getting the correct sql server version (10, that is SQL2008), but when it reads the offline database file, it’s based on compatability level. Log Reader ‘thinks’ it’s a SQL2000 database.
Resolution

WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of LiteSpeed for SQL Server and Toad for SQL Server.
Defect ID

CR81383

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title