Posts
Sort by recent activity
6.2 and Verify in the GUI
Its good to see the verify display problem has been fixed in 6.2.
I had a large backup with a verify and it shows in the in progress as still running and in the complete but not verified. Once the ...
Speed of Compression 4 on Large Database 200Gb plus
I am testing the tradeoffs of the compression levels for a 200Gb plus database using 6.2.0.134.
We usually use level 2 and this compressed the backup slightly more than 5.4 level 2. Both took just ...
Restoring differential backups and permissions
Hi,
We are trying to use differential backups as a way of reducing the time and disk space requirements on databases over 100Gb.
We use T-SQL scripts to perform backups and restores for security re...
DiskRetry options in version 6 and Full disks
Hi,
Would I be right in assuming that if the backup disk gets full and the DISKRETRYCOUNT > 0 then it will continue to try to write to the disk until the retries count is passed?
Most of our proble...
Differential Restores
Hi,
This is probably a dumb question but I could not find the exact syntax for a differential restore.
As a differential backup is a BACKUP DATABASE[....] TO .... WITH DIFFERENTIAL I think that I c...
Upgrading from 5.4 to 6.1
Hi,
As a registered user of SQLBackup I was expecting the GUI to indicate that the newer 6.1 version was available either at startup or by checking for updates. When will the Check for updates show...
Kill Existing Connections
This seems like a good option. Are you doing an ALTER DATABASE with ROLLBACK IMMEDIATE, in the background so as to stop the active transactions?
Thanks
Chris
Verifying that a Red Gate Backup had Checksum enabled
Hi,
I have a need to run an SQLBackup with the CHECKSUM option enabled. In a test it didn't seem to take much longer to run than a full backup without the checksum option. I then tested running the...
Backup Files created even when SQLBackup errors
Hi,
We managed to fill up our backup disk this Saturday because we ran out of disk space during a backup. The partial backup files remained on the disk causing the Sunday backups to fail as well wi...
Seeing Multiply Lines in the log of a completed job
On one of my SQL2005 SP2 servers running SQLBackup 5.4 I see 3 lines when I right click properties on a completed job in the GUI under the Activity History tab.
At one time there was more than 1 se...