|
Home > Archive > MS SQL Server New Users > December 2005 > MDF file not a valid SQL server database file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MDF file not a valid SQL server database file
|
|
| claudia_usa 2005-12-14, 3:24 am |
| Hi,
I have the mdf and ldf files of a database I want to use on my server. In
enterprise manager, I select “attach database” and chose the mdf file. I
immediately get the error “The file you’ve specified is not a valid SQL
server database file”. I don’t think these files are physically corrupted.
Does anyone know what else can cause this error?
Claudia
| |
| Mike Epprecht \(SQL MVP\) 2005-12-14, 3:24 am |
| Hi
Make sure that the files are from the same version of SQL Server. e.g. 7.0
will not understand 2000 or 2005 file format etc.
The files could well be corrupt. Were they detached before you attempted to
attach them?
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"claudia_usa" < claudiausa@discussio
ns.microsoft.com> wrote in message
news:9544019D-2092-45FE-A5BE- 4BF56CF9CA61@microso
ft.com...
> Hi,
> I have the mdf and ldf files of a database I want to use on my server. In
> enterprise manager, I select "attach database" and chose the mdf file. I
> immediately get the error "The file you've specified is not a valid SQL
> server database file". I don't think these files are physically corrupted.
> Does anyone know what else can cause this error?
> Claudia
>
|
|
|
|
|