May 16, 2014 at 10:55 am
I am having some issues dealing with some of the back jobs that run on a SQL Server 2008 R2 machine.
When I am backing it up on a local drive nothing fails everything runs good. When I am changing it to a UNC path it fails randomly. I am getting below message when the backup is failing.
Executed as user: CAREMORE\sqlsvc. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 9:20:00 AM Progress: 2014-05-16 09:20:01.07 Source: {DD054F84-3449-4FDA-B1E7-86BA6A6C2C88} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2014-05-16 09:20:01.30 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\storagetc\..." failed with the following error: "xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Progress: 2014-05-16 09:20:01.40 Source: Back Up Database Task Executing query "BACKUP LOG [ESI] TO DISK = N'\\storagetc\facdprd\...".: 50% complete End Progress Progress: 2014-05-16 09:20:01.73 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2014-05-16 09:20:01.80 Source: Back Up Database Task Executing query "BACKUP LOG [FACETS_SUPP] TO DISK = N'\\storagetc\...".: 50% complete End Progress Progress: 2014-05-16 09:20:01.94 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2014-05-16 09:20:02.02 Source: Back Up Database Task Executing query "BACKUP LOG [FACETSsmtcust] TO DISK = N'\\storaget...".: 50% complete End Progress Progress: 2014-05-16 09:20:02.15 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2014-05-16 09:20:02.22 Source: Back Up Database Task Executing query "BACKUP LOG [FACETSsmtstg] TO DISK = N'\\storagetc...".: 50% complete End Progress Progress: 2014-05-16 09:20:02.40 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2014-05-16 09:20:02.44 Source: Back Up Database Task Executing query "BACKUP LOG [SBI] TO DISK = N'\\storagetc\facdprd\...".: 50% complete End Progress Progress: 2014-05-16 09:20:02.57 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2014-05-16 09:20:02.65 Source: Back Up Database Task Executing query "BACKUP LOG [SVDB] TO DISK = N'\\storagetc\facdprd...".: 50% complete End Progress Progress: 2014-05-16 09:20:02.80 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2014-05-16 09:20:02.96 Source: Back Up Database Task Executing query "BACKUP LOG [Transportation] TO DISK = N'\\storage...".: 50% complete End Progress Progress: 2014-05-16 09:20:03.08 Source: Back Up Database Task Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:20:00 AM Finished: 9:20:03 AM Elapsed: 2.652 seconds. The package execution failed. The step failed.
Should I delete the maintenance plan and recreate it going at same location ? or is there any thing else I need to do.
Thanks for your help.
May 20, 2014 at 3:12 am
simple, don't backup to a network drive. You'd be better off taking backups locally and then copy them to the network. Backing up directly to a network drive requires a stable network
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2014 at 4:32 am
I strongly agree. What if your network suffers an outage mid-backup?
May 20, 2014 at 5:02 am
The FAQ area of Ola Hallengren's site has some good tips http://ola.hallengren.com/frequently-asked-questions.html. While your at it consider using the full maintenace solution, at least get a copy and play around with it in test as it will give you some great pointers for creating your own jobs should you choose to go that way.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply