Moving the backup files between servers

Hi,

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

skan2dan1
210 ● 5 ● 9 ● 14

(comments are locked)

1 answer:

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 ♦♦
64.9k ● 13 ● 20 ● 66

Totally agree, make them do something on a regular basis and they will offer you a solution that suits all.

Jul 18 '12 at 09:30 AM sp_lock

yeah, agree with GRant but you also need to update your Disaster Recovery plans to ensure the password/authority will be available when this is an emergency. It will need to be noted as a potential delay in recovery and a required piece of knowledge/person availability. Getting the sysadmins to sign in to that could be enough to let them fix your permissions ;)

Jul 18 '12 at 11:04 AM Fatherjack ♦♦

And when you say "sign in" bring a piece of paper that requires them to put a written signature on it. Amazing how that can clarify situations quickly.

Jul 18 '12 at 12:07 PM Grant Fritchey ♦♦

Oh absolutely, they would need to sign on the document that they will be there to prevent you being held up in the case of an emergency.

Jul 18 '12 at 12:33 PM Fatherjack ♦♦

Perfect answer, especially with Fatherjack's additions. I would just add that as a DBA I would expect full admin rights on at least the machines that exist primarily as SQL Server boxes and full domain admin is not at all unreasonable. I would find not getting admin rights on at least the SQL Server machines to be inconvenient at best...

Jul 18 '12 at 04:43 PM TimothyAWiseman

(comments are locked)