Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: Questionable SQL Server Log Messages



    I have two remote standby servers set up to apply the transaction log every 30 minutes. Each and every time the log is applied the following six messages appear in both of the remote servers. If I access the database with query analyzer the database seems to be up and running; and when I do that no messages are added to the error log. There does not seem to be any problem, but the database is always up and it seems like it is going to extra work for no reason. I was concern about the error logs filling up so I cycle them with sp_cycle_errorlog.

    But I would like to understand what these messages mean and why they are in the log.

    Message
    Starting up database '@@@@@@@@@@@'.
    Bypassing recovery for database '@@@@@@@@@@@' because it is marked IN LOAD.
    Starting up database '@@@@@@@@@@@'.
    Bypassing recovery for database '@@@@@@@@@@@' because it is marked IN LOAD.
    Recovery is checkpointing database '@@@@@@@@@@@' (10)
    Log restored: Database: @@@@@@@@@@@, creation date(time): 2004/06/16(00:52:45),


    Last edited by Dave3283; 09-30-04 at 09:19. Reason: Typos

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •