question

rcamarda390 avatar image
rcamarda390 asked

Alternative of migration to fix DB file structure

I have inherited SQL servers with DB's large (> 200GB) single file. I want to have DB's with multiple files and follow best practices of DB structure. Other than migration from old DB to new DB, is there a way/tool to address fixing the underlying file structure? Situation: I like to have a 'small' primary file, a DATA file group (with # of files approx # of cpus'), an INDEX file group. I have some DB's with just PRIMARY file group that is 100's of GB's with only one data file and a 1TB log file that is a couple of files.
migrationbest-practicefilegroupsingle-file
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.