Not able to read standby server

Question

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

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

danschl SSCertifiable Points: 5770 More actions · Answer 1

restore database attain

from disk ='

with standby='d:\undo.ldf'

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

sbauer SSCommitted Points: 1966 More actions · Answer 2

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'

sbauer SSCommitted Points: 1966 More actions · Answer 3

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?

sbauer SSCommitted Points: 1966 More actions · Answer 4

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