 |
|
|
|
Next: Management Studio crashes when connecting to a DB
|
| Author |
Message |
External
Since: Apr 20, 2005
Posts: 37
|
(Msg. 1) Posted: Fri Feb 22, 2008 12:31 pm
Post subject: Database Restore Error - URGENT
Archived from groups: microsoft>public>sqlserver>server (more info?)
|
|
|
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. |
|
| Back to top |
|
 | |
External
Since: Feb 21, 2007
Posts: 457
|
(Msg. 2) Posted: Fri Feb 22, 2008 3:39 pm
Post subject: Re: Database Restore Error - URGENT [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
>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. |
|
| Back to top |
|
| |
External
Since: Apr 20, 2005
Posts: 37
|
(Msg. 3) Posted: Fri Feb 22, 2008 3:39 pm
Post subject: Re: Database Restore Error - URGENT [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
>
> >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.
>
>
> >> Stay informed about: Database Restore Error - URGENT |
|
| Back to top |
|
| |
External
Since: Feb 21, 2007
Posts: 457
|
(Msg. 4) Posted: Fri Feb 22, 2008 5:13 pm
Post subject: Re: Database Restore Error - URGENT [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> 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" wrote in message
>>
>> >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.
>>
>>
>> >> Stay informed about: Database Restore Error - URGENT |
|
| Back to top |
|
| |
External
Since: Apr 20, 2005
Posts: 37
|
(Msg. 5) Posted: Fri Feb 22, 2008 5:13 pm
Post subject: Re: Database Restore Error - URGENT [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
>
> > 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" wrote in message
> >>
> >> >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.
> >>
> >>
> >>
>
>
> >> Stay informed about: Database Restore Error - URGENT |
|
| Back to top |
|
| |
External
Since: Feb 21, 2007
Posts: 457
|
(Msg. 6) Posted: Tue Feb 26, 2008 9:17 am
Post subject: Re: Database Restore Error - URGENT [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> 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" wrote in message
>>
>> > 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" wrote in message
>> >>
>> >> >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.
>> >>
>> >>
>> >>
>>
>>
>> >> Stay informed about: Database Restore Error - URGENT |
|
| Back to top |
|
| |
| Related Topics: | restore database - I trying to rrestore a database from BAK file and I get an error microsoft sql -dmo (odbc sqlstate:4200). device activation error the physical file *.ldf/*.mdf may be incorrect. what I am doing wrong. someone can help me. Thanks.
vista restore database - Hi, We have an app that allows users (both admin and non-admin) to copy a backup file from a remote file to a local folder, then do a restore so they can look at archived data (the restore is done to a new name so as not to overwrite the current..
Timeout error message on restore job - Hi all knowing MSDN experts! I'm trying to do a restore from a DDS4 back up tape but everytime I select the tape from the restore devices (in the Specify Backup window) I get the error message: Timeout expired. The timeout period elapsed prior to the...
Percent of advance in Restore database - I am making a huge restore database with sql server 2000 and I need to know how to find the percent of advance of the operation. I cannot find it
Urgent - General Network Error - Hi , I have a subscription that keeps failing to synchronise with the following error : "General Network Error. Check your network documentation" how can i check the cause & resolve ? kindly advise |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
