BE 2012 - Rebuild index database
I wanna know if there is a script that can create from scratch all the index present on the database, because my DB has reached 4GB on Sql express 2008 and i can't afford a sql licence for this.
What i can see is that the indexes are huge like 600Mb on Belog table as so the data like 2GB. I need 3665 days of log, that also could be an issue.
So my idea is to delete the indexes, defrag the tables, shrink DB and recreate the indexes again.
At the moment even the BE 2012 schedule database routine gives errors with so much data on it.