Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Backup failes while executing the maintenance plan

Author  Topic 

csaha
Yak Posting Veteran

52 Posts

Posted - 2010-11-03 : 13:55:53
ailed:(-1073548784) Executing the query "BACKUP DATABASE [MWFMSys ] TO DISK =
N'E:\\Backup\\Differentialbackup\\MWFMSys \\MWFMSys _backup_201011031222.bak' WITH
DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'MWFMSys _backup_20101103122206', SKIP,
REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Cannot open backup device
'E:\\Backup\\Differentialbackup\\MWFMSys \\MWFMSys _backup_201011031222.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.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-03 : 13:57:02
Is that an extra space in the backup path? And should it be there?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

csaha
Yak Posting Veteran

52 Posts

Posted - 2010-11-03 : 14:02:31
No there is not a extra space in the backup path, somehow the database has a extra space can the detach and attach on a live system
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-03 : 14:13:00
Well there's an extra space in the error, so check your maintenance plan.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

csaha
Yak Posting Veteran

52 Posts

Posted - 2010-11-03 : 14:18:07
Maintenance plan was done using the GUI, so I just check the databases from the list.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-03 : 14:26:17
You still have to check the path in the maintenance plan. The error indicates your path is wrong. And I see a space in there, so it needs to be checked.

quote:

The system cannot find the path specified.




Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -