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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-11-01 : 13:23:39
|
| Hi,Can backup taken on:Version - Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22 2011 00:28:06 Copyright (c) 1988-2008 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.2 <X86> (Build 3790: Service Pack 2) (VM)restore on:Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (VM)Cannot restore. Need your help?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-11-01 : 14:22:35
|
| Should be able to restore, are you getting an error message? |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-11-01 : 14:42:10
|
| Getting this error:Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.Msg 5243, Level 22, State 6, Line 1An inconsistency was detected during an internal operation. Please contact technical support. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-11-01 : 15:28:51
|
| Your backup file may be corrupted. Can you make a new backup of the original database? You should run DBCC CHECKDB on both the original and the restored DB if you can restore it successfully. If it reports errors, DO NOT use a repair option without consulting someone first. |
|
|
|
|
|
|
Backup/Restore issue