Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Novell & SQL2K Backup

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-04 : 09:28:06
masoud writes "Hi
I have an Sql2000 Server with SP1 and SP2 installed on
win2000 server and unfortunatly I can't backup my
databases on novell maped folder.
I was able to perform this action on SQL7 (SP3) on NT4.

Please advise me...thanks in advance
Rahimian"

izaltsman
A custom title

1139 Posts

Posted - 2002-01-04 : 10:13:48
First of all, it is better to use UNC paths rather than mapped drives. Secondly, you need to make sure that SQLAgent is not running under a LocalSystem account and that this service account has rights to the network share.

Go to Top of Page

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-04 : 19:18:26
SQLAgent and MSSQLServer should be started with the same account, but just in case, you should make sure the MSSQLServer service account also has access to the mapped drive. If the backup is scheduled it will use the security context of SQLAgent, however I believe it uses MSSQLServer if you run it yourself (Without scheduling it)

-Chad

Go to Top of Page
   

- Advertisement -