blocks|key|190583|text|您可以尝试将数据库设置为单用户模式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190584|https://stackoverflow.com/a/11624/2408095|offset|length|190585|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|code-block|syntax|javascript|190586|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|15|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|H|7|W|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|C]]]]

You could try setting the database to single user mode.

<a href="https://stackoverflow.com/a/11624/2408095">https://stackoverflow.com/a/11624/2408095</a>

<pre><code>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
</code></pre>

blocks|key|3019380|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3019381|将数据库设置为单模式:ALTER+database+dbName+SET+SINGLE_USER+WITH+ROLLBACK+IMMEDIATE|ordered-list-item|3019382|尝试重命名数据库：|3019383|3019384|ALTER+DATABASE+dbName+MODIFY+NAME+=NewName|3019385|将数据库设置为多用户模式：|unordered-list-item|3019386|3019387|ALTER+DATABASE+NewName+SET+MULTI_USER+WITH+ROLLBACK+IMMEDIATE|3019388|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|Q|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|R|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|S|7|@]|8|@]|9|$]]|$1|F|3|-4|4|5|6|T|7|@]|8|@]|9|$]]|$1|G|3|H|4|5|6|U|7|@]|8|@]|9|$]]|$1|I|3|J|4|K|6|V|7|@]|8|@]|9|$]]|$1|L|3|-4|4|5|6|W|7|@]|8|@]|9|$]]|$1|M|3|N|4|5|6|X|7|@]|8|@]|9|$]]|$1|O|3|-4|4|5|6|Y|7|@]|8|@]|9|$]]]|P|$]]

<ol>
<li>Set the database to single mode: 

<pre><code>ALTER DATABASE dbName
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
</code></pre></li>
<li>Try to rename the database:

<pre><code>ALTER DATABASE dbName MODIFY NAME = NewName
</code></pre></li>
<li>Set the database to Multiuser mode:

<pre><code>ALTER DATABASE NewName
SET MULTI_USER WITH ROLLBACK IMMEDIATE
</code></pre></li>
</ol>

blocks|key|2807270|text|在SQL+Server+Management+Studio+(SSMS)中|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2807271|也可以在对象资源管理器中右键单击数据库，然后转到“属性”。从那里，转到Options。向下滚动并设置对SINGLE_USER的限制访问。更改数据库名称，然后返回并将其重新设置为MULTI_USER。|2807272|entityMap^0|1|Z|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

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.

blocks|key|188252|text|请先尝试关闭与数据库的所有连接：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|188253|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|code-block|syntax|javascript|188254|摘自here|offset|length|188255|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/11620/how-do-you-kill-all-current-connections-to-a-sql-server-2005-database^0|0|0|2|4|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Try to close all connections to your database first:

<pre><code>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
</code></pre>

Taken from <a href="https://stackoverflow.com/questions/11620/how-do-you-kill-all-current-connections-to-a-sql-server-2005-database">here</a>

blocks|key|3019402|text|这为我做到了：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3019403|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|code-block|syntax|javascript|3019404|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This did it for me: 

<pre><code>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
</code></pre>

blocks|key|187762|text|这是因为其他人正在访问数据库。将数据库置于单用户模式，然后将其重命名。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|187763|此链接可能会有所帮助：|187764|http://msdn.microsoft.com/en-IN/library/ms345378(v=sql.105).aspx|offset|length|187765|还有：|187766|http://msdn.microsoft.com/en-us/library/ms345378.aspx|187767|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|0|1S|0|0|0|0|1H|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$F|W|G|X|1|Y]]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@$F|11|G|12|1|13]]|A|$]]|$1|L|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|E]]|S|$5|O|P|Q|A|$R|K]]]]

That's because someone else is accessing the database. Put the database into single user mode then rename it.

This link might help: 
<a href="http://msdn.microsoft.com/en-IN/library/ms345378(v=sql.105).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-IN/library/ms345378(v=sql.105).aspx</a>

and also: 
<a href="http://msdn.microsoft.com/en-us/library/ms345378.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms345378.aspx</a>

blocks|key|3019543|text|1.数据库设置为第一个单用户模式|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3019544|ALTER+DATABASE+BOSEVIKRAM+SET+SINGLE_USER+WITH+ROLLBACK+IMMEDIATE|offset|length|style|BOLD|3019545|2.对数据库进行命名|3019546|ALTER+DATABASE+BOSEVIKRAM+MODIFY+NAME+=+BOSEVIKRAM_Deleted|3019547|3.+3.DATABAE设置MULIUSER模式|3019548|ALTER+DATABASE+BOSEVIKRAM_Deleted+使用ROLLBACK+IMMEDIATE设置MULTI_USER|3019549|entityMap^0|0|0|E|Q|13|0|0|0|E|Q|D|0|0|0|E|Y|K|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]|$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@$D|Z|E|10|F|G]|$D|11|E|12|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|14|8|@$D|15|E|16|F|G]|$D|17|E|18|F|G]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|Q|$]]

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

