August 2, 2002 at 12:46 pm
Hello everyone,
I am running a Backup Exec restore. I have done restore before and my restore today is bascially using the same process/parameters/etc. However, the restore has been sitting there without any progress for the past 15 minutes. The databases are small, so I imagine it should take little time or at least Backup Exec should show certain percentage that is complete, but it doesn't. I wish it would just crash and give me an error so that I can pinpoint the problem. Any ideas? Any and all help is very much appreciated.
August 2, 2002 at 12:48 pm
I am sorry, never mind, it is now working. But it is odd that it was just sitting there for 15 minutes. Whats more weird is it started working right after I posted this message. Could this board have something to do with it? :o) Thanks anyways everyone.
August 2, 2002 at 2:17 pm
I didn't find anything pertaining to any users being online. However, I saw this:
"Bypassing recovery for database 'HJTA' because it is marked IN LOAD."
What does that mean?
October 6, 2006 at 12:42 pm
Got the same message today. I guess that while the database restore is running that other regular tasks can't be performed hence the bypass. But I guess this is somewhat obvious!
October 6, 2006 at 1:39 pm
It looks like some other restore is occuring when you try to do your restore.
-SQLBill
October 7, 2006 at 12:17 am
Looks like you are restoring series of backup i.e.
Restoring full backup with no recovery
Below is a small sample
==============
create database ssc
select getdate()
backup database ssc to disk = 'c:\ssc.bak'
select getdate()
backup LOG ssc to disk = 'c:\ssc.trn'
select getdate()
drop database ssc
select getdate()
restore database ssc_restore from disk = 'c:\ssc.bak' with norecovery
select getdate()
restore LOG ssc_restore from disk = 'c:\ssc.bak' with recovery
========
Below is the snapshot of errorlog
2006-10-07 02:13:54.32 backup Database restored: Database: ssc_restore, creation date(time): 2006/10/07(02:13:52), first LSN: 5:23:
2006-10-07 02:13:54.49 spid52 Starting up database 'ssc_restore'.
2006-10-07 02:13:54.51 spid52 Bypassing recovery for database 'ssc_restore' because it is marked IN LOAD.
2006-10-07 02:13:54.57 spid52 Starting up database 'ssc_restore'.
2006-10-07 02:13:54.60 spid52 Bypassing recovery for database 'ssc_restore' because it is marked IN LOAD.
2006-10-07 02:13:54.63 spid52 Recovery is checkpointing database 'ssc_restore' (13)
2006-10-07 02:13:54.77 spid52 Starting up database 'ssc_restore'.
2006-10-07 02:13:55.79 backup Log restored: Database: ssc_restore, creation date(time): 2006/10/07(02:13:52), first LSN: 5:23:1, la
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply