June 11, 2009 at 7:53 am
How do i change the database from read only mode to User accessible mode
I have done log shipping and selected that the secondary data base should be
read only
now i want the database should be accessible for the normal operations
can some one heplp me out 🙂
June 11, 2009 at 7:59 am
SQL 2005:
right click Database--> properties--options-->Scroll down to State container...
there are options.. select multi_user... and you are done.
SQL 2000:
right click Database--> properties--options--> under Access -- uncheck Restrict Acess and read only... and you are done.
TSQL:
alter database set multi_user
exec sp_dboption '', single_user, 'false'
Maninder
www.dbanation.com
June 11, 2009 at 9:24 am
I would use the T-SQL script that Mani provided. Get used to using scripts, and you could easily set this to run at the end of other maintenance operations that you have scheduled or prepared.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply