Home » Reply » Reply To: How to rename SQL Server database?

Reply To: How to rename SQL Server database?

Andrew Jackson ~ Modified: January 11th, 2016 ~ ~ 1 Minute Reading

Home › Forums › How to rename SQL Server database? › Reply To: How to rename SQL Server database?

January 11, 2016 at 12:42 pm #1032 Score: 0
Andrew Jackson
Moderator
1 pt

To change the name of the physical file you have to take the SQL Server database Offline

  • Open SQL Server Management Studio
  • Right-click on Database which you want to rename
  • Click on Tasks
  • Then select Take Offline

Change the name of the physical files at the OS level and then Bring the database Online.