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 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: References: 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 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