Super D to the B to the A – AKA Script for reducing the size of a database
Posted by: Fervent Coder,
on 14 Dec 2012 |
View original | Bookmarked: 0 time(s)
The following is a script that I used to help me clean up a database and reduce the size of it from 95MB down to 3MB so we could use it for a development backup. I will note that we also removed some of the data out. I shared this with a friend recently and he used this to go from 70GB to 7GB! So what does it do? It gives you a report of what tables are taking up the most space. It allows you to specify those tables for cleaning. Gives you that same report of space used up by tables...