April 10, 2007 at 8:21 pm
We need to move one db to another server to save diskspace on MS SQL server. ie. move only db & transaction log files from server1 to y:\dbfiles\ folder where y: is \\server2\Remote.
MSSQL is not installed on server2. So do I need to set any permissions on y:\dbfiles or any special setting for it? Plz help.
April 11, 2007 at 9:38 am
Alex,
I'm not quite sure what you want to do. Do you want to install SQL Server on server2 and transfer a database to it, or do you want to leave the database on server1 and just move the database files to server2? The second scenario is not possible because database files must be on the same server as the database. They can't be remote.
Greg
Greg
April 12, 2007 at 8:29 am
HI,
I may be wrong here, Could you create a test database and try it out?
Add the service account on which SQL Server is running as administrator on Y server and grant permission on the folder to which you want to place the files. Then detach the test database and attach to new location. I hope that will work. I don't recall exactly but I have seen this scenario in the past.
Anil Kumar
April 12, 2007 at 6:36 pm
I have not tested this but I read that someone was able to create a database that data and log files resided on a network location. But I know that this is not the way MS recommends and supports. You can create a database any type of local harddrive but not network. You also increase LAN latency and maybe some other problems.
Good day,
Bulent
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply