How to Rename SQL Server Database and the Database Filename (.mdf file)
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.