02-01-2015 05:16 PM
Hi
I backup this using my daily backup sched and it worked okey, when I run a yearly backup with verify on, I experience the following errors,
Hope you can advise me to how to troubleshoot this errors. Im using BE2014, Full backup only Daily and Monthly and Yearly. Backing up files only,SQL only backing up .bak files
Directory Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ was not found, or could not be ac... None of the files or subdirectories contained within will be backed up. V-79-57344-33967 - The directory or file was not found, or could not be accessed. V-79-57344-65033 - Directory not found. Cannot backup directory \sqlExport and its subdirectories.
Best Regards
02-01-2015 05:42 PM
WARNING: "\\SERVER\D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DICSE_work_backup_201501312000.bak" is a corrupt file. This file cannot verify.
Unable to open the item \\SERVER\D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\master_backup_201501292000.bak - skipped.
Unable to open the item \\SERVER\D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\mdmSYNC_backup_201501292000.bak - skipped.
Unable to open the item \\SERVER\D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\msdb_backup_201501292000.bak - skipped.
Unable to open the item \\SERVER\D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DICSE_backup_201501292000.bak - skipped.
Unable to open the item \\SERVER\D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DICSE_backup_201501292000.bak - skipped.
Verify- \\\SERVER\D: SQL2005
WARNING: "DICSE_work_backup_201501312000.bak" is a corrupt file. This file cannot verify.
02-01-2015 05:49 PM
Are these files actually present in the specified location ?
Is Advanced Open File option enabled ? If not, do enable it and set it to the microsoft vss provider.
If running any AV, set it to exclude from scanning the BE processes.
02-01-2015 06:13 PM
To add-up to what VJware suggested, please read below TN, this might help you solve the problem.
Regards,
Adonis
02-01-2015 06:27 PM
Hi Sir VJware
02-01-2015 07:54 PM
Do ensure Shadow Copies are enabled on the specific volume and its set to No Limit as well.
Are the status of all VSS writers OK when you run the command ~ vssadmin list writers from the cmd ?
Are there any VSS / volsnap errors under the remote server's event viewer ?
02-01-2015 07:56 PM
02-01-2015 11:08 PM
I will be performing the test to diagnose the problem, currently documenting all the procedures.
Are these files actually present in the specified location ? - yes alot of files were skipped and not backup
Is Advanced Open File option enabled ? If not, do enable it and set it to the microsoft vss provider.
AOF was enabled but is set to Automatic Allow VSS to select the snapshot provider.
Changing it to System - Use Microsoft Software Shadow Copy Provider
Q1:Default AOF setting was okey on my daily backup, is it recommended to change it to "Use Microsoft Software Shadow Copy Provider" also?
If running any AV, set it to exclude from scanning the BE processes.
It is already excluded sir