MySQL – Move Data Files To New Location (Windows) benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 2016-03-19 This script gets the size of each database file, not including backups. Essentially, you’ll see… Continue Reading