Internal Consistancy Error
-
Hi:
I have two files created on sql 7, my mdf and ldf files. I am trying to recreate my database doing a restore after a crash. I am using sql 2000. I get an Internal Consistancy error trying to attach the mdf and ldf files. This happens about half way through.
Any ideas?
-
I was able to fix my problem using some free software from these guys:
http://www.officerecovery.com/mssql/index.htm
-
Hi ,
This is Minaz Amin.
- What is the exact error message you receive?
- Are trying to attach user database or system database? Because, you cannot restore a backup of a system database (master, model, or msdb) on a server build that is different from the build on which the backup was originally performed. An attempt to perform such a restore causes the following error message to occur:
Server: Msg 3168, Level 16, State 1, Line 1The backup of the system database on device d:\temp\master.bak cannot be restored because it was created by a different version of the server (134217904) than this server (134217920).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
- Is the mdf and the ldf file are of the same database, Because if the mdf and ldf files are of not the same database you will receive error message while attaching the database.
I think you have backup of the database . Try to restore it and then run DBCC CHECKDB.
Please review the followings links for more info:
http://support.microsoft.com/kb/885712/en-us
http://support.microsoft.com/kb/264474/en-us
http://support.microsoft.com/kb/224071/en-us
http://support.microsoft.com/kb/314546/en-us
http://support.microsoft.com/kb/285165/en-us
http://support.microsoft.com/kb/837938/en-us
Do let me know futher..
Regards,
Minaz Amin
Email : meenakshikundar@yahoo.com
Ph:9341735900.
"More Green More Oxygen !! Plant a tree today"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply