what should my initial database size be

Question

I'm moving a database from MySQL to SQLServer. When creating the database, what should I set the initial size to? I know the size of the imported database will be about 130MB but will grow. Should 130MB be the initial size or should I just take the default of 2MB?

Answer 1

You should make it the correct size to fit your data, you will get a performance hit whenever the file needs to grow.

It depends how fast it would grow, I would say 150MB with 10% Autogrowth.

There is advice on the MSDN that is worth a read.