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