Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issues while backing up to the network Expand / Collapse
Author
Message
Posted Friday, May 16, 2014 10:55 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 12:17 AM
Points: 53, Visits: 866
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.
Post #1571824
Posted Tuesday, May 20, 2014 3:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
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"
Post #1572534
Posted Tuesday, May 20, 2014 4:32 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 6:22 AM
Points: 510, Visits: 1,894
I strongly agree. What if your network suffers an outage mid-backup?
Post #1572570
Posted Tuesday, May 20, 2014 5:02 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 1:23 AM
Points: 728, Visits: 790
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.
Post #1572577
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse