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