Post reply

Database offline

  • December 14, 2011 at 8:09 am

    #248119

    Unable to bring database to offline state. Query and ssms is running continously and ultimately canceling the command. pls help.

  • December 14, 2011 at 8:10 am

    #1421336

    Is there an error message? Are there active connections to the db?

    _____________________________________________________________________
    Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain

  • December 14, 2011 at 8:12 am

    #1421338

    Your database might be in use while u bringing the database to offline. try to kill the spid which are using the db. or you can use below command to bring the db in offline.

    Alter database dbname set offline with rollback immediate.

    java[/url]

  • December 14, 2011 at 8:15 am

    #1421343

    You can find which spids are using the DB by below query

    Select * from sys.sysprocesses where dbid =db_id('DBaname')

    java[/url]

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

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