SQL Server - Database in Use When Dropping a Database in SQL Server

Database in Use When Dropping a Database in SQL Server

Q

Why I am getting this error when dropping a database in SQL Server?

✍: FYIcenter.com

A

If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "FyiCenterData" because it is currently in use.'

Before dropping a database, you must stop all client sessions using this database. If your own client session is using this database, you should set a different database as the current database as shown in this tutorial example:

CREATE DATABASE FyiCenterData
GO

USE FyiCenterData
GO

DROP DATABASE FyiCenterData
GO
Msg 3702, Level 16, State 4, Server LOCALHOST\SQLEXPRESS
Cannot drop database "FyiCenterData" because it is 
   currently in use.

USE master
GO

DROP DATABASE FyiCenterData
GO

⇒Managing Databases and Physical Files in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-24, 665👍, 0💬

Location of Database Files in SQL Server
Where is my database stored on the hard disk in SQL Server? If a database is created with simple CREATE DATABASE statement, the server will create two database files on the hard disk to store data and configuration information about that data bases: database_name.mdf - SQL Server Database Primary Da... 2016-11-24, 716👍, 0💬

"DROP DATABASE" - Deleting Databases in SQL Server
How to delete a database in SQL Server? If you created a database incorrectly, or you have a database that is not needed any more, you can delete it with the "DROP DATABASE" statement with this syntax: DROP DATABASE database_name For example, execute this statement: DROP DATABASE FyiCenterData GO Th... 2016-11-24, 687👍, 0💬

Database in Use When Dropping a Database in SQL Server
Why I am getting this error when dropping a database in SQL Server? If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "FyiCenterData" because it is currently in use.' Before dropping a database, you must stop all client sessions using... 2016-11-24, 666👍, 0💬

Getting a List of All Databases on the Server in SQL Server
How to get a list all databases on the SQL server in SQL Server? If you don't remember database names you have created, you can get a list of all databases on the server by query the "sys.databases" view as shown in this tutorial example: CREATE DATABASE FyiCenterData GO SELECT name, database_id, cr... 2016-11-24, 635👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.