Post reply

Shutdown SQL Database

  • April 7, 2006 at 12:57 am

    #168444

    How do you shutdown a SQL Database ? Is it the same as taking the database "offline"? By shutting down the database does it release the memory used or does the server require a re-boot? Thanks

  • April 7, 2006 at 8:46 am

    #631523

    Prakash,

    This forum "Question of the Day" is only for comments about the Question of the Day. You need to post your questions in an appropriate forum area.

    But to answer your question..

    there are different ways to shutdown a database. The main way is to detach it (sp_detach_db). You can also stop the SQL Server services, but that will shutdown ALL the databases. When you detach a database or stop the services, the database(s) is/are offline.

    -SQLBill

  • April 7, 2006 at 8:50 am

    #631524

    Post moved.

    Prakesh, what are you trying to do? You can "close" the database with autoclose and resources will be released, but if someone accesses the database, it will reopen. This can be slow and cause delays or timeouts in an application, so it's not recommended.

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

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