This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hello,
We have Sql Server 2008R2 and one of the database is more then 2 TB and we can't add any more space on current disk drive so adding new disk drive on the server what will be the best option to move files to new location?
Is it better to move all the files to new drive?
Is it just add another new data files to new disk drive will be better so new data will load directly into new drive location?
Detach/attach?
Backup/Restore?
I am just trying find the best way to avoid or minimize down time as we are at the stage that current disk drive is almost full and can't expand the space but adding another disk drive will make which way better solution?
Currently, We have data file structure like data1.mdf, data2.ndf, data3.ndf, data4.ndf and log file is log1.ldf - all are in PRIMARY GROUP.
Any better solution/suggestion appreciated.
Thanks for your help!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @pdsqsql ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Seeya,
thank you for your help and tips.
I will update once I try the solution to make sure it's really worked or not so others can also use this tips.
Hi @pdsqsql ,
In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
Thanks Erland.
Confused, What you suggest then from following size which needs to be changed?
SIZE = 1024MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 1024MB
Use comments and Answers for follwoup questions. I think I said that I did see the point with an initial size of 1 GB. Isn't that clear enough?
Thanks Erland.
Got your point. Confused with
I will set up initial size 50 GB,
I think I read "Not sure that I see the point with starting with 1GB in size for the new files. Why 50 or 100 GB?" but you are trying to say Why not starting initial size 50 GB or 100 GB.
Appreciate your help and tips!
Thanks Everyone, It was very useful solution.