August 21, 2002 at 3:37 pm
Hello everyone, I found this entry in my logs, has anyone seen this? Any idea why this happens?
"Bypassing recovery for database 'ALTADATA' because it is marked IN LOAD."
August 21, 2002 at 4:26 pm
A database is in LOAD status when you are in the middle of restoring it. Typically this occurs when you are restoring from multiple backups (full, differential, and transaction logs). When you are restoring from multiple backups you have to tell SQL to not recover at the end of each restore operation (each database backup) until the last restore operation is reached (last backup to be used in restore). When you are restoring the last backup you tell SQL server to recovery, at this point your database will remove the "in load" status. So basically when you in the middle of a database restore process the database will be marked "IN LOAD" status. If for some reason you don't complete your restore process you database will stay "IN LOAD" status. If you leave your database in this "IN LOAD" state and stop and restart SQL Server, then SQL Server will bypass the recovery of this database, since SQL Server thinks this database is still being restored.
Hope this help.....
Hope this helps.....
-------------------------
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply