Post reply

My Database goes read only mode

  • July 12, 2007 at 8:19 am

    #372772

    Hi Exports,

    My database goes read only mode in ms sql server 2000. I can change my database properties in Enterprise manger but it will showing this Error

    error 5070atabase state cannot be changed while

     other users are using the database 'dbname'

    alter databse statement failed.

    sp_dboption command failed.

    Any body help me how can i change my database comes into normal mode plz help me

     

     

     

  • July 12, 2007 at 3:44 pm

    #719116

    Did you ask other users to leave away from the database?

  • July 12, 2007 at 4:27 pm

    #719134

    This will do it.  You won't have to ask people to leave the DB, because it will kick them out.

    use master
alter database MyDatabase set read_write with rollback immediate

  • July 13, 2007 at 3:30 am

    #719223

    why man I am just new in sql server that's why i am asking to exports do u know tell other wise plz ignore my question

     

    Thanku For ur suggestion

    dont write this type messge next time

    bye

     

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

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