x

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 ?
more ▼

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

skan2dan1 gravatar image

skan2dan1
210 11 13 14

(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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
98.7k 19 21 74

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x4

asked: Jul 18, 2012 at 08:35 AM

Seen: 442 times

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