Title: MS-SQL restore fails with Logical file 'DB_Name' is not part of database 'corrupt_DB'
Date: Jul 2006
NV Version: N/A
OS Version: Windows 2003
Application version: 8/2000
Plugin version: 4.108
Description:
SQL database corruption can prevent the normal restore (rename/relocate) and recovery of an MS SQL database
Symptoms:
Error 2006/07/20 11:53:33 664 Data Plugin NVclient [Microsoft][ODBC SQL Server Driver][SQL Server]Logical file 'your_DB_Name' is not part of database 'your_corrupt_DB'. Use RESTORE FILELISTONLY to list the logical file names.
The corruption means that the transaction log cannot be truncated, leaving a disproportionately large transaction log, e.g.;
19/10/2006 03:07 3,377,594,368 your_DB_Name.mdf
19/10/2006 03:07 5,971,968,000 your_DB_Name_log.ldf
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center