Database Restores; Terminates Abnormally

Hi to All!
i have data base restore problem. i have backed up data base with verify
the backup option last w now i have server crash and i have two
recent backups with me. When i restore the latest one it terminates
abnormally. when i restore the other backup it restores okay. what may
be the problem in restoring the latest backup or which optin i shuould
select in the options to restore the data sucessfully.
Thanx
*** Sent via Developersdex http://www.examnotes.net ***Hi Ghulam,
What error do you get when the restore fails ?
"Ghulam Farid" wrote:

> Hi to All!
> i have data base restore problem. i have backed up data base with verify
> the backup option last w now i have server crash and i have two
> recent backups with me. When i restore the latest one it terminates
> abnormally. when i restore the other backup it restores okay. what may
> be the problem in restoring the latest backup or which optin i shuould
> select in the options to restore the data sucessfully.
> Thanx
>
> *** Sent via Developersdex http://www.examnotes.net ***
>

Database restore error

I've been trying to restore a database from a .bak file, but I receive the
next error message:
RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
An internal consistency error occurred. Contact Technical Support for
assistance. [SQLSTATE 42000] (Error 3270). The step failed.
Any idea what's this?
Thanks
Sounds like the backup file could be bad. Try executing a
restore headeronly to see if you get any errors when trying
to read the header - and what information is reported for
what is in the backup file if it executes without errors.
-Sue
On Fri, 3 Nov 2006 13:51:02 -0800, alejandro
<alejandro@.discussions.microsoft.com> wrote:

>I've been trying to restore a database from a .bak file, but I receive the
>next error message:
>RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
>An internal consistency error occurred. Contact Technical Support for
>assistance. [SQLSTATE 42000] (Error 3270). The step failed.
>Any idea what's this?
>Thanks
|||Hi,
I had a similar issue before and that caused because Database backup was not
fully completed. Verify the source database server for
enough hard disk space. I recommend you to take a full database backup and
try restore...
As far as I know you can do much with corrupted backup file...
Thanks
Hari
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:8E712F6C-EC6A-4E7C-9BF5-50B70557E3B8@.microsoft.com...
> I've been trying to restore a database from a .bak file, but I receive the
> next error message:
> RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
> An internal consistency error occurred. Contact Technical Support for
> assistance. [SQLSTATE 42000] (Error 3270). The step failed.
> Any idea what's this?
> Thanks
|||Hari Prasad wrote:
[vbcol=seagreen]
> Hi,
> I had a similar issue before and that caused because Database backup was not
> fully completed. Verify the source database server for
> enough hard disk space. I recommend you to take a full database backup and
> try restore...
> As far as I know you can do much with corrupted backup file...
> Thanks
> Hari
>
> "alejandro" <alejandro@.discussions.microsoft.com> wrote in message
> news:8E712F6C-EC6A-4E7C-9BF5-50B70557E3B8@.microsoft.com...
check validity of your backup using
restore verifyonly from disk = <backup path>
look at BOL for verfiying backups
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9c0a9c0b-64ba-4d3d-95d5-e09fb05d6154.htm
Regards
Amish Shah
http://shahamishm.tripod.com

Database restore error

I've been trying to restore a database from a .bak file, but I receive the
next error message:
RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013
)
An internal consistency error occurred. Contact Technical Support for
assistance. [SQLSTATE 42000] (Error 3270). The step failed.
Any idea what's this?
ThanksSounds like the backup file could be bad. Try executing a
restore headeronly to see if you get any errors when trying
to read the header - and what information is reported for
what is in the backup file if it executes without errors.
-Sue
On Fri, 3 Nov 2006 13:51:02 -0800, alejandro
<alejandro@.discussions.microsoft.com> wrote:

