Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Database in Use When Renaming a Database

By: FYIcenter.com

(Continued from previous topic...)

Why I am getting this error when renaming a database?

If you are trying to rename a database that is in use, you will get an error message like this: "The database could not be exclusively locked to perform the operation."

Before renaming a database, you must stop all client sessions using this database. Otherwise, you will get an error as shown in this tutorial example:

1. Launch one instance of SQL Server Management Studio and run:

USE FyiCenterComData
GO

2. Keep the first instance running and launch another instance of SQL Server Management Studio:

ALTER DATABASE FyiCenterComData 
   MODIFY NAME = FyiCenterData
GO
Msg 5030, Level 16, State 2, Server LOCALHOST\SQLEXPRESS
The database could not be exclusively locked to perform 
   the operation.

Obviously, the first instance is blocking the "ALTER DATABASE" statement.

(Continued on next topic...)

  1. What is a database?
  2. What is the simplest way to create a new database?
  3. How to set the current database?
  4. How to delete a database?
  5. Why I am getting this error when dropping a database?
  6. How to get a list all databases on the SQL server?
  7. Where is my database stored on the hard disk?
  8. How to create database with physical files specified?
  9. How to rename databases?
  10. Why I am getting this error when renaming a database?
  11. What are database states?
  12. How to set a database state to OFFLINE?
  13. How to move database physical files?
  14. How to set database to be READ_ONLY?
  15. How to set database to be SINGLE_USER?
  16. What are system databases?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...