Binaryworld - Error : When I try to backup to a Network share ... [ SQL Server -> Backup-Restore ]

I get the following error message: "Can't open dump device ... device error or
device off line. Please consult the SQL Server error log for more details."

Resolution:
To perform SQL Backup on network share SQL Executive service needs to run under an account that has permissions on the
network share.

The default set of NT credentials used by MSSQLSERVER is the Localsystem account. You can check what userid that MSSQLSERVER is running under by looking at control panel/services highlighting MSSQLSERVER and choosing the start-up option.

The Localsystem account has no access to shares on the network as it isn't an authenticated network account. Therefore SQL Server running under this account cannot backup to a normal network share. You can check this access by copying some test file on the shared location. If you get Access Denied error then you have to setup permission.

Backups to a network folder require the following prerequisites:

1) The SQL Server service must be running under a domain-level account.
2) The SQL Server service account must have FULL CONTROL rights to the file system folder and to the share.
3) The remote share should only be accessed via UNC name. Mapped drives may not be consistently visible to the SQL Service.