Re: Why BACKUP do not work to NET folder ?

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

From: Geoff N.Hiten (SRDBA_at_Careerbuilder.com)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 10:14:59 -0500

I disagree. I backup to network (UNC) almost exclusively. I consider the
extra time for the backup a small tradeoff for the benefit of having a
backup on another system immediately. I consider a local backup too
vulnerable to catastrophic failure. YMMV. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"ch" <ch@dontemailme.com> wrote in message
news:40337092.D8AA8C61@dontemailme.com...
> it's not recommended to backup over the network.  backup to local disk and
then
> copy the file to the share on the other computer.
>
>
> "Dmitry N.Ananyev" wrote:
>
> > Why BACKUP do not work to NET folder ?
> >
> > (W2003XP Server)
> >
> > SQL is installed on computer with name CELERON.
> >
> > -- Work good --
> > BACKUP DATABASE [model] TO  DISK = N'\\CELERON\for\model.BAK' WITH  INIT
,
> > NOUNLOAD ,  NOSKIP ,  STATS = 10,  NOFORMAT
> >
> > -- Not work --
> > BACKUP DATABASE [model] TO  DISK = N'\\GLOBUS\for\model.BAK' WITH  INIT
,
> > NOUNLOAD ,  NOSKIP ,  STATS = 10,  NOFORMAT
> >
> > Why BACKUP is not work to NET folder of computer named GLOBUS?
> >
> > Earlier, under W2000Server worked good.
> >
> > PS.
> >
> > (Net Workgroup, GUEST in Administrators on GLOBUS)
> >
> > ********************************************************
> > Server: Msg 3201, Level 16, State 1, Line 5
> > Cannot open backup device '\\ GLOBUS \for\model.BAK'. Device error or
device
> > off-line. See the SQL Server error log for more details.
> > Server: Msg 3013, Level 16, State 1, Line 5
> > BACKUP DATABASE is terminating abnormally.
> > ********************************************************
>

Relevant Pages

  • Re: backing up to network share issue.
    ... impersonation when it accesses the backup file on behalf of the SQL Server uses that executed the backup ... SQL Server just uses the SQL Server service account when accessing the backup share. ... > As Tibor stated, this is not an SQL Server issue, it is a network ...
    (microsoft.public.sqlserver.msde)
  • Re: SBS2003, NTBackup-Fehler
    ... Falls das Problem noch verhandeln ist,werde ich vorschalgen nächste Schritte durchzuführen. ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • Re: Unable to Backup on Network
    ... service accoutn from the 'Local System' account to a specific account. ... I like to log in to the SQL server console as the service account to test ... > The operating system on which my SQL Server 2000 is there is Windows 2000> Server while i want to take the backup on another computer on network which> also has same operating system. ...
    (microsoft.public.sqlserver.security)
  • Re: Backing up database on a network machine
    ... You cant see the network drives. ... You Should start SQL server using Domain user who got access to remote ... Now you can execute the Backup script with UNC path ...
    (microsoft.public.sqlserver.msde)
  • Re: backing up to network share issue.
    ... As Tibor stated, this is not an SQL Server issue, it is a network ... The SQL login that is accessing the MSDE instance is not ... a factor in whether the process doing the backup has the correct permissions ...
    (microsoft.public.sqlserver.msde)