October 12, 2013 at 7:56 am
\\Rem-rem-db2\dbbackups
Date10/12/2013 9:40:12 AM
LogJob History (Backup_RemressPP_Prod_Remote.Subplan_1)
Step ID1
ServerRem-VUE-DB
Job NameBackup_RemressPP_Prod_Remote.Subplan_1
Step NameSubplan_1
Duration00:00:01
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: RemRESSIG\SQLServerAgent. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 09:40:12 AM Progress: 2013-10-12 09:40:12.88 Source: {16BD13D9-C4AB-44B5-B374-DE038612FA94} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2013-10-12 09:40:13.16 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\Rem-vue-db..." failed with the following error: "xp_create_subdir() returned error 5, 'Access is denied.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2013-10-12 09:40:13.23 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [RemressPP_Prod] TO DISK = N'\\cy..." failed with the following error: "Cannot open backup device '\\Rem-vue-db2\dbbackups\RemressPP_Prod\RemressPP_Prod_backup_2013_10_12_094013_0914381.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. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 09:40:12 AM Finished: 09:40:13 AM Elapsed: 0.827 seconds. The package execution failed. The step failed.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 12, 2013 at 1:20 pm
Does the sql server agent service account has full permissions on that network location?
October 12, 2013 at 2:57 pm
AJ@SQL (10/12/2013)
Does the sql server agent service account has full permissions on that network location?
It appears that the permissions need to be granted the SQL Server Service Account.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply