I would share my knowledge and findings of a situation where there was a mismatch between sys.database_files and sys.master_files for the TempDB database!
we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about PRINT Statement and DataType.
Question: How to Move SQL Server MDF and LDF Files?
During the recent Comprehensive Database Performance Health Check, I was asked is there any way we can rename the logical database file name. I have blogged about it here: SQL SERVER – Rename Logical Database File Name for Any Database. Right after the blog post, I received another question where the user wanted to know if there is an easy way to rename the physical file. In this blog post, we will learn about how to rename the physical database files name.
During recent we Comprehensive Database Performance Health Check, we had to restore a database on a server. When we restored a database, we realized that the logical file name of the database was incorrect and we had to change that to something more consistent with the organization’s naming convention. Let us see how we changed logical database file name in a few quick steps.