Saturday, October 12, 2013

[MS SQL Server] Backup to remote location fails

[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.

Page Life Expectancy

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?

TempDB question

Posted: 11 Oct 2013 07:42 AM PDT

Does having multiple tempdb files on different drives help with contention?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog