The Dangers When Changing Database File Names

  • Article

Recently a friend had an issue with their SQL Server as a result of a file change in their SQL Server database. In this short piece, I want to highlight the dangers of making some changes to an online database that might cause an unexpected outage. This is really the same whether you are changing […]

3.67 (3)


3,404 reads


Transaction log Information gathering


Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

What's New in SQL 2019? at BRSSUG


Thanks to everyone who joined the BRSSUG for a night all about SQL Server...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3


This is the third post in a series about modern Data Lake Architecture where...

Read the latest Blogs


Azure file copy creating a directory to hold the renamed file

By Irish-Toon

Hi All, I'm pretty new to azure and am hitting the following problem. I've...

MSAccess to SQLServer Query Conversion

By Whizkid

Hi, Our client have MS-Access database which has more queries written in MS-Access 2010...

Log file growth

By Admingod

Index maintenance and loading data conflict with each other cause the log file to...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers