March 9, 2013 at 2:14 pm
i am getting the below error while taking the backup via maintence plan.. i am getting an error only for one particular database and rest been completed successfully.
Please advice
Executed as user: XXXXXXXXX\XXX$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 4:07:42 PM Progress: 2013-03-09 16:07:43.12 Source: {136FEB27-FA79-435D-AE44-BC65CE8B1D5A} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2013-03-09 16:07:43.31 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'F:\Backups\\...".: 100% complete End Progress Error: 2013-03-09 16:07:43.33 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [Logger ] TO DISK = N'F:\Backu..." failed with the following error: "Cannot open backup device 'F:\Backups\\Logger \Logger _backup_2013_03_09_160743_3082964.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: 4:07:42 PM Finished: 4:07:43 PM Elapsed: 0.687 seconds. The package execution failed. The step failed.
March 9, 2013 at 2:36 pm
m.rajesh.uk (3/9/2013)
i am getting the below error while taking the backup via maintence plan.. i am getting an error only for one particular database and rest been completed successfully.Please advice
Executed as user: XXXXXXXXX\XXX$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 4:07:42 PM Progress: 2013-03-09 16:07:43.12 Source: {136FEB27-FA79-435D-AE44-BC65CE8B1D5A} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2013-03-09 16:07:43.31 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'F:\Backups\\...".: 100% complete End Progress Error: 2013-03-09 16:07:43.33 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [Logger ] TO DISK = N'F:\Backu..." failed with the following error: "Cannot open backup device 'F:\Backups\\Logger \Logger _backup_2013_03_09_160743_3082964.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: 4:07:42 PM Finished: 4:07:43 PM Elapsed: 0.687 seconds. The package execution failed. The step failed.
the highlighted part is the root of the problem, does that directory structure exist? the double '\\' and the space after Logger look suspicious.
I would say the database 'Logger' is in fact called 'Logger ' (with a blank space on the end) and this is the root of the problem.
---------------------------------------------------------------------
March 10, 2013 at 10:43 pm
Hi, any one has any idea .....
March 10, 2013 at 11:27 pm
Have you checked that the backup path is available and that the service account has permissions to that path?
It looks like a bad path specified in your maintenance plan as George pointed out.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2013 at 11:43 pm
i created backup maintenance plan through the maintenance plan wizard.. backups are happening for all other databases only one database is not getting backup. i selected option create sub directories for each database.
so if created one new folder named logger and take backup does it works.
March 10, 2013 at 11:47 pm
If you run a manual backup for that database via script to that folder location, does it work?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2013 at 12:05 am
Through script it went fine. so how to solve this issue in maintenance plan.....
March 11, 2013 at 2:12 am
Like george sibbald said, you have a space in the DB name, options are:
- change the db name
- don't make a subdirectory for this db in maintance plan
March 11, 2013 at 4:32 am
m.rajesh.uk (3/10/2013)
Hi, any one has any idea .....
I have had posts ignored before but this is getting ridiculous.................:-)
---------------------------------------------------------------------
March 11, 2013 at 10:26 am
m.rajesh.uk (3/11/2013)
Through script it went fine. so how to solve this issue in maintenance plan.....
Please provide the exact script you used to backup the database via script.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2013 at 10:27 am
george sibbald (3/11/2013)
m.rajesh.uk (3/10/2013)
Hi, any one has any idea .....I have had posts ignored before but this is getting ridiculous.................:-)
Did you say something ;-):-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2013 at 10:59 pm
as e4d4 said i unmarked the option create sub directories for databases. Now my maintenance plan is working. thanks for all of you for your valuable suggestions and helping me in solving this issue.
March 11, 2013 at 11:03 pm
Glad to hear it is working now.
As has been noted, I'd take a serious look into renaming that database. The database appears to have a space at the end of the name. You may run into other issues down the road due to this unless you plan for the space.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply