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

Maintenance plan job error Expand / Collapse
Author
Message
Posted Monday, January 14, 2013 11:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
Hi, can anyone help me with this error? I suppose to have a backup plan running every 2 months but now i received this error message. Im using SQL 2005.


Executing the query "BACKUP DATABASE [BDSBPM] TO DISK = N'D:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Backup\\BDSBPM\\BDSBPM_backup_201301010300.bak' WITH NOFORMAT, NOINIT, NAME = N'BDSBPM_backup_20130101030014', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Cannot open backup device 'D:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Backup\\BDSBPM\\BDSBPM_backup_201301010300.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.

Thanks everyone!
Post #1407045
Posted Tuesday, January 15, 2013 1:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:10 AM
Points: 5,221, Visits: 5,119

failed with the following error: "Cannot open backup device 'D:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Backup\\BDSBPM\\BDSBPM_backup_201301010300.bak'. Operating system error 3(The system cannot find the path specified.).


Ensure the path is correct

A backup every 2 months? What do you do inbetween the two months? Is the business happy with loosing 2 months worth of data?




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407083
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse