I have used SQL Server 2005 Database Maintenance Plans to establish full backups and hourly transaction log backups. The jobs that stem from the DB Subplans run fine and report no errors when I view the history on them, however I have noticed the following error in my SQL Server error log. I am not seeing a similar error for my database backups, only the hourly log backups. Space is not an issue. Any guidance on this one would be greatly appreciated.
18204 :
BackupDiskFile::CreateMedia: Backup device <'Path\logname'> failed to create. Operating system
error = 2(The system cannot find the file specified.).
Thanks,
Jason
Have you checked that all directories exists that are used in your maintenance plan?
Daan
|||Is the job which to take full and log backups succeeds ? if not check check if the sql startup account has modify privileges to the path mentioned in the maintenanance plan....Thanxx
Deepak
|||
Please check if you have all the necessary permissions on the destination driver as Deepak said. Also, please check if this KB is applicable to you: http://support.microsoft.com/kb/255235
HTH
sql
No comments:
Post a Comment