Re: Restore takes more than 45 minutes

From: Ron Talmage (rtalmage@prospice.com)
Date: 08/30/02

Next message: Paul: "Remove NT Admin from SQL SysAdmin Role"
Previous message: Ron Talmage: "Re: login failed for user'sa'"
In reply to: TO: "Restore takes more than 45 minutes"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

From: "Ron Talmage" <rtalmage@prospice.com>
Date: Fri, 30 Aug 2002 12:40:12 -0700

Yes, it seems very long to me. On one database, we restore 12 Gigs in about
30+ minutes.

I'm not sure what the reason would be, but 45 minutes for 30MB is very slow.
It should be closer to 2 or 3 minutes, I think.

Ron

--
Ron Talmage
SQL Server MVP
"TO" <cto@aifs.com> wrote in message
news:105a501c25033$4e617840$39ef2ecf@TKMSFTNGXA08...
> A backup file with the total size of 30,250KB (45MB mdf)
> takes a more than 45 minutes to restore. Is this abnormal?
>
> It is running SQL2K SP2 Standard Edition on a Win2000 SP2
> machine, NT INTEL X86 platform, 2 processor and has 1GB of
> RAM.
>
> Anyone? help!

Next message: Paul: "Remove NT Admin from SQL SysAdmin Role"
Previous message: Ron Talmage: "Re: login failed for user'sa'"
In reply to: TO: "Restore takes more than 45 minutes"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]