DATABASE DESIGN

• SQL_Comp

  SSChasing Mays

  Points: 646

  More actions

  March 22, 2007 at 12:30 am

  #68474

  Dear All,

  I Would like to create database with the name of 'Sales' and the defult size is 200 MB, But i don't want to specity with the T-SQL st. ! I am not specify the size parameter in the create database st. and my model database size is 10 MB defult.

   

  How can i create database with default size is 200MB...

   

  Thx

  Amey

  🙂 🙂 🙂
  Amey ghag
  <a href='http://' class='authorlink' target='_blank'></a>

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  March 22, 2007 at 11:37 am

  #696448

  Using the CREATE DATABASE statement, you can use the SIZE parameter to specify the default size.

  
  
  A.J.
  DBA with an attitude

• Lowell

  SSC Guru

  Points: 323518

  More actions

  March 23, 2007 at 6:07 am

  #696583

  creepy...looked in BOL for the CREATE database example, and their database is named Sales, just like you are asking:

  CREATE DATABASE Sales

  ON

  ( NAME = Sales_dat,

     FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf',

     SIZE = 200,

     MAXSIZE = 500,

     FILEGROWTH = 5 )

  LOG ON

  ( NAME = 'Sales_log',

     FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',

     SIZE = 5MB,

     MAXSIZE = 25MB,

     FILEGROWTH = 5MB )

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!