lab 5 trang 185

Code:

--Lab 5 trang 185 RDBMS

--Create a database named UnitedAir
create database [UnitedAir]
on primary
(
   name=N'UnitedAir',
   filename=N'E:\datasql\UnitedAir.mdf',
   size=10mb, maxsize=100mb, filegrowth=1mb
)
log on
(
   name=N'UnitedAir_log',
   filename=N'E:\datasql\UnitedAir_log.ldf',
   size=10mb, maxsize=100mb, filegrowth=1mb
)
--Create primary filegroup with file UnitedAir1_dat and UnitedAir2_dat.With the size,maximumsize and file frowth should be,5,10and 15% respectively.
alter database [UnitedAir]
add file
(
   name=N'UnitedAir1_dat',
   filename=N'E:\datasql\UnitedAir1_dat.ndf',
   size=5MB,maxsize=10MB,filegrowth=15%
)
--Create filegroup UnitedAir2_dat
alter database [UnitedAir]
add file
(
   name=N'UnitedAir2_dat',
   filename=N'E:\datasql\UnitedAir2_dat.ndf',
   size=5MB,maxsize=10MB,filegrowth=15%
)
alter database [UnitedAir] add filegroup [UnitedAirGroup1]
alter database [UnitedAir] add filegroup [UnitedAirGroup2]
--create file UnitedAirGrp1F1
alter database [UnitedAir]
add file
(
   name=N'UnitedAirGrp1F1',
   filename=N'E:\datasql\UnitedAirGrp1F1.ndf'
)
to filegroup [UnitedAirGroup1]
--Create file UnitedAirGrp1F2
alter database [UnitedAir]
add file
(
   name=N'UnitedAirGrp1F2',
   filename=N'E:\datasql\UnitedAirGrp1F2.ndf'
)
to filegroup [UnitedAirGroup1]
--create file UnitedAirGrp2F1
alter database [UnitedAir]
add file
(
   name=N'UnitedAirGrp2F1',
   filename=N'E:\datasql\UnitedAirGrp2F1.ndf'
)to filegroup [UnitedAirGroup2]
--create file UnitedAirGrp2F2
alter database [UnitedAir]
add file
(
   name=N'UnitedAirGrp2F2',
   filename=N'E:\datasql\UnitedAirGrp2F2.ndf'
)to filegroup [UnitedAirGroup2]
--create a database snapshot for the database unitedAir
create database UnitedAir_snap
on
(
   name=N'UnitedAir',
   filename=N'E:\datasql\UnitedAir_snap.ss'
),
(
   name=N'UnitedAir1_dat',
   filename=N'E:\datasql\UnitedAir_snap1.ss'
),
(
   name=N'UnitedAir2_dat',
   filename=N'E:\datasql\UnitedAir_snap2.ss'
),
(
   name=N'UnitedAirGrp1F1',
   filename=N'E:\datasql\UnitedAir_snap3.ss'
),
(
   name=N'UnitedAirGrp1F2',
   filename=N'E:\datasql\UnitedAir_snap4.ss'
),
(
   name=N'UnitedAirGrp2F1',
   filename=N'E:\datasql\UnitedAir_snap5.ss'
),
(
   name=N'UnitedAirGrp2F2',
   filename=N'E:\datasql\UnitedAir_snap6.ss'
)
as snapshot of UnitedAir

Anonymous442666 đã viết:Chài sao ông không upload file sql cho dễ chơi không