can't attach mdf to sql server

[Rich]

Hello,

I created a backup copy of an mdf (call it Data.Mdf) file
on the server. Now I want to attach that backup mdf so
that I can truncate all the tables (shrink the file). But
I get the error message in query analyzer as follows:

Device activation error. The physical file
name "C:\Data.LDF" may be incorrect.

Could not open new datase "backupData". CREATE DATABASE
aborted.
Device activation error. The physical file
name "C:\Data.LDF" may be incorrect.

Does anyone know how I could unlink the backup mdf from
the ldf so that I can attach it to the server?

Thanks,
Rich

[Rich]

No, but thanks for the suggestion. I'm sure that would be
a better way to go than the gyrations I have been doing.

Thanks,
Rich

>-----Original Message-----
>Have you looked at sp_attach_single_file_db?
>
>
>
>
>"Rich" <rpng123@aol.com> wrote in message
>news:00b001c33fe7$658de860$a301280a@phx.gbl...

>> Hello,
>>
>> I created a backup copy of an mdf (call it Data.Mdf)

file

>> on the server. Now I want to attach that backup mdf so
>> that I can truncate all the tables (shrink the file).

But

>> I get the error message in query analyzer as follows:
>>
>> Device activation error. The physical file
>> name "C:\Data.LDF" may be incorrect.
>>
>> Could not open new datase "backupData". CREATE DATABASE
>> aborted.
>> Device activation error. The physical file
>> name "C:\Data.LDF" may be incorrect.
>>
>> Does anyone know how I could unlink the backup mdf from
>> the ldf so that I can attach it to the server?
>>
>> Thanks,
>> Rich

>
>
>.
>