Renaming a SQL Server database - Revision history

Ivan.belenski at 13:33, 17 January 2018

2018-01-17T13:33:04Z

Ivan.belenski at 13:30, 17 January 2018

2018-01-17T13:30:32Z

Ivan.belenski: Created page with "The following T-SQL script will rename a database: use master go alter database [original] modify name = [renamed] go If someone's using the database, you'll get a m..."

2018-01-17T13:29:48Z

Created page with "The following T-SQL script will rename a database: use master go alter database [original] modify name = [renamed] go If someone's using the database, you'll get a m..."

New page

The following T-SQL script will rename a database:

use master
go

alter database [original]
modify name = [renamed]
go

If someone's using the database, you'll get a message like this:

Msg 5030, Level 16, State 2, Line 4
The database could not be exclusively locked to perform the operation.

If the operation is successful, you'll get something like this:

The database name 'renamed' has been set.

← Older revision		Revision as of 13:30, 17 January 2018
Line 16:		Line 16:

	The database name 'renamed' has been set.		The database name 'renamed' has been set.
		+
		+	It's a good idea to back up the master database after renaming databases.

@@ Line 1: / Line 1: @@
 The following T-SQL script will rename a database:
- use master
+<pre>
- go
+use master
 go
- alter database [original]
- modify name = [renamed]
+alter database [original]
- go
+modify name = [renamed]
 If someone's using the database, you'll get a message like this:
- Msg 5030, Level 16, State 2, Line 4
+<pre style="color: red;">
- The database could not be exclusively locked to perform the operation.
+Msg 5030, Level 16, State 2, Line 4
 If the operation is successful, you'll get something like this:
- The database name 'renamed' has been set.
+<pre>
 It's a good idea to back up the master database after renaming databases.