From: esquel@sommarskog.se   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)