November 23, 2004 at 10:25 am
SQL Server 2000 in Windows 2003
I did a restore, the restore is not successful. In EM, my database icon say loading when I left it @ 5 pm. Then I checked the logs say that trying to restore. I left it overnight then when I come back this morning @ 9:00 am still saying loading. Any ideas what is wrong?
November 23, 2004 at 12:04 pm
How large is the db? Loading means just that, it's loading from a restore. Is it possible that you checked the box that allows for more restores?
Did the restore complete?
November 23, 2004 at 12:11 pm
Or did you restore with norecovery option? Check SQL Server errorlog, If you see message "Bypassing recovery for database 'xxx' because it is marked IN LOAD", Try restore the database recovery option.
November 23, 2004 at 12:33 pm
Here's the error log:
2004-11-18 15:31:21.84 spid11 1 transactions rolled back in database 'LEON' (7).
2004-11-18 15:31:21.95 spid11 Recovery is checkpointing database 'LEON' (7)
2004-11-18 15:31:23.32 spid3 Recovery complete.
2004-11-18 15:31:23.32 spid3 SQL global counter collection task is created.
2004-11-18 15:31:27.17 spid51 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
2004-11-18 15:57:37.18 spid53 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
2004-11-19 15:24:00.34 spid53 Starting up database 'LEON'.
2004-11-19 15:24:00.37 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:24:04.32 backup Database restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 1954:11228:1, last LSN: 1954:11234:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_db_200411190115.BAK'}).
2004-11-19 15:26:35.37 spid53 Starting up database 'LEON'.
2004-11-19 15:26:35.38 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:26:39.21 backup Database changes restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 1954:16231:10, last LSN: 1954:16234:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_diff_backup.diff'}).
2004-11-19 15:26:39.90 spid53 Starting up database 'LEON'.
2004-11-19 15:26:39.93 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:26:45.48 backup Log restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 1954:16234:1, last LSN: 1954:17519:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_tlog_200411190900.TRN'}).
2004-11-19 15:26:45.96 spid53 Starting up database 'LEON'.
2004-11-19 15:26:45.99 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:26:50.26 backup Log restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 1954:17519:1, last LSN: 1954:18064:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_tlog_200411191000.TRN'}).
2004-11-19 15:26:50.93 spid53 Starting up database 'LEON'.
2004-11-19 15:26:50.96 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:26:57.65 backup Log restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 1954:18064:1, last LSN: 1954:19419:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_tlog_200411191100.TRN'}).
2004-11-19 15:26:58.27 spid53 Starting up database 'LEON'.
2004-11-19 15:26:58.30 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:27:04.99 backup Log restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 1954:19419:1, last LSN: 1954:20877:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_tlog_200411191200.TRN'}).
2004-11-19 15:27:05.63 spid53 Starting up database 'LEON'.
2004-11-19 15:27:05.66 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:27:11.19 backup Log restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 1954:20877:1, last LSN: 1954:22169:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_tlog_200411191300.TRN'}).
2004-11-19 15:27:11.87 spid53 Starting up database 'LEON'.
2004-11-19 15:27:11.90 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:27:18.60 spid53 Starting up database 'LEON'.
2004-11-19 15:27:18.63 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-19 15:27:20.15 spid53 Recovery is checkpointing database 'LEON' (7)
2004-11-19 15:27:20.77 spid53 Starting up database 'LEON'.
2004-11-19 15:27:22.37 backup Log restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 1954:22169:1, last LSN: 1954:24016:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_tlog_200411191400.TRN'}).
2004-11-22 16:34:31.92 spid53 Starting up database 'LEON'.
2004-11-22 16:34:31.95 spid53 Bypassing recovery for database 'LEON' because it is marked IN LOAD.
2004-11-22 16:34:35.79 backup Database restored: Database: LEON, creation date(time): 2002/06/19(11:22:15), first LSN: 2064:5792:1, last LSN: 2064:5799:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\DB\LEON_db_200411220115.BAK'}).
2004-11-22 16:45:48.86 server SQL Server terminating because of system shutdown.
My full backup is successful but my differential backup and transaction logs got an error messages.
Yep, NORECOVERY...
How to do the restore database recovery option???
November 23, 2004 at 12:35 pm
just a small db...where is the box???
restore complete with errors...
November 23, 2004 at 12:36 pm
restore database LEON with recovery
November 23, 2004 at 3:18 pm
It looks to me like everything went well except that you didn't use the 'WITH RECOVERY' clause on your last restore. As Allen said, all that is required at this point is
RESTORE DATABASE LEON WITH RECOVERY
In the future, you would do everything just as you did in this case, except when you restore the last backup file, whether its a log backup, differential, or just one full, instead of NORECOVERY, say RECOVERY.
Steve
November 23, 2004 at 3:29 pm
Got it! Thanks guys!!!
March 8, 2007 at 5:31 am
Bypassing recovery for database 'ACCOUNTS_MCX' because it is marked IN LOAD.
I am getting this message repetedly from my server log.And then giving message that it database starting up.
Will please tell me what to do..
Thanks
Shashi Kumar Singh
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply