Re: Backup to mapped drive?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 13:50:31 -0500

Check that the SQL Server service account actually has the proper rights to
the network location.

>From the BOL article on BACKUP:
Ownership and permission problems on the backup device's physical file can
interfere with a backup operation. SQL Server must be able to read and write
to the device; the account under which the SQL Server service runs must have
write permissions. However, sp_addumpdevice, which adds an entry for a
device in the system tables, does not check file access permissions. Such
problems on the backup device's physical file may not appear until the
physical resource is accessed when the backup or restore is attempted.

Russell Fields

"rc" <no@email.com> wrote in message
news:#BfU2nfBEHA.3852@TK2MSFTNGP10.phx.gbl...
> Thanks for the response.
>
> If I execute:
>
> "BACKUP DATABASE [MAINDB] TO DISK = N'\\ServerName\ShareName\' WITH INIT
,
> NOUNLOAD , NAME = N'MAINDB backup', NOSKIP , STATS = 10, NOFORMAT"
>
> (of course, 'ServerName' and 'ShareName' are replaced with the actual
names)
>
> I get:
>
> "Cannot open backup device '\\ServerName\ShareName\'. Device error or
> device off-line."
>
>
> and the task does not complete.
>
> Any other thoughts?
>
> Thanks
> "Jeff Block" <jblock@REMOVETHECAPSANDINVALIDfirstlook.biz.invalid> wrote
in
> message news:ulg$o3eBEHA.2800@tk2msftngp13.phx.gbl...
> > use the UNC name, ie \\<servername>\sharename
> >
> > is won't show up in the GUI tree, but you can backup/resotre to a UNC
> > speficied location.
>
>

Relevant Pages

  • Re: Backup permission
    ... Other thing that i dont understand is that when a user is ... >to do backup is you are db_backupoerator. ... >Tibor Karaszi, SQL Server MVP ... >that this user have 'Sysadmin' permissions, ...
    (microsoft.public.sqlserver.server)
  • Re: Database Backup over the network
    ... The problem is still permissions... ... The file permissions needed for backup are those for the login that sql ... and the permissions are those that SQL Agent uses when the backup ... Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction log too big
    ... For SQL Server backups, the file size is not what determines the size of the backup. ... and I also agree that shrinking has a place for "unregular" operations. ... > that's empty though - the physical file will still have the same size on ...
    (microsoft.public.sqlserver.server)
  • Re: Database Backup
    ... Have you checked the actual permissions for the folder? ... Columnist, SQL Server Professional ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
  • Re: Backup permission
    ... It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you ... to do backup is you are db_backupoerator. ... that this user have 'Sysadmin' permissions, ...
    (microsoft.public.sqlserver.server)