blocks|key|188295|text|将数据库更改为单用户模式，如其他答案所示|type|unstyled|depth|inlineStyleRanges|entityRanges|data|188296|有时，即使在转换为单用户模式后，唯一允许的数据库连接可能仍在使用中。|188297|要在转换为单用户模式后关闭连接，请尝试：|188298|select+*+from+master.sys.sysprocesses
where+spid>50+--+don't+want+system+sessions
++and+dbid+=+DB_ID('BOSEVIKRAM')|code-block|syntax|javascript|188299|查看结果并查看与相关数据库的连接ID。|188300|然后使用下面的命令关闭这个连接(应该只有一个连接，因为数据库现在处于单用户模式)|188301|188302|杀死connection_ID|blockquote|188303|188304|188305|将connection_id替换为第一个查询结果中的ID|188306|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|15|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|18|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|X|$]]

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: 

<pre><code>select * from master.sys.sysprocesses
where spid&gt;50 -- don't want system sessions
 and dbid = DB_ID('BOSEVIKRAM')
</code></pre>

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)

<blockquote>
 KILL connection_ID
</blockquote>

Replace connection_id with the ID in the results of the 1st query

blocks|key|186321|text|另一种关闭所有连接的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|186322|管理工具>查看本地服务|186323|停止/启动"SQL+Server+(MSSQLSERVER)“服务|186324|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Another way to close all connections:

Administrative Tools > View Local Services

Stop/Start the "SQL Server (MSSQLSERVER)" service

blocks|key|2807342|text|对我来说，不能重命名数据库的原因是因为有活动的连接。我只是首先让数据库离线，勾选Drop+All+Active+Connections。然后让它再次联机，我就可以重命名数据库了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2807343|📷|atomic|offset|length|2807344|​|2807345|2807346|2807347|2807348|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/28ab57f33ccea2d3650a3c987563993f.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/0edf572c7f142d15debbc796e65bff02.png^0|0|0|1|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@$E|Y|F|Z|1|10]]|A|$]]|$1|G|3|H|5|6|7|11|8|@]|9|@]|A|$]]|$1|I|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|C|5|D|7|13|8|@]|9|@$E|14|F|15|1|16]]|A|$]]|$1|K|3|H|5|6|7|17|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]|U|$5|O|P|Q|A|$R|V|T|-4]]]]

For me the reason why I could not rename a database is because there are active connections.
I just take the database offline first, ticking the Drop All Active Connections.
Then bring it online again and I can rename the database already.
<a href="https://i.stack.imgur.com/q2zwk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/q2zwk.png" alt="Take Offline" /></a>
<a href="https://i.stack.imgur.com/aeroC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aeroC.png" alt="enter image description here" /></a>

blocks|key|3019514|text|use+master

ALTER+DATABASE+BOSEVIKRAM+SET+SINGLE_USER+WITH+ROLLBACK+IMMEDIATE++

exec+sp_renamedb+'BOSEVIKRAM','BOSEVIKRAM_Deleted'

ALTER+DATABASE+BOSEVIKRAM_Deleted+SET+MULTI_USER|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3019515|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>use master

ALTER DATABASE BOSEVIKRAM SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

exec sp_renamedb 'BOSEVIKRAM','BOSEVIKRAM_Deleted'

ALTER DATABASE BOSEVIKRAM_Deleted SET MULTI_USER
</code></pre>

I am using this query to rename the database:

<pre><code>ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted]
</code></pre>

But it shows an error when excuting:

<blockquote>
 Msg 5030, Level 16, State 2, Line 1 
 The database could not be exclusively locked to perform the operation.
</blockquote>

Is anything wrong with my query?

Error on renaming database in SQL Server 2008 R2

我使用这个查询来重命名数据库：ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted]但它在执行时显示一个错误：消息5030，级别16，状态2，第1行无法以独占方式锁定数据库以执行该操作。我的查询有什么问题吗？

问在SQL Server2008 R2中重命名数据库时出错
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQL Server2008 R2中重命名数据库时出错EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQL Server2008 R2中重命名数据库时出错
EN