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 12»»

Maintance plan -- full backup error Expand / Collapse
Author
Message
Posted Wednesday, December 18, 2013 3:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:43 AM
Points: 17, Visits: 52
Hi,

We do run a maintenance plan full backup job for all db's in the server. The job is able to take full backup for all DB's except one DB. When I run the T-Script full backup or maintenance plan full backup job particularly only for this DB, it runs successful.

Please suggest me for an solution:

Executing the query "BACKUP DATABASE [xxxx ] TO DISK = N'xxxx" failed with the following error: "Cannot open backup device 'xxxx.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.

Error No: -1073548784
Post #1524012
Posted Wednesday, December 18, 2013 3:56 AM This worked for the OP Answer marked as solution
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:43 AM
Points: 17, Visits: 52
I have tried deleting the folder and run agin.. but no luck.

It runs good through T-SQL script
Post #1524014
Posted Wednesday, December 18, 2013 4:18 AM This worked for the OP Answer marked as solution


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:30 AM
Points: 2,237, Visits: 2,685
Are the backups of the other databases written to the same folder?
Does the SQL Agent service account has the correct permissions to that folder?


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1524024
Posted Wednesday, December 18, 2013 4:49 AM This worked for the OP Answer marked as solution


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 11:13 AM
Points: 15,527, Visits: 27,909
Yeah, it sounds like the account that it's running under doesn't have access. Validate which account is running Agent. Make sure it's an account with access to your network and not local system accounts.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1524033
Posted Thursday, December 19, 2013 5:41 AM This worked for the OP Answer marked as solution
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:43 AM
Points: 17, Visits: 52
Hi HanShi,

Thank you for responding..
All the backups are taken to same folder . and also SQL Agent also has the required permission on it .

Thanks,
Sita
Post #1524528
Posted Thursday, December 19, 2013 5:46 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 11:13 AM
Points: 15,527, Visits: 27,909
You have a very clear error:

The system cannot find the path specified


It has to be something related to this issue.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1524530
Posted Thursday, December 19, 2013 8:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:30 AM
Points: 2,237, Visits: 2,685
Do you create your backups directly to disk, or are you writing to a backup-device? In this last mentioned situation the backup-device need to exist. You can query the existing ones by executing
select * from master.sys.backup_devices

You can add a new device by executing the "master..sp_addumpdevice" stored procedure.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1524625
Posted Monday, December 23, 2013 4:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:43 AM
Points: 17, Visits: 52
Yes , got it. There was a space at the end of the database name which was found and creating issue.

Thanks a lot
Post #1525461
Posted Monday, December 23, 2013 4:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:43 AM
Points: 17, Visits: 52
Any idea to remove/consider space while taking backup through maintenance plan?
Post #1525462
Posted Tuesday, December 24, 2013 5:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:30 AM
Points: 2,237, Visits: 2,685
Default setup of maintenance plan is through a GUI. This will always have the risk of wrong manual input.
If you want to control the variables you need to build the maintenance tasks with scripting.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1525732
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse