Restoring from Network Shares
eilandd
Posts: 44
Our situation is as follows:
We are using SQL Backup 5.2.0.2825 on SQL Server 2000 instances across multiple Windows 2003 active directory domains. From time to time we are requested to restore a backup from an instance on one server to an instance on another server where both are in the same domain. We typically attempt to do this across the network via the gui. This is generally faster for us as opposed to copying the backup and doing a local restore. We have no issues as long as the servers in question are in the same domain as the gui. However, if the servers are in a domain other than where the gui is installed the network shares are not displayed. For all servers the SQL Backup agent users has full rights on the shares that we are attempting to access.
How can we access the network shares in the alternate domains?
We are using SQL Backup 5.2.0.2825 on SQL Server 2000 instances across multiple Windows 2003 active directory domains. From time to time we are requested to restore a backup from an instance on one server to an instance on another server where both are in the same domain. We typically attempt to do this across the network via the gui. This is generally faster for us as opposed to copying the backup and doing a local restore. We have no issues as long as the servers in question are in the same domain as the gui. However, if the servers are in a domain other than where the gui is installed the network shares are not displayed. For all servers the SQL Backup agent users has full rights on the shares that we are attempting to access.
How can we access the network shares in the alternate domains?
Comments
However there is a workaround (other than typing in the full path and file name). To browse for a file, use the Restore Wizard, Step 1 of 4 screen, select 'Browse for backup files to restore', then the 'Add Files' button. On the Browse drop down select 'Network shares', then enter the share and folder in the 'SQL Server' text box. Click 'Add Server to List'.
Now you can at least browse that folder for the file - but you are restricted to that folder only.
Red-Gate support