Archive for the ‘Backup & Restore’ Category

How to increase the SQL Database Restore speed using DB compression and Solid State Disks (2010-8-12)

a couple of months ago I blogged about how to speed up a full database backup; but what about the restore speed? Indeed also an interesting topic to investigate. So I ran all kind of tests and found out that it is possible to restore a database at least 3 times faster provided that you [...]

How to increase SQL Database Full Backup speed using compression and Solid State Disks (2010-1-15)

The SQL 2008 Database backup compression feature (which was introduced as a SQL2008 Enterprise Edition only feature) will become available in the SQL2008 R2 Standard Edition also ( SQL 2008 R2 Editions).  I’m using the compression feature for quite some time now and really love it; it saves significant amounts of disk space and increases [...]

Better Tag Cloud