I am trying to restore a database sent from a client and getting the below
error in the process:
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for
assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any ideas why ?.
It is a SQL Server 2000 backup going into another SQL Server 2000 server.
Thanks.
DXC,
If their database is in an inconsistent state, the backup will carry that
state to you. They should run DBCC CHECKDB on their database to try to
determine what is wrong, fix it if possible, then send you a new backup.
RLF
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:267D80B1-6158-43C5-9252-46B8BCD169DE@.microsoft.com...
>I am trying to restore a database sent from a client and getting the below
> error in the process:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any ideas why ?.
> It is a SQL Server 2000 backup going into another SQL Server 2000 server.
> Thanks.
|||Russell, Thanks for the quick reply...........Also, I get the following
message when I run RESTORE VERIFYONLY.
Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'D:\MTTBRP7_db_200802182100.BAK' is not a valid Microsoft
Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
"Russell Fields" wrote:
> DXC,
> If their database is in an inconsistent state, the backup will carry that
> state to you. They should run DBCC CHECKDB on their database to try to
> determine what is wrong, fix it if possible, then send you a new backup.
> RLF
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:267D80B1-6158-43C5-9252-46B8BCD169DE@.microsoft.com...
>
>
|||DXC,
Sorry, I don't really know, but here are a couple of posts that might help
you think of something. (I don't suppose that this backup is from SQL
Server 6.5 or earlier, is it?)
http://msdn2.microsoft.com/en-us/library/aa238234(SQL.80).aspx
http://support.microsoft.com/?kbid=905616
http://www.webservertalk.com/archive132-2004-7-330939.html
RLF
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:8803F9CE-B0A1-4E5B-A39F-BF73DFDBC1C0@.microsoft.com...[vbcol=seagreen]
> Russell, Thanks for the quick reply...........Also, I get the following
> message when I run RESTORE VERIFYONLY.
> Server: Msg 3242, Level 16, State 2, Line 1
> The file on device 'D:\MTTBRP7_db_200802182100.BAK' is not a valid
> Microsoft
> Tape Format backup set.
> Server: Msg 3013, Level 16, State 1, Line 1
> VERIFY DATABASE is terminating abnormally.
>
> "Russell Fields" wrote:
|||No it is not. It is from SQL Server 2000 server............Thanks......
"Russell Fields" wrote:
> DXC,
> Sorry, I don't really know, but here are a couple of posts that might help
> you think of something. (I don't suppose that this backup is from SQL
> Server 6.5 or earlier, is it?)
> http://msdn2.microsoft.com/en-us/library/aa238234(SQL.80).aspx
> http://support.microsoft.com/?kbid=905616
> http://www.webservertalk.com/archive132-2004-7-330939.html
> RLF
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:8803F9CE-B0A1-4E5B-A39F-BF73DFDBC1C0@.microsoft.com...
>
>
|||DXC,
I don't know what else to do except get another backup from them. Were you
able to do that and did it work?
RLF
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:FFA04E40-48DA-4590-9832-EC44415EFFDB@.microsoft.com...[vbcol=seagreen]
> No it is not. It is from SQL Server 2000
> server............Thanks......
> "Russell Fields" wrote:
No comments:
Post a Comment