estimate size?
 

Hey guys!

I am new to SQL Server and as I am still a student I have never created a database completely from scratch before.

I believe that at the very start of development I have to create the database with the following code:-

CREATE DATABASE <database name>
[ON [PRIMARY]
([NAME = <’logical file name’>,]
FILENAME = <’file name’>
[, SIZE = <size in kilobytes, megabytes, gigabytes, or terabytes>]
[, MAXSIZE = size in kilobytes, megabytes, gigabytes, or terabytes>]
[, FILEGROWTH = <kilobytes, megabytes, gigabytes, or terabytes|percentage>])]
[LOG ON
([NAME = <’logical file name’>,]
[, SIZE = <size in kilobytes, megabytes, gigabytes, or terabytes>]
[, MAXSIZE = size in kilobytes, megabytes, gigabytes, or terabytes>]
[, FILEGROWTH = <kilobytes, megabytes, gigabytes, or terabytes|percentage>])]
GO

but, how would I go about estimating how big the database is going to be when I have no idea? Is there a default value or anything that I can enter that will allow me to just create the database without the possibility of running out of space? I am getting a bit anxious as I cannot begin to develop until I get over this problem.

Any ideas would be greatly appreciated.
Thanks!

GLT

Re: estimate size?
 

really you just need to type CREATE DATABASE (name) - the rest is optional, it will use appropriate values for you if you do not sspecify any.