Files and File Groups in SQL Server
In today’s blog post I want to talk about a very important topic in SQL Server: how SQL Server handles Files and File Groups. When you create a simple database with a CREATE DATABASE command, SQL Server only creates 2 files for you: A Data File (.mdf) A Transaction Log File (.ldf) The data file …
