SQL Server 2005 | Database won’t go Offline

I needed to copy a database from SQL Server 2005. To copy it, you need to put the database offline but sometimes it takes too long to go offline and even fails.

The problem might be that the database would still have active connections. Thus to solve this problem you need to:

  • Right click on Database
  • Select Tasks
  • and click Detach

In the message part you’ll notice that there are a number of active connections. Click on the Active Connections link and a list of all connections is loaded.. right click each connection and click kill process. Make sure that tell the people of whom you’re killing their process to save everything else they might lose some work.

Now try again putting the database offline and it should work immediately.

Happy Database Copying 🙂

Ps. To take the database offline

  • Right Click on Database
  • Select Tasks
  • and Click Take Offline

Hello, nice to meet you

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Leave a Reply