>I've been trying to restore a database from a .bak file, but I receive the
>next error message:
>RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 301
3)
>An internal consistency error occurred. Contact Technical Support for
>assistance. [SQLSTATE 42000] (Error 3270). The step failed.
>Any idea what's this?
>Thanks|||Hi,
I had a similar issue before and that caused because Database backup was not
fully completed. Verify the source database server for
enough hard disk space. I recommend you to take a full database backup and
try restore...
As far as I know you can do much with corrupted backup file...
Thanks
Hari
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:8E712F6C-EC6A-4E7C-9BF5-50B70557E3B8@.microsoft.com...
> I've been trying to restore a database from a .bak file, but I receive the
> next error message:
> RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 30
13)
> An internal consistency error occurred. Contact Technical Support for
> assistance. [SQLSTATE 42000] (Error 3270). The step failed.
> Any idea what's this?
> Thanks|||Hari Prasad wrote:
[vbcol=seagreen]
> Hi,
> I had a similar issue before and that caused because Database backup was n
ot
> fully completed. Verify the source database server for
> enough hard disk space. I recommend you to take a full database backup and
> try restore...
> As far as I know you can do much with corrupted backup file...
> Thanks
> Hari
>
> "alejandro" <alejandro@.discussions.microsoft.com> wrote in message
> news:8E712F6C-EC6A-4E7C-9BF5-50B70557E3B8@.microsoft.com...
check validity of your backup using
restore verifyonly from disk = <backup path>
look at BOL for verfiying backups
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9c0a9c0b-64ba-4d3d-95d5-e09f
b05d6154.htm
Regards
Amish Shah
http://shahamishm.tripod.com

Database restore error

I've been trying to restore a database from a .bak file, but I receive the
next error message:
RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
An internal consistency error occurred. Contact Technical Support for
assistance. [SQLSTATE 42000] (Error 3270). The step failed.
Any idea what's this?
ThanksSounds like the backup file could be bad. Try executing a
restore headeronly to see if you get any errors when trying
to read the header - and what information is reported for
what is in the backup file if it executes without errors.
-Sue
On Fri, 3 Nov 2006 13:51:02 -0800, alejandro
<alejandro@.discussions.microsoft.com> wrote:
>I've been trying to restore a database from a .bak file, but I receive the
>next error message:
>RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
>An internal consistency error occurred. Contact Technical Support for
>assistance. [SQLSTATE 42000] (Error 3270). The step failed.
>Any idea what's this?
>Thanks|||Hi,
I had a similar issue before and that caused because Database backup was not
fully completed. Verify the source database server for
enough hard disk space. I recommend you to take a full database backup and
try restore...
As far as I know you can do much with corrupted backup file...
Thanks
Hari
"alejandro" <alejandro@.discussions.microsoft.com> wrote in message
news:8E712F6C-EC6A-4E7C-9BF5-50B70557E3B8@.microsoft.com...
> I've been trying to restore a database from a .bak file, but I receive the
> next error message:
> RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
> An internal consistency error occurred. Contact Technical Support for
> assistance. [SQLSTATE 42000] (Error 3270). The step failed.
> Any idea what's this?
> Thanks|||Hari Prasad wrote:
> Hi,
> I had a similar issue before and that caused because Database backup was not
> fully completed. Verify the source database server for
> enough hard disk space. I recommend you to take a full database backup and
> try restore...
> As far as I know you can do much with corrupted backup file...
> Thanks
> Hari
>
> "alejandro" <alejandro@.discussions.microsoft.com> wrote in message
> news:8E712F6C-EC6A-4E7C-9BF5-50B70557E3B8@.microsoft.com...
> > I've been trying to restore a database from a .bak file, but I receive the
> > next error message:
> >
> > RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
> > An internal consistency error occurred. Contact Technical Support for
> > assistance. [SQLSTATE 42000] (Error 3270). The step failed.
> >
> > Any idea what's this?
> >
> > Thanks
check validity of your backup using
restore verifyonly from disk = <backup path>
look at BOL for verfiying backups
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9c0a9c0b-64ba-4d3d-95d5-e09fb05d6154.htm
Regards
Amish Shah
http://shahamishm.tripod.com