Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Backup to Network Drive?

4 posts in ,  AdministrationBackup and Recovery Windows NT Last posting was on 1997-12-04 20:05:02.0Z
Clint Gilliam Posted on 1997-12-02 20:55:25.0Z
Message-ID: <348475BD.192B687B@sebts.edu>
Date: Tue, 02 Dec 1997 15:55:25 -0500
From: Clint Gilliam <gilliam@sebts.edu>
Organization: SEBTS Library
X-Mailer: Mozilla 4.03 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Backup to Network Drive?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.nt,sybase.public.sqlserver.administration
Lines: 21
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:1951 sybase.public.sqlserver.nt:281 sybase.public.sqlserver.administration:3177
Article PK: 1062462

I am running Sybase SQL Server 11.0.2 on NT Server 4.0. I am trying to
dump my database to a network drive. I get this error (below) but NT
allows me to read, write and do whatever else I need. I just don't quite

understand it.

Error message:

Backup Server session id is: 51. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume
change
request from the Backup Server.
Backup Server: 4.41.1.1: Creating new disk file
s:\database\horbackp.bkp.
Backup Server: 4.82.2.40: Operating system error, server device
s:\database\horbackp.bkp: code 65 message Network access is denied.
Server Message Number: 8009
Error encountered by Backup Server. Please refer to Backup Server
messages for
details.

Thanks for your help,
Clint Gilliam


Lance Andersen Posted on 1997-12-04 13:05:07.0Z
Message-ID: <3486AA83.74C3@sybase.com>
Date: Thu, 04 Dec 1997 08:05:07 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
Subject: Re: Backup to Network Drive?
References: <348475BD.192B687B@sebts.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.nt,sybase.public.sqlserver.administration
Lines: 70
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:1948 sybase.public.sqlserver.nt:279 sybase.public.sqlserver.administration:3175
Article PK: 1062460


Clint Gilliam wrote:
>
> I am running Sybase SQL Server 11.0.2 on NT Server 4.0. I am trying to
> dump my database to a network drive. I get this error (below) but NT
> allows me to read, write and do whatever else I need. I just don't quite
>
> understand it.
>
> Error message:
>
> Backup Server session id is: 51. Use this value when executing the
> 'sp_volchanged' system stored procedure after fulfilling any volume
> change
> request from the Backup Server.
> Backup Server: 4.41.1.1: Creating new disk file
> s:\database\horbackp.bkp.
> Backup Server: 4.82.2.40: Operating system error, server device
> s:\database\horbackp.bkp: code 65 message Network access is denied.
> Server Message Number: 8009
> Error encountered by Backup Server. Please refer to Backup Server
> messages for
> details.
>
> Thanks for your help,
> Clint Gilliam

