> 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.

Hardware specs, especially the storage specs, do matter! Given a decent
RAID, I'd say your restore time is much too long, and I'd take a close look
at how the storage subsystem is doing during the restore.

Linchi

"NC3" wrote:

> 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.
>