You cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article was previously published under Q207187
SYMPTOMS
When you attempt to back up a database to a network drive, you may receive one of the following error messages, depending on the version of SQL Server you are running.

On SQL Server version 7.0, 2000, and 2005

Server: Msg 3201, Level 16, State 1, Line 1Cannot open backup device 'E:\pubs.dat'. Device error or device off-line. See the SQL Server error log for more details.Server: Msg 3013, Level 16, State 1, Line 1Backup or restore operation terminating abnormally.
The following information will be in the error log:
998-12-29 11:58:21.62 kernel BackupDiskFile::CreateMedia: Backup device 'E:\pubs.dat' failed to create. Operating system error = 5(Access is denied.).

On SQL Server version 6.5

[SQL Server] Can't open dump device '<dump device path>'. Device error or device off line. Please consult the SQLServer errorlog for moredetails.
Messages similar to the following appear in the error log:
97/11/25 11:25:49.54 kernel dbsvolopen: Backup device '\\svrname\data\pubs.DAT' failed to open, operating system error = 5 (Access is denied.)
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 following message may also appear in the error log:
Msg 18204: dbswritecheck: Backup device '<device path and file>' failed to open, operating system error = 5 (Access is denied.)
CAUSE
This error message usually occurs as a result of incorrect permissions to the network drive.
WORKAROUND
To enable backups to network drives, perform the following steps:
  1. 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).
  2. In Control Panel, double-click the Services icon.
  3. Select the MSSQLServer service and then click Startup.
  4. 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.
  5. 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:

    1. Right-click the share name in Windows NT Explorer.
    2. Click Sharing on the shortcut menu.
    3. On the Security tab, click Permissions.
prodsql net networked backup dump
خصائص

رقم الموضوع: 207187 - آخر مراجعة: 12/02/2005 00:42:44 - المراجعة: 4.2

Microsoft SQL Server 6.5 Standard Edition, Microsoft SQL Server 7.0 Standard Edition, Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Workgroup Edition

  • kbprb KB207187
تعليقات