You cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive
On SQL Server version 7.0, 2000, and 2005
On SQL Server version 6.5
97/11/25 11:25:51.60 kernel dbswritecheck: Backup device '\\svrname\data\pubs.DAT' failed to open, operating system error = 5 (Access is denied.)
- The SQL Server service must be started using a domain user account to access any resources on a remote computer. Verify that the MSSQLServer service is started under a domain account that has write access to both the Windows NT Server share and its underlying partition (if the partition is formatted with the Windows NT file system, or NTFS).
- In Control Panel, double-click the Services icon.
- Select the MSSQLServer service and then click Startup.
- Examine the startup options for the service and verify that This Account is selected and that a valid domain account is supplied in the form Domain_Name\Domain_account (with the correct password).
NOTE: If you changed the service to run under a domain account, you must stop and restart the MSSQLServer service.
- Verify that the account specified has write access on the Windows NTshare to which you are backing up, as well as the underlying partition (if the partition is formatted as NTFS). To do this, perform the followingsteps:
- Right-click the share name in Windows NT Explorer.
- Click Sharing on the shortcut menu.
- On the Security tab, click Permissions.
Article ID: 207187 - Last Review: 12/02/2005 00:42:44 - Revision: 4.2
- kbprb KB207187