Créer une base de données

Use Master;

 

 

GO

 

 

CREATE DATABASE bdi_test

 

 

ON

(

  Name = bdi_test_dat,

  Filename = "C:[[]]Program Files[[]]Microsoft SQL Server[[]]MSSQL12.SQLEXPRESS[[]]MSSQL[[]]DATA[[]]bdi_test.mdf",

  SIZE=10,

  MAXSIZE=50,

  FILEGROWTH =5

)

 

 

LOG ON

(

  Name = bdi_test_log,

  Filename = "C:[[]]Program Files[[]]Microsoft SQL Server[[]]MSSQL12.SQLEXPRESS[[]]MSSQL[[]]DATA[[]]bdi_test.ldf",

  SIZE=5MB,

  MAXSIZE=25MB,

  FILEGROWTH =5MB

);

 

 

GO