Problem Restoring a SQL 2000 database

Question

Post reply

Problem Restoring a SQL 2000 database

Edward Boyle-478467

Ten Centuries

Points: 1165
More actions
December 21, 2009 at 1:04 pm

#136142

:crying:Trying to Restore a SQL 2000 database and getting the following error
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.
When I searched this error message, I foud a link to http://support.microsoft.com/kb/268481
Refers to an issue with DPT RAID controller card [not what we are using]
When I ran the following, all was OK
RESTORE FILELISTONLY
FROM Disk='C:\Backup\PTrackDB_db_200912141703.BAK'
RESTORE verifyonly
FROM Disk='C:\Backup\PTrackDB_db_200912141703.BAK'
RESTORE HEADERONLY
FROM Disk='C:\Backup\PTrackDB_db_200912141703.BAK'
When I run
restore database PBData01
From Disk='C:\Backup\PTrackDB_db_200912141703.BAK'
With
File=1,
Recovery,
Move 'ptDev' To 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ptDev.mdf',
Move 'ptLogDev' To 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ptLogDev.ldf'
I get the error:
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/sugesstions/help appreciated
Thanks
Eddie

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

You may not want to hear this, but I think your backup file is hosed.

Do you have a previous backup file and differential/transaction log backup files?

Edward Boyle-478467 Ten Centuries Points: 1165 More actions · Answer 2

Thanks.

Unfortunately, the good backups are a few weeks old.

That said, any ideas on the cause? Could it be the disk controller as suggested on the Microsoft KB?

Eddie

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Possibly. What is the recover model of the database?

Edward Boyle-478467 Ten Centuries Points: 1165 More actions · Answer 4

Edward Boyle-478467

Ten Centuries

Points: 1165

December 21, 2009 at 1:20 pm

#1095061

Recovery Model =Full

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Do you have any transaction log and/or differential backups between the previous full backup and this one that appears to be corrupt?

Edward Boyle-478467 Ten Centuries Points: 1165 More actions · Answer 6

This is not a huge database [about 100 Mb] and our IT guy did a full backup daily.

Problem arose when he moved the database to a Virtual server and a new disk subsystem. The older backups from the physical server are good. Made DBA mistake #1 by not verifying the backups after the move.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Forgetting your problem at the moment, let me get this straight; database using full recovery model, daily full backups, no transaction log backups? You do realize that the transaction log is simply growing every day? It is only truncated (space reused) by accomplishing transaction log backups.