Re: Restore from backup very slow

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/05/04 

Date: Sat, 5 Jun 2004 02:28:40 +0200

... and not only the same size. It has to have the same number of database files, where each has the same
logical file name and at least the same size as when you took the backup. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DeeJay Puar" <deejaypuar@yahoo.com> wrote in message news:1880b01c44a6f$d56cf750$a001280a@phx.gbl...
> Just adding to Geoff already said, this process only
> happens if you are restoring the backup to a different
> server than the original server and the database does not
> exist on the new server.
>
> If you are restoring a backup file to original server and
> database is present, data files are not re-created and
> restore process is much faster.
>
> In the future, if you have to restore the database to a
> different server or same server with a new  db name, it is
> recommended that you create a same size database before
> you kick-off the restore.
>
> DeeJay
> >-----Original Message-----
> >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: Problem with disable msde connection pool
    ... 'ALTER DATABASE TestDB SET single_user WITH ROLLBACK after 10 ... ' Restart the server... ... ' Execute query through SQLDMO to run the restore TSQL command ... the connection pool must be disabled. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... I understand that the Public Folder Store ... > database cannot be mounted due to integrity problems, ... > the pub.edb database from your backup of the old Server, ... please try the following steps to restore your public ...
    (microsoft.public.windows.server.sbs)
  • RE: Restore public folders and companyweb
    ... The new server must have the same domain name as the original server ... where the backup of the database. ... For the detailed steps to restore the SharePoint Services databases, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
Loading