|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > SQL Server 2000 Problem
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 |
SQL Server 2000 Problem
|
|
|
|
We had database on a SQl server 2000 trial Version. Now as the trail
Time is been expired we cannot open the database. So we moved the .MDF
and .LDF files to different 2000 server, when used sp_attach_db command
to attach these mdf and ldf file I get this error...
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 's:\Progra~1\Micros~1\MSSQL$~1
\data\PTG_data.mdf' is
not a valid database file header. The FILE SIZE property is incorrect.
Can anybody help please !!!.
These are the steps I did
1. Copy .mdf & .ldf file to the data directory(From the Trial SQL
Server)
2. Created a Database called PTG.
3. Detach this database
4. tried to attach the copied mdf and ldf files..which errored out as
explained above..
Thanks a Lot
Arun
--
Posted via http://dbforums.com
| |
| Tibor Karaszi 2002-10-29, 5:23 am |
| Is s: a mapped network drive? If so, copy to local disk (SQL Server don't support database files
on network drives).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"arunv" <member@dbforums.com> wrote in message news:1980494.1035848166@dbforums.com...
>
> We had database on a SQl server 2000 trial Version. Now as the trail
> Time is been expired we cannot open the database. So we moved the .MDF
> and .LDF files to different 2000 server, when used sp_attach_db command
> to attach these mdf and ldf file I get this error...
>
> Server: Msg 5172, Level 16, State 15, Line 1
> The header for file 's:\Progra~1\Micros~1\MSSQL$~1
\data\PTG_data.mdf' is
> not a valid database file header. The FILE SIZE property is incorrect.
>
> Can anybody help please !!!.
>
> These are the steps I did
> 1. Copy .mdf & .ldf file to the data directory(From the Trial SQL
> Server)
> 2. Created a Database called PTG.
> 3. Detach this database
> 4. tried to attach the copied mdf and ldf files..which errored out as
> explained above..
>
> Thanks a Lot
> Arun
>
> --
> Posted via http://dbforums.com
| |
|
|
Its not mapped drive. I copied it to the Local drive and tried to
attach.
But I'm still getting this FileSize Property Error....
--
Posted via http://dbforums.com
|
|
|
|
|