Moving the backup files between servers


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 ?

more ▼

asked Jul 18, 2012 at 08:35 AM in Default

avatar image

210 13 13 16

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jul 18, 2012 at 09:13 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

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

Jul 18, 2012 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, 2012 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, 2012 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, 2012 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, 2012 at 04:43 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 18, 2012 at 08:35 AM

Seen: 545 times

Last Updated: Jul 18, 2012 at 04:43 PM

Copyright 2018 Redgate Software. Privacy Policy