Error on renaming database in SQL Server 2008 R2

Question

I am using this query to rename the database   ALTER DATABASE BOSEVIKRAM MODIFY NAME    BOSEVIKRAM Deleted    But it shows an error when excuting      Msg 5030  Level 16  State 2  Line 1   The database could not be exclusively locked to perform the operation    Is anything wrong with my query

User · Answer

1 database set 1st single user mode  ALTER DATABASE BOSEVIKRAM SET SINGLE USER WITH ROLLBACK IMMEDIATE  2 RENAME THE DATABASE   ALTER DATABASE BOSEVIKRAM MODIFY NAME    BOSEVIKRAM Deleted   3 DATABAE SET MULIUSER MODE  ALTER DATABASE BOSEVIKRAM Deleted SET MULTI USER WITH ROLLBACK IMMEDIATE

User · Answer

use master  ALTER DATABASE BOSEVIKRAM SET SINGLE USER WITH ROLLBACK IMMEDIATE    exec sp renamedb  BOSEVIKRAM   BOSEVIKRAM Deleted   ALTER DATABASE BOSEVIKRAM Deleted SET MULTI USER

User · Answer

This did it for me    USE  master   GO ALTER DATABASE  OldDataBaseName  SET SINGLE USER WITH ROLLBACK IMMEDIATE  GO EXEC sp renamedb N OldDataBaseName   N NewDataBaseName     -- Add users again ALTER DATABASE  NewDataBaseName  SET MULTI USER GO

User · Answer

That s because someone else is accessing the database  Put the database into single user mode then rename it   This link might help  http   msdn microsoft com en-IN library ms345378 v sql 105  aspx  and also  http   msdn microsoft com en-us library ms345378 aspx

User · Answer

You could try setting the database to single user mode   https   stackoverflow com a 11624 2408095  use master ALTER DATABASE BOSEVIKRAM SET SINGLE USER WITH ROLLBACK IMMEDIATE     ALTER DATABASE BOSEVIKRAM MODIFY NAME    BOSEVIKRAM Deleted  ALTER DATABASE BOSEVIKRAM Deleted SET MULTI USER

User · Answer

In SQL Server Management Studio  SSMS    You can also right click your database in the Object Explorer and go to Properties  From there  go to Options  Scroll all the way down and set Restrict Access to SINGLE USER  Change your database name  then go back in and set it back to MULTI USER

User · Answer

Try to close all connections to your database first   use master ALTER DATABASE BOSEVIKRAM SET SINGLE USER WITH ROLLBACK IMMEDIATE   ALTER DATABASE BOSEVIKRAM MODIFY NAME    BOSEVIKRAM Deleted   ALTER DATABASE BOSEVIKRAM Deleted SET MULTI USER   Taken from here

User · Answer

Set the database to single mode     ALTER DATABASE dbName SET SINGLE USER WITH ROLLBACK IMMEDIATE  Try to rename the database   ALTER DATABASE dbName MODIFY NAME   NewName  Set the database to Multiuser mode   ALTER DATABASE NewName SET MULTI USER WITH ROLLBACK IMMEDIATE

User · Answer

Another way to close all connections   Administrative Tools   View Local Services  Stop Start the  SQL Server  MSSQLSERVER   service

User · Answer

Change database to single user mode as shown in the other answers  Sometimes  even after converting to single user mode  the only connection allowed to the database may be in use   To  close a connection even after converting to single user mode try    select   from master sys sysprocesses where spid gt 50 -- don t want system sessions   and dbid   DB ID  BOSEVIKRAM     Look at the results and see the ID of the connection to the database in question   Then use the command below to close this connection  there should only be one since the database is now in single user mode      KILL connection ID   Replace connection id with the ID in the results of the 1st query

[sql] Error on renaming database in SQL Server 2008 R2

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008-r2