After setting up MySQL, I realized that I put my data files on the C…
Tag: database files
Moving Database Files to Another Location
Although moving database files around is simple, it is a still big deal. When you…
Database File Space and Free Space
/* Author: Ben Farnsworth Date: 1/7/14 Get info on Data files */ IF OBJECT_ID(‘tempdb..#space’) IS…
Shrinking Database Files With Excess Free Space
This script is intended for environments where space constraints require the space to be closely…
SQL Server – Get Size of Database Files
This script gets the size of each database file, not including backups. Essentially, you’ll see…