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

Re: 'Backup Database' permission

Path	csiph.com!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: 'Backup Database' permission
Date	Fri, 06 Dec 2013 23:41:08 +0100
Organization	Erland Sommarskog
Lines	35
Message-ID	<XnsA28EF0F168FYazorman@127.0.0.1> (permalink)
References	<l7qlqa$kfg$1@news.albasani.net> <XnsA28DED4A27680Yazorman@127.0.0.1> <bd083b75-e211-4de1-b6fb-a07f9d7842c5@googlegroups.com> <XnsA28EDF7CCFC00Yazorman@127.0.0.1> <l7tf1v$53r$1@news.albasani.net>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx05.eternal-september.org; posting-host="fd3d6d0229f14a752f017d8f9903addd"; logging-data="29040"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18kPXVzTAMMG8d61oB6q1zo"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:MEQ6C3oxFkcd/QywTbQrRukXPdY=
Xref	csiph.com comp.databases.ms-sqlserver:1631

Show key headers only | 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