Post reply

Not able to read standby server

  • May 17, 2006 at 1:07 pm

    #168941

    I took a backup and did the following

     

    restore database SusanB

    from disk = 'd:\fullbackuptest\SusanBFullbackup.bak'

    with standby = 'd:\fullbackuptest\undo\SusanBUndo.ldf'

     

    restore log susanb

    from disk = 'd:\fullbackuptest\SusanBTranbackup.bak'

    with standby = 'd:\fullbackuptest\undo\SusanBUndo.ldf'

    The DB's are saying they are in 'loading' mode, but aren't accessible via QA or EM.

    I was under the impression a standby database was also a readyonly database, is this correct?

     

  • May 17, 2006 at 2:55 pm

    #638562

    restore database attain

    from disk ='

    with standby='d:\undo.ldf'

     

    you have to have the undo for it to be read only

     

  • May 17, 2006 at 3:17 pm

    #638574

    I did have the undo files

     

    restore database SusanB

    from disk = 'd:\fullbackuptest\SusanBFullbackup.bak'

    with standby = 'd:\fullbackuptest\undo\SusanBUndo.ldf'

     

    restore log susanb

    from disk = 'd:\fullbackuptest\SusanBTranbackup.bak'

    with standby = 'd:\fullbackuptest\undo\SusanBUndo.ldf'

  • May 17, 2006 at 3:21 pm

    #638577

    When I try and connect to the db I get the following error -

     

    Error 927: Databaes 'dbname' cannot be opened. It is in the middle of a restore.

     

    Any suggestions?

  • May 18, 2006 at 5:43 pm

    #638898

    I was able to figure this one out..

    You need to make sure you have your model database set to readonly mode.

    Then all databases you restore automatically have that option enabled.

    Thanks for my help

    Susan

     

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

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