SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cannot Open Backup Device. Operating System Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gypo
Starting Member

9 Posts

Posted - 07/03/2008 :  14:20:02  Show Profile  Reply with Quote
Hi

I am having trouble trying to get MSSQL to backup to a network drive. This is the setup:
+ MSSQL on Windows Server 2003 logged in under Win Auth.
+ Shared drive on Vista desktop PC (although same issue happens on XP).
+ Server and PC are in the same workgroup (no domain only workgroup).
+ PC allows everyone full control to share.
+ Drive and folder can be navigated to through Windows Explorer without the need for a password ("Password protected sharing" is turned off).

The error I am getting is:
Cannot Open Backup Device 'path_to_file'. Operating system error 5(error not found).

Script being used:

BACKUP DATABASE [MyDB]
	TO DISK = N'\\path_to_file\MyDBBackUp.BAK'
	WITH NOFORMAT, INIT,  
	NAME = 'Full Database Backup',
	SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO


As the network is not on a domain, I can not explicity give the server user permission. None the less, the drive can be viewed/modified through Windows Explorer.

I've just noticed that while typing this post that the "MSSQLSERVER" service is running as "Local system account". Is it therefore likely that this local account does not have access to external resources? Should I be running the service with a non local account, for example an account that has Admin permissions?

Thanks :)
Rob

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 07/03/2008 :  14:23:47  Show Profile  Reply with Quote
Should be running in domain account.
Go to Top of Page

maninder
Posting Yak Master

USA
100 Posts

Posted - 07/03/2008 :  23:13:19  Show Profile  Send maninder a Yahoo! Message  Reply with Quote
yes check your credentials, also the remote drive Security. Add your Credentials to the Share or the username the JOB is RUnning under.

Maninder
Database Painter.. Leaving strokes, that amaze! and inreturn, put value to your Work. I am a Database [Architect / Administrator]
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 07/04/2008 :  01:13:34  Show Profile  Reply with Quote
They are in workgroup. Try start sql services with regular windows account and give that account permission to access the share.
Go to Top of Page

gypo
Starting Member

9 Posts

Posted - 07/04/2008 :  12:51:46  Show Profile  Reply with Quote
Thanks everybody. Setting the service account to an appropriate windows account did the trick :)
Go to Top of Page

devpatel87
Starting Member

1 Posts

Posted - 06/11/2013 :  03:58:52  Show Profile  Reply with Quote
add Windows credential in Control Panel-->Credential Manager

solved in my case
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000