What are the challenges you face when working across database platforms? Take the survey
Options

More 5.0 bugs

PowerwayPowerway Posts: 29
edited May 23, 2007 6:18AM in SQL Backup Previous Versions
1.

Sometimes a job with multiple schedules will not show all the schedules when you edit the job.

2.

A backup with VERIFY ON will not show that it's been verified in the Activity History tab even after the verify has completed successfully.

3.

There are times when SQL Backup will either never delete backup files per the job's cleanup parameters or will stop deleting backups after the jobs run a while. I'm currently running Filemon to monitor the backup folder to see if SQL Backup stops trying to delete the files are is getting some sort of error while trying to delete the backup files.

4.

The Date column in Activity History should be sized to show the date AND time by default.

Comments

  • Options
    Here is a FileMon dump after a differential backup when it stops deleting older backup files. The result is differential backups are now NOT getting deleted every 4 hours like the job requests.

    Normally the filemon output will show all of the backup files being queried and then the ones diffs over 4 hours are deleted. For some reason this just stops happening.

    6:50:00 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ NO SUCH FILE FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:00 PM SQBCoreService.:9560 CREATE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: OverwriteIf NoBuffer Access: 00120196
    6:50:00 PM SQBCoreService.:9560 WRITE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:02 PM explorer.exe:8304 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: FULL_(local)_v3-prodcopy_20070509_133501.sqb
    6:50:03 PM SQBCoreService.:9560 WRITE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 1024 Length: 4149248
    6:50:03 PM SQBCoreService.:9560 FLUSH C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM DkService.exe:1264 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: 00100080
    6:50:03 PM DkService.exe:1264 QUERY INFORMATION C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS FileFsVolumeInformation
    6:50:03 PM DkService.exe:1264 QUERY INFORMATION C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb BUFFER OVERFLOW FileAllInformation
    6:50:03 PM DkService.exe:1264 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: 0012019F
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: 0012019F
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 WRITE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 FLUSH C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 WRITE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 4096
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM DkService.exe:1264 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: 00100080
    6:50:03 PM DkService.exe:1264 QUERY INFORMATION C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS FileFsVolumeInformation
    6:50:03 PM DkService.exe:1264 QUERY INFORMATION C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb BUFFER OVERFLOW FileAllInformation
    6:50:03 PM DkService.exe:1264 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: Read
    6:50:03 PM SQBCoreService.:9560 QUERY INFORMATION C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Length: 4150272
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: Read
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: Read
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: Read
    6:50:03 PM SQBCoreService.:9560 QUERY INFORMATION C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Length: 4150272
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: Read
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: Read
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: Read
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open Access: Read
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 DIRECTORY C:\Backups\ SUCCESS FileBothDirectoryInformation: DIFF_(local)_v3-prodcopy_20070509_185000.sqb
    6:50:03 PM SQBCoreService.:9560 OPEN C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Options: Open NoBuffer Access: Read
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 0 Length: 1024
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 1024 Length: 524288
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 525312 Length: 524288
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 1049600 Length: 524288
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 1573888 Length: 524288
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 2098176 Length: 524288
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 2622464 Length: 524288
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 3146752 Length: 524288
    6:50:03 PM SQBCoreService.:9560 READ C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS Offset: 3671040 Length: 524288
    6:50:03 PM SQBCoreService.:9560 CLOSE C:\Backups\DIFF_(local)_v3-prodcopy_20070509_185000.sqb SUCCESS
  • Options
    peteypetey Posts: 2,358 New member
    Were there any errors or warnings recorded for the differential backup that completed? You can check the SQL Backup log for this (default folder is <system drive>\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Nope no errors recorded. It just stops deleting files. I'm testing using two different servers and they both behave the same way.

    It'll work for a while and then it will just stop working and then the disks will fill up after a few days.

    Filemon just shows that it no longer even commands a delete. You can see it emumerating the folder but no delete commands are executed.
  • Options
    peteypetey Posts: 2,358 New member
    I've prepared a debug version of the command line interface (SQLBackupC.exe) which will tell us what's happenning during the file deletion process. I've PM-ed you the download location.

    Could you pls run a test backup using that application, and give us the results? Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    I am having the same problem where my files are not being deleted. This is a HUGE problem and I need to manually go in every day and delete the files now. Please tell me there is a fix.
  • Options
    Re deleting existing backup files.

    I have the same problem.

    I user the v5 backup interface to define a scheduled job which should delete existing backup files older than 2 days.

    Is there a fix / any advice on how to cope?
  • Options
    There will be a bug fix in version 5.1 due to be released in the next few days which addresses the fact that ERASEFILES doesn't always work when the VERIFY keyword is also used.
    Helen Joyce
    SQL Backup Project Manager
    Red Gate Software
Sign In or Register to comment.