MS SQL Server Concepts and Programming Question: Download Questions PDF
Why I am getting this error when renaming a database in MS SQL Server?
Answer:
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 GlobalGuideLine
GO
2. Keep the first instance running and launch another instance of SQL Server Management Studio:
ALTER DATABASE GlobalGuideLine
MODIFY NAME = GlobalGuideLineDatabase
GO
Msg 5030, Level 16, State 2, Server LOCALHOSTSQLEXPRESS
The database could not be exclusively locked to perform
the operation.
Obviously, the first instance is blocking the "ALTER DATABASE" statement.
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 GlobalGuideLine
GO
2. Keep the first instance running and launch another instance of SQL Server Management Studio:
ALTER DATABASE GlobalGuideLine
MODIFY NAME = GlobalGuideLineDatabase
GO
Msg 5030, Level 16, State 2, Server LOCALHOSTSQLEXPRESS
The database could not be exclusively locked to perform
the operation.
Obviously, the first instance is blocking the "ALTER DATABASE" statement.
Download MS SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to rename databases in MS SQL Server? | What are database states in MS SQL Server? |