If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > An internal consistency error occurred

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-24-08, 11:14
Brett Kaiser Brett Kaiser is offline
SQLTeam Scrub
 
Join Date: Nov 2002
Location: Jersey
Posts: 9,976
An internal consistency error occurred

I think I'm hosed...anyone ever seen this before?

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.
__________________
Brett
8-)

It's a Great Day for America everybody!
My Blog
My SQL Blog dbforums Yak CorralRadio 'Rita
dbForums Member List SQLTeam Member List
It's 5:00 Somewhere Pearls
The physical order of data in a database has no meaning.
Reply With Quote
  #2 (permalink)  
Old 01-24-08, 11:37
r937 r937 is online now
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,045
i bet Technical Support has seen it, otherwise they wouldn't be telling you to contact them

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 01-24-08, 11:39
Diabolic Diabolic is offline
Registered User
 
Join Date: Jul 2007
Posts: 96
Last time I heard of that it was a problem with the connection that was corrupting the .bak file for a reason that I can't remember. However, that error can occur for many other reasons.

Do you get any errors when you do a DBCC CHECKDB?

Quote:
i bet Technical Support has seen it, otherwise they wouldn't be telling you to contact them
Reply With Quote
  #4 (permalink)  
Old 01-24-08, 12:05
Brett Kaiser Brett Kaiser is offline
SQLTeam Scrub
 
Join Date: Nov 2002
Location: Jersey
Posts: 9,976
Our "Technical Support" team said the D drive took a hit...whatever that means, and my guess is that they restored it....half of my db's are suspect now

I was able to restore 1 database, then I started to restore another and got that error

I'm taking a backup to another box now to see if it'ss restore there

I'm thinking I'll have to rebuild the whole box
__________________
Brett
8-)

It's a Great Day for America everybody!
My Blog
My SQL Blog dbforums Yak CorralRadio 'Rita
dbForums Member List SQLTeam Member List
It's 5:00 Somewhere Pearls
The physical order of data in a database has no meaning.
Reply With Quote
  #5 (permalink)  
Old 01-24-08, 12:05
tomh53 tomh53 is offline
9th inning DBA
 
Join Date: Jan 2004
Location: In a large office with bad lighting
Posts: 1,036
Quote:
Originally Posted by Brett Kaiser
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.
I've seen that before ... the backup was corrupted and I had to fall back to a previous day and use tran logs to get current - IMHO you are hosed on that backup file.
__________________

-- This is all just a Figment of my Imagination --
Reply With Quote
  #6 (permalink)  
Old 01-24-08, 12:11
Brett Kaiser Brett Kaiser is offline
SQLTeam Scrub
 
Join Date: Nov 2002
Location: Jersey
Posts: 9,976
Well I'm copying the backups to another server and I've got 5 per database

I hope the backups aren't corrupt

See...the importance of testing the backups is not lost on me now....I still think it's SQL Server itself that's corrupted

Somone mentioned something about the Reg keys
__________________
Brett
8-)

It's a Great Day for America everybody!
My Blog
My SQL Blog dbforums Yak CorralRadio 'Rita
dbForums Member List SQLTeam Member List
It's 5:00 Somewhere Pearls
The physical order of data in a database has no meaning.
Reply With Quote
  #7 (permalink)  
Old 01-24-08, 12:34
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
Quote:
Originally Posted by Brett Kaiser
Somone mentioned something about the Reg keys
Was it me?
Reply With Quote
  #8 (permalink)  
Old 01-24-08, 12:40
Brett Kaiser Brett Kaiser is offline
SQLTeam Scrub
 
Join Date: Nov 2002
Location: Jersey
Posts: 9,976
Quote:
Originally Posted by pootle flump
Was it me?

No

Nice new title
__________________
Brett
8-)

It's a Great Day for America everybody!
My Blog
My SQL Blog dbforums Yak CorralRadio 'Rita
dbForums Member List SQLTeam Member List
It's 5:00 Somewhere Pearls
The physical order of data in a database has no meaning.
Reply With Quote
  #9 (permalink)  
Old 01-24-08, 15:14
Brett Kaiser Brett Kaiser is offline
SQLTeam Scrub
 
Join Date: Nov 2002
Location: Jersey
Posts: 9,976
Backup was corrupted

When I tried to restore it on another box, I got the same thing

Damn, now I gotta try'em all until I find a good one
__________________
Brett
8-)

It's a Great Day for America everybody!
My Blog
My SQL Blog dbforums Yak CorralRadio 'Rita
dbForums Member List SQLTeam Member List
It's 5:00 Somewhere Pearls
The physical order of data in a database has no meaning.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On