General discussion

Locked

ms sql server 6.5 backups.....

By Shadowrex ·
I am trying to do a restore from a network share... but when I create the backup device
enterprise manager says that there is nothing there... when I try to create the device from a mapped drive it does not see the mapped drive as an option....

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

ms sql server 6.5 backups.....

by mcdg In reply to ms sql server 6.5 backups ...

It could be that your SQLServer Service is operating under the LocalSystem account which is the default.

Taken from Books Online - Administrators Companion/Chapt 12:
When creating a dump device on a remote network location, be sure that the account under which SQL Server runs has appropriate write capabilities on the remote machine. Ownership and permission problems can interfere with the use of disk dump devices on network shares. Make certain that appropriate file, directory, and share permissions are given to the account under which SQL Server runs.


If SQL Server is running under the LocalSystem account (which is the default configuration), you need to add the share of the remote dump device to the NullSessionShares Registry key.
\\HKEY_LOCAL_MACHINE
\System
\CurrentControlSet
\Services
\LanmanServer
\Parameters
Name: NullSessionShares
Type: REG_MULTI_SZ
Data: COMCFG
In order to access some network resources, you can assign a user account to the SQL Server service (MSSQLServer)

Collapse -

ms sql server 6.5 backups.....

by Shadowrex In reply to ms sql server 6.5 backups ...

The question was auto-closed by TechRepublic

Collapse -

ms sql server 6.5 backups.....

by jereg In reply to ms sql server 6.5 backups ...
Collapse -

ms sql server 6.5 backups.....

by Shadowrex In reply to ms sql server 6.5 backups ...

The question was auto-closed by TechRepublic

Collapse -

ms sql server 6.5 backups.....

by Shadowrex In reply to ms sql server 6.5 backups ...

This question was auto closed due to inactivity

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums