Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL database attachment

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-12-26 : 10:38:58
NILESH writes "Dear sir,

I have a database called accounts.mdf but no log files (.ldf). when i tried to attach to sql server 7.0 , it is not allowing me to attach. I tried sp_attach as given in manual to attach only .mdf file , but i can't.

Can u please help

Thanks,

Nilesh "

mfemenel
Professor Frink

1421 Posts

Posted - 2002-12-26 : 10:54:04
Please post your code so we can see exactly what you're doing. Also, you might try sp_attach_single_file_db, check out BOL for an example.

Mike
"oh, that monkey is going to pay"
Go to Top of Page
   

- Advertisement -