My current Epicor Database is 475 gb. I have a nightly backup dropped into another drive on my SQL Server and is about to max out. Short of purchasing another HDD (which is not really an option), does anyone know how to shrink my .mdf file so that my nightly backup file won’t be so large? I have shrunk the .ldf file, but that only freed up a couple of gigs.
You can “compress” your backup… (are you already doing that?)
Also check which tables are the largest, maybe its a loggin table and you can “Truncate it” GASP
you can run a standard report.
Right click on the database
Navigate to Reports > Standard Reports > Disk Usage By Table
I think i will try that. I am also going to purge my change log. Looks like the chglog is the largest table on that database. Makes a lot of sense now how quickly my database grows.
First let me say Shrinking your .mdf file is not the best move. You don’t mess with your data. Besides, even if you could shrink the .mdf file you wouldn’t get much.Also, if you do shrink the .mdf (Bad idea) your log file would grow. So no savings in drive space.
The best move here is to look for other files and data you have on the server to get rid of. Look at what you have on the drives like Windows Update Log files. Look at things like that.
Jonathan Lang