Can a primary data file end in something other than .mdf? I built a demo database with odd names, checked each file, then detached and attached it.
SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run
After a backup restore mistake, SQL Server would not start and ERRORLOG said the database ‘model’ is marked RESTORING. This is how I got it running again.
Default Filegroup: Sending New Tables Away From PRIMARY
Changing the default filegroup only affects tables you create later. Here is what moves, what does not, and how a script can quietly ignore the rule.
Capping File Growth So One Query Cannot Fill a Whole Disk
One runaway load can fill a shared drive and take every database down with it. A MAXSIZE cap moves the failure to one database.
Metadata-Only Column Changes: Which ALTER COLUMN Is Instant
Six ALTER statements look equally small, but their log cost is not. Here is how to measure each one before the change window.
Vertical Partitioning: Moving Rarely Used Columns Off a Hot Table
Moving rarely used columns to a side table can cut reads, or change nothing. Here is how to measure it and what it costs your writes.
Moving a Table to Another Filegroup by Rebuilding Its Clustered Index
One statement moves the rows, but large-object data and other indexes stay behind. A small demo shows exactly where everything ends up.