Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore database slow
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00697240
Message ID:
00697385
Views:
16
>When we restore database from backup file in one hard disk system. That backup file size is 4 GB. It take more than 3 hours. Which kind option can we us to make restore faster?
>
>I also find the restore is much slower in the server with hard disk array system or raid 5 system than one hard disk system. Is it normal?

Oh yes, that's normal. Raid5 has to spread the data over the (three) disks, has to do some calculations etc. Obviously this doesn't account for restores only, but for any normal writing apps.
Have the disks duplicated instead. Saves a disk as well... (NT (like Novell) can do this from nature, though the hardware needed is harder to find nowadays).
Both Novell and NT gain from elevator seeking; at retrieving the data it's faster than Raid5 too.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform