Wednesday, March 28, 2012

MS SQl server2000 Restoration

when I restored backup file from system to another system
gave me the message "An internal consistency error
occurred.Contact Technical Support for assistance.Restore
Database is Terminating abnormally"
Abdelzahir abdelmaboud
Sudatel Co.
DBA
abdzahir@.hotmail.com
Abdelzahir,
Perhaps the database was corrupt before you backed it up? Can you run
DBCC CHECKDB on the source database, and back it up again? Are you using
SQL Server native backup commands to do this or an external component
such as Litespeed? Very occasionally, external components can corrupt a
backup file.
It sounds like the database was corrupt before you backed it up, and
then it can't restore it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Abdelzahir Abdelmaboud wrote:
> when I restored backup file from system to another system
> gave me the message "An internal consistency error
> occurred.Contact Technical Support for assistance.Restore
> Database is Terminating abnormally"
> Abdelzahir abdelmaboud
> Sudatel Co.
> DBA
> abdzahir@.hotmail.com

No comments:

Post a Comment