Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1631

Re: 'Backup Database' permission

Show all headers | View raw

Chad Jones (noreply@noreply.com) writes:
> Yes, I have no access to the tape backups or the tape backup 
> device so that is not an option.  I do however have a full copy 
> of SQL Server 2008 R2 running on my dev machine.  It is a 
> trivial matter for me to restore a .bak file from another 
> server on to my dev server.  Which is why I was asking about 
> the 'Backup Database' permission.  I have full R/W on the other 
> server but no 'Backup Database' permission.  I'm sure the dba's 
> wouldn't give it to me if I asked for it because of the 
> aforementioned restrictions on the tape device.  Even the dba's 
> don't have full access to the tape device.  I was hoping that 
> if they could give me permission to backup to disk only that 
> would be the way to go.  I don't even want to ask these guys to 
> run a script for me to backup to a disk location.  Whatever 
> solution I find has to be something I can run myself.  Thanks

Hm, do you know for sure that they have a tape device? I don't work
in operations, so I don't know how common tape devices are today, 
but if I were to set up a backup (well restore) strategy for a database,
I would certainly not add any tape devices to the mix, at least not
as the primary backup target. (Possibly copy the backup file on disk 
to tape in a second step.)

And even if there is a tape device, I don't see why the DBAs would not
give you permission because of the tape device. Certainly, if I was a 
DBA, and a random developer would ask for permissions to backup 
databases on a production server, or even a test/QA server, I would not
do this lightly. If you have a legit reason to have a copy of the 
database, I would rather take the backup myself, and put it somewhere
you can read it.



-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

'Backup Database' permission Chad Jones <noreply@noreply.com> - 2013-12-05 11:57 -0800
  Re: 'Backup Database' permission Erland Sommarskog <esquel@sommarskog.se> - 2013-12-05 23:19 +0100
    Re: 'Backup Database' permission rja.carnegie@gmail.com - 2013-12-05 16:14 -0800
      Re: 'Backup Database' permission Erland Sommarskog <esquel@sommarskog.se> - 2013-12-06 21:58 +0100
        Re: 'Backup Database' permission Chad Jones <noreply@noreply.com> - 2013-12-06 13:20 -0800
          Re: 'Backup Database' permission Erland Sommarskog <esquel@sommarskog.se> - 2013-12-06 23:41 +0100
            Re: 'Backup Database' permission Mark D Powell <Mark.Powell2@hp.com> - 2013-12-24 12:26 -0800

csiph-web