October 12, 2013 at 8:01 am
I create a maintenance plan on a server named Rem-rem-db to backup the database to another database server Rem-rem-db2.
I specify the UNC Path \\Rem-rem-db2\dbbackups.
I granted permissions to the SQLServerAgent Account to read and write to that folder.
I logged in to the remote server using the SQLServerAgent Account and created a file to ensure that the account did have permissions but the job fails.
It can't access that path.
I have done this before and it worked.
Any ideas would be greatly appreciated.
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 8:42 am
When I attempt to create a backup device I get the following error:
Cannot verify the existence of the backup file location. Do you want to use the backup file location anyway?
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 9:11 am
I thought that it was an issue with permissions on the SQLServerAgent Account but it is the SQLServer Service Account.
I will take steps to resolve.
It should work.
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