To rename physical file name entries for a SQL Server database, take it offline, change the catalog with MODIFY FILE, rename the files in Windows and bring the database online. This post builds a demo, shows the error a missing file causes, and gives a way to undo the change.
Rename Logical File Name of a SQL Server Database
To rename logical file name entries in SQL Server, use ALTER DATABASE with MODIFY FILE and NEWNAME. This post builds a demo database, renames both files and checks the result. It also covers names with dots and the two errors that stop a rename.
SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String – Number Table Method
I rewrote my User Defined Function to extract only numbers from a string. The new one uses a numbers table, also called a Tally table, instead of a WHILE loop.
SQL SERVER – Unable to Attach Database Files – The PageAudit Property is Incorrect – Ransomware Attack
After a ransomware attack, a client could not attach database files and saw: The PageAudit property is incorrect. Here is what the error means.
SQL SERVER – How to DROP or DELETE Suspect Database?
A client’s production database was stuck in suspect state and they could not even drop it. Here is how I helped them drop the suspect database.
SQL SERVER – FIX: CREATE FILE Encountered Operating System Error 5 (Access is Denied.)
After a disk migration on a cluster, SQL Server would not start: CREATE FILE encountered operating system error 5 (Access is denied.) on TempDB. I share the fix.
SQL SERVER – Upgrade Blocked: The Specified Edition Upgrade is Not Supported
Upgrading SQL Server 2008 R2 Express to SQL Server 2012 Evaluation failed with: Upgrade Blocked: The specified edition upgrade is not supported. Let me explain why.