This is not a backup server bug. This is due to the following security
restriction imposed by NT: (refer Microsoft
Product Support's Knowledge Base article # Q124184)

By default, all services are started by the 'LocalSystem' user account,
which operates with what NT calls
NullSession privileges. These privileges are very limited. It does not
allow the service to access network mounted
drives, e.g, NFS, netware or NTFS mounts from other machines.
Hence, we see the 'Access denied' message when
dumping to remote drives.

The resolution is to configure the Backup Server service to start
using a regular user account, rather than NT's
default account. This user should have privilege to access the remote
drives.

To configure Backupserver with a regular User account:
-----------------------------------------------------
1. Double click the Services Icon under the Control Panel.
2. Double click the entry for backup server service, usually has a
name beginning with Sybase_BCKServer.
3. Click 'This Account' button under 'Log on As:' and select the
desired
user by clicking the button marked with
'...'. Also supply the password for this user.
4. Click OK on the Dialog Box and then 'Close' on the Services Dialog
Box.

Now you can use the Sybase Services manager(the traffic light GUI
interface) to start and stop the backup server
using the alternate user you specified above.
--

Regards,

-Lance
team sybase
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Clint Gilliam Posted on 1997-12-04 20:05:02.0Z
Message-ID: <34870CEE.2E82A51A@sebts.edu>
Date: Thu, 04 Dec 1997 15:05:02 -0500
From: Clint Gilliam <gilliam@sebts.edu>
Organization: SEBTS Library
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Lance Andersen <lancea@sybase.com>
Subject: Re: Backup to Network Drive?
References: <348475BD.192B687B@sebts.edu> <3486AA83.74C3@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.nt,sybase.public.sqlserver.administration
Lines: 77
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:1947 sybase.public.sqlserver.nt:278 sybase.public.sqlserver.administration:3174
Article PK: 1062458

Lance,

Perfect answer, I am backing up to a network drive as I write.

Clint

Lance Andersen wrote:

> Clint Gilliam wrote:
> >
> > I am running Sybase SQL Server 11.0.2 on NT Server 4.0. I am trying to
> > dump my database to a network drive. I get this error (below) but NT
> > allows me to read, write and do whatever else I need. I just don't quite
> >
> > understand it.
> >
> > Error message:
> >
> > Backup Server session id is: 51. Use this value when executing the
> > 'sp_volchanged' system stored procedure after fulfilling any volume
> > change
> > request from the Backup Server.
> > Backup Server: 4.41.1.1: Creating new disk file
> > s:\database\horbackp.bkp.
> > Backup Server: 4.82.2.40: Operating system error, server device
> > s:\database\horbackp.bkp: code 65 message Network access is denied.
> > Server Message Number: 8009
> > Error encountered by Backup Server. Please refer to Backup Server
> > messages for
> > details.
> >
> > Thanks for your help,
> > Clint Gilliam
> This is not a backup server bug. This is due to the following security
> restriction imposed by NT: (refer Microsoft
> Product Support's Knowledge Base article # Q124184)
>
> By default, all services are started by the 'LocalSystem' user account,
> which operates with what NT calls
> NullSession privileges. These privileges are very limited. It does not
> allow the service to access network mounted
> drives, e.g, NFS, netware or NTFS mounts from other machines.
> Hence, we see the 'Access denied' message when
> dumping to remote drives.
>
> The resolution is to configure the Backup Server service to start
> using a regular user account, rather than NT's
> default account. This user should have privilege to access the remote
> drives.
>
> To configure Backupserver with a regular User account:
> -----------------------------------------------------
> 1. Double click the Services Icon under the Control Panel.
> 2. Double click the entry for backup server service, usually has a
> name beginning with Sybase_BCKServer.
> 3. Click 'This Account' button under 'Log on As:' and select the
> desired
> user by clicking the button marked with
> '...'. Also supply the password for this user.
> 4. Click OK on the Dialog Box and then 'Close' on the Services Dialog
> Box.
>
> Now you can use the Sybase Services manager(the traffic light GUI
> interface) to start and stop the backup server
> using the alternate user you specified above.
> --
>
> Regards,
>
> -Lance
> team sybase
> ===============================================================================
> Lance J. Andersen Email: lancea@sybase.com
> Sybase Technical Support Phone:(617) 564-6336
> 77 South Bedford Street Fax: (617) 564-6148
> Burlington, MA 01803
>
> The Dark Knight Returns!!! Let's Go Penguins!!!
> ===============================================================================


Mark A. Parsons Posted on 1997-12-02 23:35:58.0Z
Message-ID: <34849B5E.16A0@compuserve.com>
Date: Tue, 02 Dec 1997 18:35:58 -0500
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: Backup to Network Drive?
References: <348475BD.192B687B@sebts.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery,sybase.public.sqlserver.nt,sybase.public.sqlserver.administration
Lines: 56
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:1950 sybase.public.sqlserver.nt:280 sybase.public.sqlserver.administration:3176
Article PK: 1062464

I'm not an NT 'guru' so beware!! <seg>

In UNIX-land the backupserver is run under the 'sybase' account (at
least at all the sites I've worked it is). This requires that the
'sybase' account have the necessary file system permissions to do dumps
and loads.

Now, I (mparsons, mparson1, markp, etc.) may or may not have the
appropriate UNIX file access ... but that doesn't matter since my
'dump/load database/transaction' commands are *handed off* to the
backupserver to perform, i.e., think of the backupserver as serving as
my proxy to do what I want.

Now, what's this got to do with NT?

You mentioned that *you* can read, write and do whatever ... but what
about the id that your backupserver runs under? Your dataserver and
backupserver are probably running under some id other than yours (duh,
Mark !?!?!) so what *you* can do won't necessarily equate to what the
backupserver can do.

If you're not sure how to find it ... your NT administrator should be
able to help you find the id that backupserver is running under ... and
from there s/he should be able to set you up with the permissions
necessary for backupserver to do it's job.

NOTE: Dumping to locally mapped network drives *does* work ... just
gotta get them permissions set properly for the backupserver's id.

Mark Parsons
Iron Horse, Inc.

Clint Gilliam wrote:
>
> I am running Sybase SQL Server 11.0.2 on NT Server 4.0. I am trying to
> dump my database to a network drive. I get this error (below) but NT
> allows me to read, write and do whatever else I need. I just don't quite
>
> understand it.
>
> Error message:
>
> Backup Server session id is: 51. Use this value when executing the
> 'sp_volchanged' system stored procedure after fulfilling any volume
> change
> request from the Backup Server.
> Backup Server: 4.41.1.1: Creating new disk file
> s:\database\horbackp.bkp.
> Backup Server: 4.82.2.40: Operating system error, server device
> s:\database\horbackp.bkp: code 65 message Network access is denied.
> Server Message Number: 8009
> Error encountered by Backup Server. Please refer to Backup Server
> messages for
> details.
>
> Thanks for your help,
> Clint Gilliam