Activity overview
Latest activity by stevew
Thanks for the info, I've gone through the optimisation process and found the following optimised settings on a 4GB db is
Database size : 4.110 GB
Compressed data size: 830.275 MB
Compression rate : 80.27%
Data rate : 5.912 MB/sec
Duration : 713.141 seconds
with three threads
Unfortunately the database files and backups are on the same disks however this is how it was passed to me. This means the large db should take around 9 hours to complete, the problem that I've encountered previously when it has been backing up is the system performance has been degraded due to disk i/o.
I'm in a catch 22 situation, the reason for purchasing SQL Backup was for the compression as we didn't have sufficient space to backup the database. It looks like I'll need to review the server set up especially the disk subsystem to get the level of performance we need for this environment. / comments
Thanks for the info, I've gone through the optimisation process and found the following optimised settings on a 4GB db is
Database size : 4.110 GB
Compressed data size: 830.275 MB
Compression...
Optimising Backups
I'm new to SQL Backup and need some help to understand the best practice on optimising backups for large databases. I'm using SQL Backup V5.1 on 210GB database in a Production environment and curre...