Restore takes more than 45 minutes

From: TO (cto@aifs.com)
Date: 08/30/02 

From: "TO" <cto@aifs.com>
Date: Fri, 30 Aug 2002 07:41:20 -0700

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!

Relevant Pages

  • corrupted backup file
    ... so we're trying to restore the database using the backup file ... we noticed that we're unable to restore the DB because the ... I'm not sure if our MDF & LDF files are good. ...
    (microsoft.public.sqlserver.server)
  • Restoring from Backup without logs
    ... We have received a backup file that is 6G in size. ... The log file is ... about 74G while the MDF is about 5 G when we restored. ... to run a SQL script to restore the .BAK file without restoring the log ...
    (comp.databases.ms-sqlserver)
  • Error when trying to do a restore with AS !
    ... I am trying to do a system restore using AS ... partnership name (this ... >AS keeps popping up with "The slected backup file is not ... it uses a small amount of power to save the ...
    (microsoft.public.pocketpc.activesync)
  • Re: Urgent - Unable to restore/attach a MDF file
    ... This restore error might be because:- ... Might be reading the backup file from remote machine in which SQL Server ... Will be VERY grateful for your urgent reply. ...
    (microsoft.public.sqlserver.setup)
  • Re: backup file unrecognizable
    ... Well What I read last night it appears that backing up over the net is ok ... During the restore the Network may not be available.) ... >> destined for the root drive on my client machine. ... >> backup file when I point to the path on my client machine. ...
    (microsoft.public.windows.server.sbs)