To change the server for the databases for performance

I have about 3 databases on a server with the following dbf sizes as below

firstdb size= 98mb
seconddb size=448mb
thirddb size=17gb

I multiplied all these by 3 times and I got the results as 294mb , 1344mb and 50gb , Now I want to know how much disk space is needed to get all this databases on to a new server and multiplying by 3 times would be enough on a long term or do I need to do it by 5 times ...what do you suggest and what all should taken into consideration when getting the databases onto another server

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi rads,

Looking at this question I think you may need to take a couple more things into account when choosing your Hard Disk space properly, Do you anticipate the databases to steadily grow at the same pace they have been growing? If so, you need to calculate how long it has taken the databases to grow to the size they are currently at and determine how soon they will reach 3 or 5 times the size they are currently, this will give you a timeline of when you can expect tehm to get that big. If you anticipate a spike in growth rate, by adding new users, more data, etc. then you will need to calculate that also. I would recommend going with a bigger hard drive to be safe, since Hard drives and storage are relatively inexpensive. As far as moving the databases to the new server it shouldn't be very hard just install SQL on the new server, create copies or backup the current databases, then attach or restore the databases on the new SQL Server, then point the clients to the new server and take the old server offline.  

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Radhs74Author Commented:
ok they are supposed to be increasing steadily at the same pace they have been growing .. ok so you
think that hardrive of 55-100gb would be appropriate or needs more than that. please update

thanks for your time and cooperation
I agree with spider as above, but some other things to think about...

I don't know what type of RAID you'll have setup on your new server but I'd suggest RAID10 for it's speed. You might have already done this but just mentioning. RAID5 suffers from write speeds.

Here is a previous article on SQL speed issues:

Also, handy ref:
Radhs74Author Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.