SQL SERVER – Rename Physical Database File Name for Any Database

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.

Read More

SQL SERVER – Rename Logical Database File Name for Any Database

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.

Read More

SQL SERVER – ERROR: Failed to verify the Authenticode signature of FileName

Sometimes there is some malware which would do changes on the machine which is impossible to track. Most of the time, based on my interactions with various clients, we need to format and rebuild the OS because you never know what data is getting compromised using which program running in the background. In this blog, we would learn about an interesting error Failed to verify the Authenticode signature of the filename.

Read More
Menu