SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Attaching mdf file.
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

aex
Yak Posting Veteran

60 Posts

Posted - 03/27/2007 :  10:40:49  Show Profile
Rarely I need to perform detach/attach stuff during my development. However, I have to develop an application that use sql server user instance (I am not sure I call it right) this recently.

My problem is each time I detach .mdf file from one machine located at, say: D:\Data\Db.mdf. Once after I trasfer this file to other machine at: C:\Db.mdf, then I try to attach this .mdf file. What cause the problem here is sql server doesn't
allow me to attach the file unless I have the .mdf file corresponding .ldf file.

My thought is that sql server should allow me to attach the file and create a .ldf file if it doesn't find one. Any idea why this happen?

Thanks for any reply.

aex

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts

Posted - 03/27/2007 :  10:57:23  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message
Try using sp_attach_single_file_db.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

aex
Yak Posting Veteran

60 Posts

Posted - 03/27/2007 :  11:09:04  Show Profile
Thanks harsh for the stored procedures. I will try it out tomorrow to see whether it works. Thanks. :)

aex
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000