Afficher un message
Vieux 27/03/2008, 17h14   #2
Davy Shipley
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: How long a does restore take

I use SQLLitespeed to backup and restore.
I can backup a 80Gb database to a 21Gb compressed backup in approximately 25
minutes.
I can do the restore within 45 minutes.



"NC3" <ncoleman3@yahoo.com> wrote in message
news:2b5a9b35-78cc-4f7b-bad1-47274a608b55@a1g2000hsb.googlegroups.com...
>I have a 52 GB database that take 3 hours to restore using SQL Server
> native restore. Does this seem long to anyone who has experience with
> databses of this size? I know each insatalltion is different so things
> like this can vary.
>
> The hardware specs don't seem to matter much because I've restored the
> database on hardware with different specs but the restore times are
> consistent. The database is a publisher in a trasnactional replciation
> topology and I don't know if that matters or not.
>
> the hardware is our environment for SQL is generally the same dual 2/8
> Ghz with 4 to 8 gb or RAM. We do use SATA drives which I understand
> are slower drives but I'm not the sys admin guru.
>
> any insught is appreciated.


  Réponse avec citation
 
Page generated in 0,09371 seconds with 9 queries