Re: Restore from backup very slow

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 15:57:10 -0400

SQL is creating and initializing the data files. Once they are ready, the
RESTORE command will load the data. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dknapp" <anonymous@discussions.microsoft.com> wrote in message
news:B8BE8F73-A2CE-43D0-B24B-EE4D56857A61@microsoft.com...
> When we restore a db from a standard SQL .BAK file, the process sits and
seemingly does nothing for a good bit of time, well over an hour, before the
progress bar starts to move (we are using EM for the restore).  Server
version is SQL2K(SP3) on Win2K machine, 2 GB RAM, nothing else running on
the box.  The backup was 14GB in size.  Is SQL doing some sort of
verification or something before starting the restore?  The backup itself
takes only 15 minutes or so.  The .BAK file is on the same drive as the
destination DB.

Relevant Pages

  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... We are physically separating log and data files on separate disks. ... the binn folder which contains the sql server executable among other things. ...
    (microsoft.public.sqlserver.setup)
  • Re: Restoring a SSP 3.0
    ... Also make sure this accounts are configured correctly in the IIS application ... Backup ContentDB in SQL Server using SQL Managagement Studio ... Restore the ContentDB from step 1 to new env. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Migration ?
    ... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migration ?
    ... During a restore, all of the metadata is upgraded. ... Moving the Master and MSDB database, what if the old server where those ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)
  • RE: Trying to RESTORE a sql 2000 db on a different drive letter.
    ... During the installation of sql server, if you did not pick the d: ... the data drive or the system files drives, it will not have the necessary ... Right click on the database you want to restore. ...
    (microsoft.public.sqlserver.setup)