question

skan2dan1 avatar image
skan2dan1 asked

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 ?
servers
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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 ;)
2 Likes 2 ·
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.
1 Like 1 ·
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...
1 Like 1 ·
Totally agree, make them do something on a regular basis and they will offer you a solution that suits all.
0 Likes 0 ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.