Rename Database Using SQL Server Management Studio in SQL Server 2008

In this article I describe how to change database name using SQL Server Management Studio.
  • 2400

Introduction

In this article I describe how to change database name using SQL Server Management Studio. There are various approaches to change SQL Server database name. Sometimes condition arises when you need to rename your database like refreshing the development server with current data or while restoring database and at that time you just give a temporary name but after that you need to rename it on your system.

Change database name using SQL Server Management Studio

Step 1

Open SQL Server Management Studio and connect to database engine.

Step 2

In object explorer step down to the Databases node. Select database name whose name you want to change.

change database name1.jpg

Step 3

Right-click a Database name and choose Rename from popup menu.

change database name in sql1.jpg

Step 4

Enter new database name and click OK.

rename database in sql.jpg


Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.