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 [...]
Category:
Backup & Restore,
SQL 2008 R2,
Storage: SAN & SSD | Tags:
Backup,
Buffercount,
Compression,
DBCC TRACEON (3213,
DBCC TRACEON (3605,
Maxtransfersize,
Restore,
Solid State,
SQL2008R2 |
3 Comments
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 [...]
