March 12, 2012 at 7:02 am
Hi All,
Log backups for multiple databases in same server but different instances are keep on failing. Error log says its due to network path could not be find. But the same path was working for others.
Kindly advice on this.
Thanks
Keerthi
March 12, 2012 at 7:12 am
Post command used and exact error message please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2012 at 7:18 am
Used maintenance plan to create log backup which successfully ran previously.
Error Message:
Executed as user:. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:08:37 AM Progress: 2012-03-12 08:08:39.30 Source: {B53E1831-7C5F-47C4-A808-7296B55731A7} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2012-03-12 08:08:40.27 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\backupserver..." failed with the following error: "xp_create_subdir() returned error 161, 'The specified path is invalid.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2012-03-12 08:08:40.28 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP LOG [POL_BPS] TO DISK = N'\\backupserver\e:..." failed with the following error: "Cannot open backup device '\\backupserver\e:\dbbackup_2012_03_12_080840_1768509.trn'. Operating system error 53(The network path was not found.). BACKUP LOG 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: 8:08:37 AM Finished: 8:08:40 AM Elapsed: 2.543 seconds. The package execution failed. The step failed.
March 12, 2012 at 7:30 am
Check that the backup server is visible from the places where the backup is failing. Check that the SQL Server service account has permission on the backup location.
I also wouldn't recommend backing up to the root of a drive, it usually has more restrictions than a folder.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply