Perintah Pembuatan Database

Perintah Pembuatan Database yang ditentukan Ekstensi file dan ukurannya :

create database coba
ON
( NAME = coba_dat,
  FILENAME = 'd:\sukriyadi\cobadata.mdf',
  SIZE = 10,
  MAXSIZE = 50,
  FILEGROWTH= 5)
LOG ON
( NAME = coba_log,
  FILENAME = 'd:\sukriyadi\cobalog.ldf',
  SIZE = 5MB,
  MAXSIZE = 25MB,
  FILEGROWTH=5MB)

Perintah dengan tambahan Primary dan Secondary. :

create database test
ON
( NAME = test_dat_primary,
  FILENAME = 'd:\sukriyadi\test_primary.mdf',
  SIZE = 10,
  MAXSIZE = 50,
  FILEGROWTH= 5),
  ( NAME = test_dat_secondary,
  FILENAME = 'd:\sukriyadi\test_secondary.mdf',
  SIZE = 10,
  MAXSIZE = 50,
  FILEGROWTH= 5)
 
LOG ON
( NAME = test_log,
  FILENAME = 'd:\sukriyadi\testlog.ldf',
  SIZE = 5MB,
  MAXSIZE = 25MB,
  FILEGROWTH=5MB)

SEMOGA BERMANFAAT

---