November 26, 2002 at 6:20 am
Using SQL Server 2000 on a Win2K cluster with 4 processors.
I started restoring my database from a .bak file and need to find out how the process is going (is it failing, is it almost done, etc).
I ran:
restore database mydatabase
from mydbfull
with norecovery
go
restore database mydatabase
from mydbdiff
with norecovery
go
restore log mydatabase
from mydbtrans
with recovery
go
I am restoring 192+ GB of data. Any idea how long that takes? I just passed 12 hours restoring. It SEEMS to be going fine, but how can I tell for sure?
-SQLBill
November 26, 2002 at 6:46 am
Of course it can vary for many reasons. However, if it encounters a problem it will stop and explain the problem. Then on top of this is the diff and transaction backups, the later actually playing al the transactions to apply them, so I would say maybe a good while as a best guesstamite.
November 26, 2002 at 7:06 am
Okay, in Enterprise Manager, next to my database is says (Loading). I can not find anything that says what that indicates.
My differential and transaction log restores failed because the database is IN LOAD.
What is this telling me? Is the recovery still going on? My Error logs and QA said the database is recovered.
What is this (LOADING) indication in EM?
-Bill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply