01-23-2012 02:08 PM
When creating a remote database in admin, there is a setting for "Remote Path - Recommended setting is the data directory of the source database". How "Recommended" is that? We're having some permissions issues on Server 2008 R2 where, even though the person creating the database is supposed to have Read/Write permissions on the target directory (remote path), they are unable to copy or cut any of the files created by admin through the admin tool.
Can we point the remote path to a different file server?
Thanks
Patrick
Solved! Go to Solution.
01-27-2012 09:01 AM
Patrick, It is important to note that it is the SQLServer service user that needs permission to the directory. It is the SQLServer process that is actually moving the created database to the specified location. That is why we recommend this path be somewhere on the server.
This path can exist elsewhere as long as the user configured for the SQLServer service has access.
01-27-2012 09:08 AM
Thank you Paul!