October 31, 2015 at 9:10 am
I have a database data file almost at 2tb maxing out a windows drive. Only 16gb left. Should I just add another data file on another Windows drive for growth? Or just move current huge data file to a new GPT drive? Or do both adding another data file and moving existing to its own new GPT drive?
Primary objective is to make do for now.
I appreciate any suggestions.
Thank you,
Morrisos
October 31, 2015 at 9:34 am
I typically prefer keeping the drives under 2 TB (partially because I work a lot with virtual machines in VMware, and past 2 TB adding space to a drive requires a reboot).
Without knowing much more about the environment, my preference would be to disable autogrowth on the current file and add a file on a new drive.
That also has the advantage of not requiring any downtime to move the file.
Cheers!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply