Error received when attempting to back up a database to a network drive:
"Access is denied.
LiteSpeed 2005 could not open the Backup file: (\\RLV11111\northwind_db_200607160200.BAK). The previous system message is the reason for the failure.
....
Backup failed for dabatase 'northwind'."
This error message may be the result of incorrect permissions to the network drive.
The problem may also occur using native SQL Server tools. The following error may display when backing up the database using native:
On SQL Server version 7.0, 2000, and 2005
Server: Msg 3201, Level 16, State 1, Line 1 Cannot 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 1 Backup or restore operation terminating abnormally.
Refer to Microsoft Knowledge Base Article ID 207187 - "You cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive" regarding insufficient permissions:
http://support.microsoft.com/?id=207187
