January 14, 2013 at 11:52 pm
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!
January 15, 2013 at 1:52 am
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?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply