Due to security polices, the DBA are provided power-user privilege in Windows O.S. We are already discussing with the System Admins to obtain the full permission to the SQL Server Installation Directories.
For the Backup/Restoration request, from the Production to Development server, we normally used to map and move the files. Now, we are unable to perform this activity now.Apart from mapping other server drive/folder and moving the backup files, FTP, is there any other way to move the files between Windows Servers ?
asked Jul 18 '12 at 08:35 AM in Default
Not really. If you can make a common location on the network and connect both servers to it, that can work (although, depending on your network, it can slow down restore operations). Just start flooding the sysadmins with requests to move the backups around. They'll sort it out shortly.
answered Jul 18 '12 at 09:13 AM
Grant Fritchey ♦♦