Not very sure but I think you have to right click the
database in Enterprise Manager, go to properties and
check the "Read Only" check box.




--- Gary Fahrlander <gary.[Email Address Removed] I'm trying to do log shipping. The BOL states the
> Db needs to be in
> standby mode but doesn't tell me how to put the Db
> in standby mode. Can
> anybody clue this SS2K novice in?
>
>
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
MS Sql Server LazyDBA home page