March 11, 2013 at 3:48 am
Hi friends my backup plan is failing from error logs i got this information. can any one throw some light on it.
3/6/2013
Executing the query "EXECUTE master.dbo.xp_create_subdir N'z:\\Core'
..." failed with the following error: "xp_create_subdir() returned error 3, 'The system cannot find the path specified.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Executing the query "BACKUP DATABASE [Core] TO DISK = N'z:\\Core\\..." failed with the following error: "Cannot open backup device 'z:\\Core\\Core_backup_2013_03_06_021517_6310479.bak'. Operating system error 3(The system cannot find the path specified.).
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.
Executing the query "BACKUP DATABASE [ReportServer$SRVR1] TO DISK = N'..." failed with the following error: "Cannot open backup device 'z:\\ReportServer$SRVR1\\ReportServer$SRVR1_backup_2013_03_06_021517_7770625.bak'. Operating system error 3(The system cannot find the path specified.).
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.
Executing the query "BACKUP DATABASE [SharePoint_Config_Dev] TO DISK =..." failed with the following error: "Cannot open backup device 'z:\\SharePoint_Config_Dev\\SharePoint_Config_Dev_backup_2013_03_06_021517_7990647.bak'. Operating system error 3(The system cannot find the path specified.).
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.
March 11, 2013 at 5:14 am
I think the key part is here:-
""xp_create_subdir() returned error 3, 'The system cannot find the path specified.' "
Does the sql agent have access to this drive?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 11, 2013 at 5:41 am
how to find whether sql agent is having access to that drive or not. i am new and i dont know how to check
March 11, 2013 at 11:03 pm
The Z drive is a mapped drive on the backup server
March 11, 2013 at 11:05 pm
m.rajesh.uk (3/11/2013)
how to find whether sql agent is having access to that drive or not. i am new and i dont know how to check
Find the name of the service account and work with your sysadmin to verify the permissions. Since Z is mapped to a network location, you will need the assistance of the sysadmin to verify permissions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 20, 2019 at 3:43 pm
Please how does one find the service account?
November 20, 2019 at 9:40 pm
select * from sys.dm_server_services lists both the db account and the agent account. the db account(SQL) is what is used for backups.
mapped drives are on a PER USER basis, and since that account never logs in, any auto-mapping for that account most likely never occurs as far as the domain login goes. i doubt very much the service account has any mapped drives.
If you get Error 3 is not exists, but after fixing it and you get Error 5, that is permissions, so you need to add modify permissions for the service account.
do not use mapped drives, use a full UNC path instead.
change the default backup directory, and the script if needed, to use \\backupserverName\Core\
Lowell
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply