Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore database slow
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Divers
Thread ID:
00697240
Message ID:
00697385
Vues:
15
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform