Post reply

msdb is in bypass mode

  • October 30, 2002 at 5:10 pm

    #65072

    Somehow I screwed up my database. MSDB is in read-only \ offline \ emergency mode. When I start the server, the log tells me that: "Bypassing recovery for database 'msdb' because it is marked BYPASS." There is also an alert message that says the msdb log is full. I have no clue what to do. I am a novice at administration. Any assistance is appreciated.

  • October 30, 2002 at 7:40 pm

    #439870

    use msdb

    go

    sp_helpfile -- find out the log size

    go

    use master

    go

    sp_configure 'allow update',1

    go

    reconfigure with override

    go

    alter database msdb

    modify file

    (name = msdblog,

    size = 50mb) -- change this number large than the original log size from sp_helfile

    go

    update sysdatabases set status=0 where name='msdb'

    go

  • October 30, 2002 at 7:49 pm

    #439871

    thanks! worked like a charm.

  • October 31, 2002 at 2:11 am

    #439884

    Hi, for safety, if you use sp_configure 'allow update',1

    go

    and you are finished updating system tables you must

    run

    sp_configure 'allow update',0

    go

    so that updating system tables is not possible.

  • October 31, 2002 at 4:52 am

    #439911

    i'll add it to my notes.

    thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply