SQL Server Table Corruption Error

Question

SQL Server Table Corruption Error

Obesnard

SSC Rookie

Points: 40
More actions
February 21, 2018 at 4:21 am

#333695

I am new here. Glad to join the community!
Yesterday I installed SQL Server2012. Tried to open .mdf extension file which was e-mailed to me.
But the file showing a warning message "SQL Server Table Corruption Error".
Appreciate any help here!
February 21, 2018 at 9:27 pm

This was removed by the editor as SPAM
February 22, 2018 at 11:07 pm

This was removed by the editor as SPAM
February 26, 2018 at 11:19 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

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

Thom A SSC Guru Points: 99126 More actions · Answer 1

What do you mean my "tried to open"? You don't open a .mdf file, you have to attach it to the Instance. What steps did you take to get the error?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Eirikur Eiriksson SSC Guru Points: 182881 More actions · Answer 2

Obesnard - Wednesday, February 21, 2018 4:21 AM
I am new here. Glad to join the community!
Yesterday I installed SQL Server2012. Tried to open .mdf extension file which was e-mailed to me.
But the file showing a warning message "SQL Server Table Corruption Error".
Appreciate any help here!

Hi and welcome!
Did you get this error when you tried to attach the database?
😎

Obesnard SSC Rookie Points: 40 More actions · Answer 3

Obesnard

SSC Rookie

Points: 40

February 21, 2018 at 4:32 am

#1980596

Yeah.
I tried to attach the database

Thomas Rushton SSC-Insane Points: 22648 More actions · Answer 4

The .mdf file that was mailed to you... what version of SQL Server was that from? If it was from a later version, then you won't be able to attach it to your SQL 2012 instance.

Thomas Rushton
blog: https://thelonedba.wordpress.com

Eirikur Eiriksson SSC Guru Points: 182881 More actions · Answer 5

Obesnard - Wednesday, February 21, 2018 4:32 AM
Yeah.
I tried to attach the database

Could you ask to have a backup file instead of the mdf? This is normally better as if the mdf is copied at the source with the server running, it may very likely become corrupt, especially if there is activity on the source system.
😎

When you have the backup file(s), then you can verify version etc.

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 6

It's helpful for you to explain the exact steps or show code, and then the exact error.