January 7, 2011 at 9:39 am
Hi,
I have a job for generate a backup in the server A.
I must put the file in other server (B).
1. net use \\10.16.500.222\v3_bak\CC /user:domain\user pass /persistent:YES'
2. Backup in this way.
This job is ok, but now it don´t success, restart the server A and now it don´t work 🙁
This is the error:
Description: Executing the query "BACKUP DATABASE [CC] TO DISK = N'\\10.16.500.200\v3_bak\CC\CC_backup_201101070130.bak' WITH NOFORMAT, NOINIT, NAME = N'CC_backup_20110107013002', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Cannot open backup device '\\10.16.500.200\CC\CC_backup_201101070130.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILU... The package execution fa... The step failed.
What can I do?
Thanks,
January 10, 2011 at 12:05 pm
Does the backup job have permission to that location ? Is the location typed correctly ?
January 10, 2011 at 1:32 pm
Helical Johan (1/7/2011)
Hi,I have a job for generate a backup in the server A.
I must put the file in other server (B).
1. net use \\10.16.500.222\v3_bak\CC /user:domain\user pass /persistent:YES'
2. Backup in this way.
This job is ok, but now it don´t success, restart the server A and now it don´t work 🙁
This is the error:
Description: Executing the query "BACKUP DATABASE [CC] TO DISK = N'\\10.16.500.200\v3_bak\CC\CC_backup_201101070130.bak' WITH NOFORMAT, NOINIT, NAME = N'CC_backup_20110107013002', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Cannot open backup device '\\10.16.500.200\CC\CC_backup_201101070130.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILU... The package execution fa... The step failed.
What can I do?
Thanks,
Don't abuse net use in this way.
Grant your sqlserver service account the authority to write to the folder.
Keep in mind if your target server is unavailable, your backups will fail.
In my plant, we create backups on a local disk/lun and then xcopy the bak files to a safe zone location.
This way the service account doesn't need the remote authorities. The sqlagent service account or the jobstep proxy account need to be granted that authority to be able to xcopy the files.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply