|
mallykarjuna
Starting Member
India
5 Posts |
 Posted - 11/09/2006 : 10:04:23
|
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
|
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 |
 |
|
How to attach mdf files which are residing on othe
