[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2286
  • Last Modified:

Attach Single File (MDF) Problem

Hey,
I got sent a mdf file that i need to attach to my sql server (2k).
I thought this would be pretty stright forward but it looks like i was worng. I am not a guru in SQL or server admin but i have gotten along decently in the past.

I try to attach using this command
exec sp_attach_single_file_db @dbname = 'cadi_4_13'
, @physname = 'c:\cadi_4_13.mdf'

and i get this error message:
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'c:\cadi_4_13.mdf' is not a valid database file header. The FILE SIZE property is incorrect.

I have seen several places where people have this issue.
I am running sqlserver 2k.

Can someone please take me through (step-by-step) what exactly i am "susposed" to be doing?
I am actually running that in the Query analyzer, but i have tried a stored procedure and to generate a sql script, but i dont know how to execute them except for in a job.... I hope you see where my level is in the matter :)

Thanks in advance for your help,
Chris
0
hudsonbeck
Asked:
hudsonbeck
  • 2
  • 2
1 Solution
 
arbertCommented:
Two possible reasons.

1.  You're trying to attach this file to a different version of SQL Server than where it came from (even a hotfix makes a difference).
2.  The file you received was corrupt
0
 
hudsonbeckAuthor Commented:
SOmeone sent it to me so i really dont even know what version... I tried 97 and 2k.. but if even a hotfix can make it not work, what would be the best way for them to send me the db so i can "attach" it to my sql server. We will be doing some work on the data for them.

Chris
0
 
arbertCommented:
They need to tell you what version....Either that, or have them send you a backup that you can restore.  At least with a backup file you can issue a restore command that will tell you the version it was created with....
0
 
hudsonbeckAuthor Commented:
sry had a unexpected trip... accepted anwser and i appreciate ur help

Chris
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now