[MS SQL Server] Backup to remote location fails |
| Backup to remote location fails Posted: 12 Oct 2013 01:01 AM PDT 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.Date 10/12/2013 9:40:12 AMLog Job History (Backup_RemressPP_Prod_Remote.Subplan_1)Step ID 1Server Rem-VUE-DBJob Name Backup_RemressPP_Prod_Remote.Subplan_1Step Name Subplan_1Duration 00:00:01Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted 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. |
| Posted: 11 Oct 2013 07:46 AM PDT Using a script, I got a number for PLE. How do I conclude that this PLE is optimum for my instance? |
| Posted: 11 Oct 2013 07:42 AM PDT Does having multiple tempdb files on different drives help with contention? |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment