Post reply

Database offline

  • February 29, 2012 at 9:53 am

    #251625

    Hi , I am unable to bring Database to online its saying database is in used using below command

    Alter database dbname set offline

    please advice.

  • February 29, 2012 at 9:55 am

    #1453266

    You can not bring the database when there is a session on database. find out the spid who is using the database then kill that spid.

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

    java

  • February 29, 2012 at 9:57 am

    #1453268

    Thanks for your prompt response.

  • February 29, 2012 at 9:58 am

    #1453270

    Welcome:-)

    java

  • February 29, 2012 at 12:01 pm

    #1453327

    Satya_0000 (2/29/2012)

    Hi , I am unable to bring Database to online its saying database is in used using below command

    Alter database dbname set offline

    please advice.

    You also do this by below query

    Alter database dbname set offline with rollback immediate

    java programming

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

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