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.

Dumping to mapped drive gets Access denied error

5 posts in Windows NT Last posting was on 1997-10-31 09:53:06.0Z
Stephen Stevens Posted on 1997-10-29 08:05:17.0Z
From: "Stephen Stevens" <srs@viridian.com.au>
Subject: Dumping to mapped drive gets Access denied error
Date: Wed, 29 Oct 1997 19:05:17 +1100
Lines: 20
Organization: Viridian Pty Ltd
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <QGfc6hD58GA.174@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5453
Article PK: 1081531

Hi.

I am trying to do a database dump from one NT machine to a shared disk on
another, but I am getting the following error:

Backup Server: 4.41.1.1: Creating new disk file f:\test.dbd.
Msg 408202, Level 2, State 40
Backup Server: 4.82.2.40: Operating system error, server device
f:\test.dbd: code 5 message Access is denied.

I have checked the permissions - everybody and everything has full access.

I have done a NET USE to attach the shared disk, and I can create a file
manually on it, but backup server won't dump to it.

Any ideas?

Thanks in advance....


Reinoud van Leeuwen Posted on 1997-10-31 09:53:06.0Z
Message-ID: <3459AA82.14C6@sybase.com>
Date: Fri, 31 Oct 1997 10:53:06 +0100
From: Reinoud van Leeuwen <reinoud@sybase.com>
Organization: Sybase Inc.
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
Subject: Re: Dumping to mapped drive gets Access denied error
References: <QGfc6hD58GA.174@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 44
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5444
Article PK: 1081522


Stephen Stevens wrote:
>
> Hi.
>
> I am trying to do a database dump from one NT machine to a shared disk on
> another, but I am getting the following error:
>
> Backup Server: 4.41.1.1: Creating new disk file f:\test.dbd.
> Msg 408202, Level 2, State 40
> Backup Server: 4.82.2.40: Operating system error, server device
> f:\test.dbd: code 5 message Access is denied.
>

The problem is that the mapped drive is available under the current
logon (the terminal), whereas the Sybase SQL server runs under it's own
account. It might be possible that under this account, the mapping does
not exist.
Trying to map the drive in the batch file prior to the dump won't
resolve this, because that makes the mapping to the account where that
batch file runs in (typically the system account, when the batch file is
run from the scheduler).

A solution is to create a permanent-system-wide mapping. This can be
done for Novell drives through setup of the Gatway services for Netware.
(set up some drives and remember the drive letters). This might take a
reboot for the SQL server, because the GSNW mappings work after a new
logon.

For mappings to NT servers... (I have not tried this) try:
dump mydb to "\\servername\sharename\filename.dump" (check rights on
this share first FOR THE SYBASE ACCOUNT)

If you suspect a rights problem:
- Is Sybase running under the localsystem account
- does this account have acces to the network?
- To test this: temporarily run the Sybase SQL server under the
Administrator account. If this works, you defintly have a rights problem
(but one that can be solved)


Hope this works,

Reinoud van Leeuwen
Professional Services - Maarssen / The Netherlands


Dan Much Posted on 1997-10-29 19:08:12.0Z
From: "Dan Much" <DMuch@csd.ca.gov>
Subject: Re: Dumping to mapped drive gets Access denied error
References: <QGfc6hD58GA.174@forums.powersoft.com>
Message-ID: <01bce4a6$d85c4140$32cde1cd@dmuch>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Wed, 29 Oct 1997 14:08:12 -0500
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5450
Article PK: 1081527

Are you using a batch file to perform the dump. I have found that using an
NT batch file to call a script seems to work best. Forgive me any syntax
errors, I'm doing this from memory. For example:

REM Batch file to map a drive letter then run SQL dump script
net use s: /delete
net use s: \\server\share
isql -U operatorlogin -P password -S SQLServerName -i
s:\scripts\DumpScript.sql


and where DumpScript.sql contains:

dump database db_name to "s:\dumpfiles\db_name.dmp"

I have this execute before I backup to tape.

Hope this helps,

Dan Much
dmuch@csd.ca.gov

Stephen Stevens <srs@viridian.com.au> wrote in article
<QGfc6hD58GA.174@forums.powersoft.com>...
> Hi.
>
> I am trying to do a database dump from one NT machine to a shared disk on
> another, but I am getting the following error:
>
> Backup Server: 4.41.1.1: Creating new disk file f:\test.dbd.
> Msg 408202, Level 2, State 40
> Backup Server: 4.82.2.40: Operating system error, server device
> f:\test.dbd: code 5 message Access is denied.
>
> I have checked the permissions - everybody and everything has full
access.
>
> I have done a NET USE to attach the shared disk, and I can create a file
> manually on it, but backup server won't dump to it.
>
> Any ideas?
>
> Thanks in advance....
>
>
>


Stephen Stevens Posted on 1997-10-29 21:14:39.0Z
From: "Stephen Stevens" <srs@viridian.com.au>
References: <QGfc6hD58GA.174@forums.powersoft.com> <01bce4a6$d85c4140$32cde1cd@dmuch>
Subject: Re: Dumping to mapped drive gets Access denied error
Date: Thu, 30 Oct 1997 08:14:39 +1100
Lines: 27
Organization: Viridian Pty Ltd
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <2#x4JbK58GA.204@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5448
Article PK: 1081528

Thanks, but that is almost exactly what I am doing, and I get the error.

Dan Much wrote in message <01bce4a6$d85c4140$32cde1cd@dmuch>...
>Are you using a batch file to perform the dump. I have found that using an
>NT batch file to call a script seems to work best. Forgive me any syntax
>errors, I'm doing this from memory. For example:
>
>REM Batch file to map a drive letter then run SQL dump script
>net use s: /delete
>net use s: \\server\share
>isql -U operatorlogin -P password -S SQLServerName -i
>s:\scripts\DumpScript.sql
>
>
>and where DumpScript.sql contains:
>
>dump database db_name to "s:\dumpfiles\db_name.dmp"
>
>I have this execute before I backup to tape.
>
>Hope this helps,
>
>Dan Much
>dmuch@csd.ca.gov


Dan Much Posted on 1997-10-30 17:25:41.0Z
From: "Dan Much" <DMuch@csd.ca.gov>
Subject: Re: Dumping to mapped drive gets Access denied error
References: <QGfc6hD58GA.174@forums.powersoft.com> <01bce4a6$d85c4140$32cde1cd@dmuch> <2#x4JbK58GA.204@forums.powersoft.com>
Message-ID: <01bce561$b1193960$32cde1cd@dmuch>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Thu, 30 Oct 1997 12:25:41 -0500
Lines: 8
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5446
Article PK: 1081524

Sounds like an NT problem. Double check the partition Share permissions
and NTFS permissions. If all else fails, you might want to have the NT
Administrator account "Take Ownership" of the partition and re-do the Share
and NTFS permissions.


--
Dan Much
dmuch@csd.ca.gov.no.spam