Search code examples
sql-serversql-server-2005-express

SQL Server 2005 Express: back up to a folder on the network

I am using this code as a procedure on an application. At the mid-night, it will trigger the procedure.

http://www.geekzilla.co.uk/View487F82A5-C96B-4660-A070-F7C8B7FC4431.htm

I changed this locally back-up:

TO  DISK = N''c:\db backup\'

to:

TO  DISK = N''\\nlbkserver02\backup_devicem01$\'

It is working normally on the local machine but it did not work on a network drive. The error details is as following:

Cannot open backup device
'\\nlbkserver02\backup_devicem01$\15-Dec-2010
- application 1'. Operating system error 5(error not found). BACKUP
DATABASE is terminating abnormally.

could anyone give me an advice?

Thanks in advance.

Solution

  • SQL runs by default under the Localsystem account. that account does not have access to shares on the network as it isn't an authenticated network account.

    You should also check the permisions on the share.