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