Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-04 : 07:13:47
|
| Varma writes "Hi,When i try to attach the MDF file using the following script in MSSQL7.0.EXEC sp_attach_single_file_db @dbname = 'MIT_RB', @physname = 'C:\MSSQL7\Data\MIT_RB_Data.MDF'the following error appears..Server: Msg 906, Level 22, State 2, Line 1Could not locate row in sysobjects for system catalog 'Sysobjects' in database 'MIT_RB'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.Connection Brokenif i use the following script..exec sp_attach_db @dbname='MIT_RB',@filename1 = 'C:\MSSQL7\Data\MIT_RB_Data.MDF',@filename2='C:\MSSQL7\Data\MIT_RB_Log.LDF'the following error message appears..The header for file 'C:\MSSQL7\Data\MIT_RB_Log.LDF' is not a valid database file header. The PageAudit property is incorrect.pls advise me how to recover my data. I dont have backup file to restore smoothly.regvarma" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-04 : 11:57:31
|
| It sounds like your files are corrupt. You'll need to use the last full backup to restore your database.Tara |
 |
|
|
|
|
|
Attach DB