Saturday, February 25, 2012

Restore 225GB database. ASYNC_IO_COMPLETION. (Help! I need this doing by morning) :o

I am trying to restore a 225GB database using backup exec, but does not seem
to be working. When I look at the processes in SQL one of the restore
processes is displaying ASYNC_IO_COMPLETION, the wait time seems to graduly
rising. As my restores have always worked in the past I've never looked at
the processes, is this normal? Or is this indicating a problem?
thanks in advance
GavHi,
"Ths is normal while restoring a database with large size
The status "ASYNC_IO" comes when the RESTORE process create the blank
database. In your case
the process will stay for some time being you are creating a large database.
FYI, RESTORE process will create a blank database with the exact same file
sizes as the database that is being restored. ASYNCH_IO is the mechanism
used to create a blank database.
I recommend you to execute the restore with STATS option from the Query
Analyzer :-
Restore database <dbname> from disk='c:\dbname.bak' with stats=10
-
Thanks
Hari
MCDBA
"Gav" <gavin.metcalfe@.nospam.btinternet.com> wrote in message
news:cdh8uf$c12$1@.sparta.btinternet.com...
> I am trying to restore a 225GB database using backup exec, but does not
seem
> to be working. When I look at the processes in SQL one of the restore
> processes is displaying ASYNC_IO_COMPLETION, the wait time seems to
graduly
> rising. As my restores have always worked in the past I've never looked at
> the processes, is this normal? Or is this indicating a problem?
> thanks in advance
> Gav
>|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:Ow1SRugbEHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> "Ths is normal while restoring a database with large size
> The status "ASYNC_IO" comes when the RESTORE process create the blank
> database. In your case
> the process will stay for some time being you are creating a large
database.
> FYI, RESTORE process will create a blank database with the exact same
file
> sizes as the database that is being restored. ASYNCH_IO is the mechanism
> used to create a blank database.
> I recommend you to execute the restore with STATS option from the Query
> Analyzer :-
> Restore database <dbname> from disk='c:\dbname.bak' with stats=10
>
> -
> Thanks
> Hari
> MCDBA
> "Gav" <gavin.metcalfe@.nospam.btinternet.com> wrote in message
> news:cdh8uf$c12$1@.sparta.btinternet.com...
> seem
> graduly
at[vbcol=seagreen]
>
thanks for the info. :o) Turns out the box we were restoring it too was
running a bit slow. We tested a restore of a 15Gb database to test
everything was working correctly and then left the big restore restoring
overnight.
Gav

No comments:

Post a Comment