Solved

Attach Single File (MDF) Problem

Posted on 2004-03-22
4
2,276 Views
Last Modified: 2009-04-01
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
Comment
Question by:hudsonbeck
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 10649924
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
 

Author Comment

by:hudsonbeck
ID: 10649987
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
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 10650635
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
 

Author Comment

by:hudsonbeck
ID: 10713548
sry had a unexpected trip... accepted anwser and i appreciate ur help

Chris
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question