Comments
Sort by recent activity
Compression is one of the main benefits to using SQLBackup and can improve thruput because it uses the disk buffering better than using small data.
Glad to here you are running better now.
Chris / comments
Compression is one of the main benefits to using SQLBackup and can improve thruput because it uses the disk buffering better than using small data.
Glad to here you are running better now.
Chris
Just out of interest.
Your full backup must be 300Gb plus and that first log backup is how big?
Chris / comments
Just out of interest.
Your full backup must be 300Gb plus and that first log backup is how big?
Chris
Lets see next week how big the first log backup is after the full has finished. Its a holiday here Monday so I'll check back on Tuesday.
Chris / comments
Lets see next week how big the first log backup is after the full has finished. Its a holiday here Monday so I'll check back on Tuesday.
Chris
You must have a pretty big log backup directly after the full as lots of data could be added after the full starts and before it ends. The backup has to contain only completed transactions so it can be used in a restore that doesn't compromise the data integrity.
I share your pain as who would want to be the one to cause a data problem by implementing a new scheme. I have been waiting to implement split backups on our big production database as we cross restore the backups to testing servers and don't want to cause problems.
Chris / comments
You must have a pretty big log backup directly after the full as lots of data could be added after the full starts and before it ends. The backup has to contain only completed transactions so it ca...
Sounds like splitting the backup to multiple files should be the way to go except for the first deduplication run. You should gain in the backup and lose it once in the replication.
Chris / comments
Sounds like splitting the backup to multiple files should be the way to go except for the first deduplication run. You should gain in the backup and lose it once in the replication.
Chris
You must have some very slow disks. My biggest database that I use SQLBackup on is 260Gb with 180Gb of data and using compression level of 2 I get it backed up in 30 minutes. As this is SQL2005 on W2K3 I want to change this to 2 file output so that copying the backup file to another server puts less stress on the server. I should be able to bring this down further then.
One of the original benefits of using backup compression was to bring the time taken to run the backup down from what the native maintenance plan performed at.
Have you tried some of the many backup options to bring the backup time down?
Chris / comments
You must have some very slow disks. My biggest database that I use SQLBackup on is 260Gb with 180Gb of data and using compression level of 2 I get it backed up in 30 minutes. As this is SQL2005 on ...
Why aren't you compressing the Full backups? This is one of the main reasons to use SQLBackup. Unless you have inherited this situation.
Chris / comments
Why aren't you compressing the Full backups? This is one of the main reasons to use SQLBackup. Unless you have inherited this situation.
Chris
How big are your databases that they take 4 hours to backup and do you include the verify in this time?
There are ways to speed this up.
Chris / comments
How big are your databases that they take 4 hours to backup and do you include the verify in this time?
There are ways to speed this up.
Chris
Marianne,
You we vert true to your word as I see the 7.0.4.2 post.
Thanks
Chris / comments
Marianne,
You we vert true to your word as I see the 7.0.4.2 post.
Thanks
Chris
Can I ask that you post a current version/build to this forum so we can all see when a new build has been made generally available or is this posted somewhere else?
I found out about 7.0.3.2 by checking for upgrades on the upgrade center page and then later by opening the backup GUI on one of my servers that showed the upgrade available.
Thanks
Chris / comments
Can I ask that you post a current version/build to this forum so we can all see when a new build has been made generally available or is this posted somewhere else?
I found out about 7.0.3.2 by che...