When you try to backup or restore your database to another network server in the SQL Server Enterprise Manager, you will get following error:
Cannot open backup device "\\networkserver\c$\xx.bak". Device error or device off-line. See the SQL Server error log for more details.
BACKUP DATABASE is terminating abnormally.
How could it have happened? The reason is the MSSQLSERVER service is running under the Localsystem account, and the Localsystem account have no access to the network server as it isn't an authenticated network account. so if you want to dump the database onto another server or a UNC path, you can change the account the MSSQLSERVER service runs under to an account with the relevant network rights.
Hope this helps
Cannot open backup device "\\networkserver\c$\xx.bak". Device error or device off-line. See the SQL Server error log for more details.
BACKUP DATABASE is terminating abnormally.
How could it have happened? The reason is the MSSQLSERVER service is running under the Localsystem account, and the Localsystem account have no access to the network server as it isn't an authenticated network account. so if you want to dump the database onto another server or a UNC path, you can change the account the MSSQLSERVER service runs under to an account with the relevant network rights.
Hope this helps
