Prev: Working Now...
Next: DBCC SHRINKDATABASE: Page could not be moved because it is a work table page.
From: FARRUKH on 13 Sep 2006 15:08
I am getting these errors in my SQL Error log. I read through some articles
about changing a registry setting but I don't know what the repurcussions of
doing that would be. Can you please let me know what I need to do to stop
these errors? Thank You!

Starting up database 'model4IDR'.
Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
Starting up database 'model4IDR'.
Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
Recovery is checkpointing database 'model4IDR' (23)
Starting up database 'model4IDR'.
Database restored: Database: model4IDR, creation date(time):
Database backed up: Database: model, creation date(time):
Database backed up: Database: master, creation date(time):
Starting up database 'master4IDR'.
Bypassing recovery for database 'master4IDR' because it is marked IN LOAD.
Starting up database 'master4IDR'.
Bypassing recovery for database 'master4IDR' because it is marked IN LOAD.
Recovery is checkpointing database 'master4IDR' (23)
Starting up database 'master4IDR'.

Farrukh

From: Tracy McKibben on 13 Sep 2006 15:19
FARRUKH wrote:
> I am getting these errors in my SQL Error log. I read through some articles
> about changing a registry setting but I don't know what the repurcussions of
> doing that would be. Can you please let me know what I need to do to stop
> these errors? Thank You!
>
> Starting up database 'model4IDR'.
> Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
> Starting up database 'model4IDR'.
> Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
> Recovery is checkpointing database 'model4IDR' (23)
> Starting up database 'model4IDR'.
> Database restored: Database: model4IDR, creation date(time):
> Database backed up: Database: model, creation date(time):
> Database backed up: Database: master, creation date(time):
> Starting up database 'master4IDR'.
> Bypassing recovery for database 'master4IDR' because it is marked IN LOAD.
> Starting up database 'master4IDR'.
> Bypassing recovery for database 'master4IDR' because it is marked IN LOAD.
> Recovery is checkpointing database 'master4IDR' (23)
> Starting up database 'master4IDR'.
>
> Farrukh
>

These are not errors, they are simply informational messages telling you
that the 'master4IDR' database is not going to be brought "online"
because it was restored with the NORECOVERY option. This "recovery"
process is where SQL rolls back/forward transactions from the
transaction log.


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
 | 
Pages: 1
Prev: Working Now...
Next: DBCC SHRINKDATABASE: Page could not be moved because it is a work table page.