February 28, 2008 at 4:56 am
Hi All,
My problem is that when i tried detach and attach, the database went to read only mode..Whats the reason behind this ????...can anyone please help me to solve this issue.
TIA
February 28, 2008 at 6:04 am
Hi,
plz visit this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98017
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51214
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1245854&SiteID=1
Best Regards
Faheem latif
Senior Database Architect
Genie Technologies (Pvt.) Ltd.
February 28, 2008 at 6:04 am
I have not seen this before. Have you tried refreshing the view?
Have you tried to detach once again ?
(Note : if you want to update statistics then change the Read only flag back to false first)
February 28, 2008 at 7:26 am
Hi Faheem
I went through the link but no solution for my problem.I did the detach and attach many times but no use..
February 28, 2008 at 8:18 am
Are you using script to do this or the GUI. Can you post the script if you are using 1. The database as such will not go in read-only mode unless its specified.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 8:28 am
Hi Sugesh,
Used the GUI ...first i detached the db and copied the mdf and ldf to another location and attached the DB it went to read only mode.I repeated the detach and attach for few more times and to different locations but the result was same.
February 28, 2008 at 8:33 am
A couple things.
First, can you switch it out of Read only mode?
Second, be sure that the files themselves (MDF/LDF) in the filesystem aren't read only.
February 28, 2008 at 8:37 am
I would go with the way Steve said.
Lucky
February 28, 2008 at 8:39 am
Second that.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply