Archive for the ‘Backup & Restore’ Category

Restoring a database onto a larger APS (2014-12-23)

Category: APS, Backup & Restore, PDW, Workload & Capacity Planning | Tags: | No Comments

For benchmarking purposes I was restoring a backup taken on a 4 node APS onto an 8 node APS (Microsoft Analytics Platform System). And the unexpected happened; I started to receive warnings that the system was running low on available disk space! (For those of you who never worked with APS; an 8 node full […]

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

Category: Backup & Restore, Performance tip, Storage: SAN & SSD | 4 Comments

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 […]

« Older Entries
Better Tag Cloud