•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 422,636 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,670 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 928 | Replies: 1
•
•
Join Date: Aug 2007
Posts: 98
Reputation: 
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
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
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
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode- Help with job estimate programs (C++)
- table and the index size(individually). (MS SQL)
- table and the index size(individually). (MS SQL)
- Change Web Page Font Size on the Fly (Windows tips 'n' tweaks)
- Any advice about folder size viewer (Windows NT / 2000 / XP / 2003)
- DVD+RW/+R Burning problems Update (Storage)
- window size keeps changing (Windows 9x / Me)
- can't find file size over 3 megabytes to clean up harddrive (Windows NT / 2000 / XP / 2003)
- Help: Weird Hard drive space flucuation? (Windows NT / 2000 / XP / 2003)
Other Threads in the MS SQL Forum
- Previous Thread: IDENTITY_INSERT in MSSQL 2005
- Next Thread: Developing SQL Server 2000
