Activity overview
Latest activity by bradrman
Please forgive my ignorance on this matter, but if SQL Backup simply passes a 'Normal' backup command to SQL Server, How is it that it is much much faster than the native backup? Also, when/how is it compressed? Also If Sql Backup uncompresses the data and then issues a 'Normal' Sql Server restore, how come the restore is also much much faster? / comments
Please forgive my ignorance on this matter, but if SQL Backup simply passes a 'Normal' backup command to SQL Server, How is it that it is much much faster than the native backup? Also, when/how is ...
Peter Yeoh,
So what you are saying is that by using Red-Gate's SQL Backup extended stored procedure and passing the 'WITH CHECKSUM' that it performs a native Sql Server CHECKSUM verification? And then SQL Backup compresses the data? / comments
Peter Yeoh,
So what you are saying is that by using Red-Gate's SQL Backup extended stored procedure and passing the 'WITH CHECKSUM' that it performs a native Sql Server CHECKSUM verification? And t...
Peter Yeoh,
The extended SP does not allow you to specify the WITH CHECKSUM options like it does for native sql server backups/restore. So if you specified the the WITH CHECKSUM option on the backup how would you veryify the checksums with out a full restore using the WITH CHECKSUM option...which _is_ supported by SQL Backup ?
Brad S / comments
Peter Yeoh,
The extended SP does not allow you to specify the WITH CHECKSUM options like it does for native sql server backups/restore. So if you specified the the WITH CHECKSUM option on the back...