lab-security-sqlserver/01-create-database.sql at master · gunners-pro/lab-security-sqlserver · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
create database TechCorp
on primary
(
	name = N'TechCorp_Primary',
	filename = N'E:\Data\TechCorp_Primary.mdf',
	filegrowth = 256mb,
	size = 256mb
),
filegroup FB_INDEX
(
	name = N'TechCorp_Indexes',
	filename = N'E:\Data\TechCorp_Indexes.ndf',
	filegrowth = 256mb,
	size = 256mb
)
log on
(
	name = N'TechCorp_Logs',
	filename = N'F:\Logs\TechCorp_Logs.ldf',
	filegrowth = 256mb,
	size = 256mb,
	maxsize = 1024mb
)
go

alter database TechCorp
set recovery full
go