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 |
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2006-01-05 : 22:50:11
|
Guys,I trying to restore a database using .bak file, I get the following error "internal consistency occured contact technical support for assistance rectore database is terminating abnormally"Any suggestions/inputs for reasons on this errorThanks |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-01-05 : 23:24:06
|
There can be two reason for this error.1) The backup file is corruptIncase the backup file is corrupt there are few tools available to recover the data for objects in database.2) The backup is not complete. If the backup is not complete, get the complete back. If its a transactional backup then make sure that you are restoring Latest Full , Latest Differential (If Any) and then the transactional backup.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
Arijit
Starting Member
25 Posts |
Posted - 2006-01-05 : 23:49:38
|
Hi,I had also faced this problem before.But the experience was very bad. Not even third party tool could recover the file.But you can try it out.But it is better take a another backup and do the necessary job.RegardsArijit Chatterjee |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-06 : 06:53:22
|
People, I hate to point it out to you that if he/she is trying to restore the db then it's hightly unlikely that he/she will be able to make another backup hence he/she is trying to restore it.scelamkowhen you made the backup did you run any data verification?Check your backupReports/backupHtmlReport if you made any for more infoIf you want your computer to be faster then throw it out of the window. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-06 : 09:37:37
|
"when you made the backup did you run any data verification?"My considered opinion is that the only verification of a SQL Backup worth its salt is to try to restore it on a different machineKristen |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-09 : 01:11:21
|
quote: My considered opinion is that the only verification of a SQL Backup worth its salt is to try to restore it on a different machine
Well Said!RegardsNIf you want your computer to be faster then throw it out of the window. |
|
|
|
|
|