How to Rename SQL Server Database and the Database Filename (.mdf file)

Submitted by admin on

In this tutorial I will teach you on how to rename an SQL Server Database and its filename.

For this purpose, we will use "LibSys" database on my SQL Server Management tools and rename it to "LibrarySystem". Remember that we have to rename the following:

  • Filename
  • Logical name
  • Database name

As opposed to other tutorial, they only rename either Logical name or Filename of the database. In the case of this tutorial, we will rename all of them.

To Snag is to Snagit

Submitted by handywoman on
Been using this for so long now. As to when exactly, I don’t even remember. Glad I have found it. It made my job easier ever since. Been recommending it to several friends already and all I have are positive remarks. I could see that they are still using it.
Subscribe to