Question: Can a Database Have Multiple Files with Extension MDF?
Answer: Yes. It is possible to have multiple files with extension MDF.
sp_helpdb in SQL Server: List Databases and Their Files
sp_helpdb in SQL Server lists every database on an instance, or the files of one database, with a single call. This post builds three small databases, reads the output column by column and explains why db_size is text. It also shows how to filter the result and how to find free space.
Remove Extra Log File in SQL Server: Fix Error 5042
To remove extra log file members, SQL Server needs the files to hold no active log. When one does, ALTER DATABASE REMOVE FILE fails with Msg 5042. This post builds a database with two log files, reproduces the error, shows which VLFs keep the file busy and frees it with log backups. It also explains why the file stays offline until the next log backup.
How to Solve Error When Transaction Log Gets Full? – Interview Question of the Week #272
Question: How to Solve Error When Transaction Log Gets Full?
Answer: This was a question I was asked in the recent Health Check.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
Msg 1842: File Size Cannot Exceed 2147483647 Pages
Msg 1842 appeared when a client’s data file reached the 16 TB limit, 2147483647 pages of 8 KB. Their SQL Agent job kept failing with a full filegroup message. The fix is to add another data file, or to free space or add a log file for the log.
Estimating vector Column Storage Before Loading Embeddings
Estimate vector column storage from dimensions, measure DATALENGTH and table allocation, and separate payload bytes from page overhead.