Download : Create Databasae
- Membuat Database :
CREATE DATABASE MyDB
ON
(
NAME = File1,
Filename = 'File1.mdf',
SIZE = 10mb
)
- Membuat Databasae dengan sebuah file :
CREATE DATABASE MyDB
ON
(
NAME = DB_File_1,
Filename = 'C:\MyDB_1.mdf',
SIZE = 2MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 10%
)
- Membuat database dengan 2 file di filegroup PRIMARY :
CREATE DATABASE MyDB
ON
(
NAME = DB_File_1,
Filename = 'C:\MyDB_1.mdf',
) ,
(
NAME = DB_File_2,
Filename = 'C:\MyDB_2.ndf',
),
FILEGROUP TRANS
(
NAME = DB_File_Trans_1,
Filename = 'C:\MyDB_Trans_1.ndf',
) ,
(
NAME = DB_File_Trans_2,
Filename = 'C:\MyDB_Trans_2.ndf',
)
LOG ON
(
NAME = DB_File_Log_1,
Filename = 'C:\MyDB_Log_1.ldf',
) ,
(
NAME = DB_File_Log_1,
Filename = 'C:\MyDB_Log_1.ldf',
)
- Untuk menampilkan database :
sp_helpdb MyDB
atau
sp_helpdb 'MyDB'
Share : SQLserver (Create DataBase)
SQLserver (Create DataBase)
4/
5
Oleh
Unknown