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.
Author |
Topic |
mallykarjuna
Starting Member
5 Posts |
Posted - 2006-11-09 : 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
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-09 : 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. Seehttp://support.microsoft.com/kb/304261 |
|
|
|
|
|