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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to attach mdf files which are residing on othe
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mallykarjuna
Starting Member

India
5 Posts

Posted - 11/09/2006 :  10:04:23  Show Profile  Reply with Quote

SQL Server 2005 and the related databases are on one server. Due to space constraints I have to move one of the database(mdf & ldf) to second server and access the same from the 1st server.

The following are the steps I ned to follow on the 1st server:

1. Detached the database
2. Moved the mdf & ldf files to 2nd machine/server
3. Attach the database pointing to the 2nd server.

The 1st and 2nd steps went fine, the problem is with the 3rd step.
In the Attach Databases window, I clicked on ADD, it opened LOCATE DATABASE FILE, the folder structure of the 1st server. Is there any way I can change the SELECTED PATH and poin to the 2nd server?

I did even mapped network drive to the 2nd server but the mapped drive is not getting displayed in the LOCATE DATABASE FILE folder structure.

Can we attach mdf/ldf files which reside on other machine?

Thanks in advance.

snSQL
Flowing Fount of Yak Knowledge

USA
1837 Posts

Posted - 11/09/2006 :  10:31:46  Show Profile  Reply with Quote
You cannot use files that are on another server unless you have SQL Server installed on that server too. From Books Online - "The files must reside on one of the following devices: the local server on which SQL Server is installed, a Storage Area Network [SAN], or an iSCSI-based network."

Edit 11/15 - note that since SQL Server 7.0 a trace flag (1807) is supported that turns on support for network paths for databases, but Microsoft do not recommend using network drives for databases. See
http://support.microsoft.com/kb/304261

Edited by - snSQL on 11/15/2006 15:01:19
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000