I need to clean up a database. Main reason: datafiles have grossly disparate sizes. I'd like to export entire database (or some other meaningful method), resize and add datafiles of same size, re-import the data. What is the best way to accomplish this?
Further explanation of problem: When this database was originally created, there was one datafile. Over time, it grew quite large. Upon a subsequent upgrade,other datafiles were added, much smaller than the original datafile. As a result, considering the way MSSQL uses an algorithm to write data to datafiles, the data is not being distributed to the various datafiles in an equitable way. Hence, one datafile is very big and VERY hot. I'd like to redistribute the data to the various datafiles, and resize them equally so that the MSSQL algorithm would then evenly distribute data to ALL the datafiles.
Thanks for any help you can offer.