Comments
Sort by recent activity
Linda,
I'm glad that you will look at the deleting of partial backups caused by disk full failures.
Can I get an answer to my real question about the DISKRETRIES option when the backup fills up the disk before it finishes. Will the default 10 retries keep trying to backup even though there is no disk space?
Thanks
Chris / comments
Linda,
I'm glad that you will look at the deleting of partial backups caused by disk full failures.
Can I get an answer to my real question about the DISKRETRIES option when the backup fills up the...
Thanks Petey. / comments
Thanks Petey.
I am assuming that you are running SQL2005 or SQL2008 not SQL2000.
Remember that a full backup does not flush the transaction log and I believe the same would be true of a differential backup.
Unless your database is in the simple recovery model your log must be increasing in size without the log backup.
To restore a database you need the last full followed by the last differential followed by the log backups run after the differential.
HTH
Chris / comments
I am assuming that you are running SQL2005 or SQL2008 not SQL2000.
Remember that a full backup does not flush the transaction log and I believe the same would be true of a differential backup.
Unle...
Hi,
I just upgrade a 64_bit cluser from 6.3 to 6.4. if I look in the Cluster Admin, right click 'SQLBackupAgent' amd select properties I can see 4 entries inder the Registry replication tab. 2 are for Software\WOW6432Node\Red Gate and the other 2 are Software\Red Gate.
Which ones should I remove?
Thanks
Chris
We are seeing the Event 1080 in some 64_bit clusters but not all of ours. / comments
Hi,
I just upgrade a 64_bit cluser from 6.3 to 6.4. if I look in the Cluster Admin, right click 'SQLBackupAgent' amd select properties I can see 4 entries inder the Registry replication tab. 2 are ...
David,
Usually you want to delete backup files of the same type as you have just created. A solution that I use quite a lot is to have the job have a Raiserror step. The error number has to be greater than 50000 and it needs to have @with_log = 'TRUE' so it writes to the event viewer log. Then an alert can pick up the error number and that fires another job that does what you want to do, in this case start deleting log backups.
HTH
Chris / comments
David,
Usually you want to delete backup files of the same type as you have just created. A solution that I use quite a lot is to have the job have a Raiserror step. The error number has to be grea...
Robin,
Is 6.3 only fixing installation issues?
Thanks
Chris / comments
Robin,
Is 6.3 only fixing installation issues?
Thanks
Chris
Cheers Robin.
Having read about and tried the beta V 6 I want to upgrade and need to plan the upgrade approach with the format change in mind but with the 2 point upgrades I wanted to go to a 'good stable' version.
From your helpfull info I can start the planning process based on the version that is current rather than wait.
SQLBackup has saved large amounts of storage for us since we started to use it.
Thanks
Chris / comments
Cheers Robin.
Having read about and tried the beta V 6 I want to upgrade and need to plan the upgrade approach with the format change in mind but with the 2 point upgrades I wanted to go to a 'good...
Robin,
I have been waiting to start to use 6.0 but noticing first 6.1 and then 6.2 coming out I am wary that you aren't going to introduce 6.3 soon. As a user of SQLBackup for close to 2 years now I have not seen this many updates in so short a time.
Can I get some sort of response that 6.2 is a stable release please? I do understand that the Object level functionality would have demanded a new release.
Thanks
Chris / comments
Robin,
I have been waiting to start to use 6.0 but noticing first 6.1 and then 6.2 coming out I am wary that you aren't going to introduce 6.3 soon. As a user of SQLBackup for close to 2 years now ...
Robin,
You can file this one as closed as I was able to see and get the update from one server but not from others. I then remembered how to download the Toolkit from your site. That's all I really needed as I save it centrally and update from that location on a server-by-server basis.
Chris / comments
Robin,
You can file this one as closed as I was able to see and get the update from one server but not from others. I then remembered how to download the Toolkit from your site. That's all I really...
Robin,
I've been busy with the latest Microsoft patches. I hope to try this out again by the end of next week. I also realise that the 7 hour time difference makes the communications difficult. Get back on this soon.
Thanks
Chris / comments
Robin,
I've been busy with the latest Microsoft patches. I hope to try this out again by the end of next week. I also realise that the 7 hour time difference makes the communications difficult. Get...