? Enterprise Manager ?????

1
? 6 ?

• ?????

2
????

• ? Enterprise Manager ?????
• ? CREATE DATABASE ???????
• ????????
• ? Enterprise Manager ????????
• ? ALTER DATABASE ???????
• ?????

3
? Enterprise Manager
?????

• SQL Server ??????????????????????, ??????????,
  ????????, ???????, ???????????????, ?????????

4
? Enterprise Manager
???????
5
? Enterprise Manager
???????
6
? Enterprise Manager
???????
7
? Enterprise Manager
???????
8
?????????

• ???? / ????

9
?????????
10
??????????
11
??????????
12
??????????
13
??????????
14
??????????
15
??????????
16
??????????
17
??????????
18
? CREATE DATABASE ???????
19
CREATE DATABASE?????
20
?????? - ???????????

• ??
• ????????
• ???? (filegroup)
• ?????????

21
??

• ?????????????????

22
?????????

• ?????? (logical_file_name)
• ?????? (os_file_name)

23
????????

• PRIMARY
• NAME logical_file_name
• FILENAME 'os_file_name'
• SIZE size
• MAXSIZE max_size UNLIMITED
• FILEGROWTH grow_increment

24
???? (filegroup)

• ?????
• ?????????

25
?????????
26
? Enterprise Manager ???????
27
????

• ???????, ???????????????????

28
????

• ?????????, ??????????????, ???????????????????????
  ???????

29
????

• ???????, ???? 6 ?????? 3 ?????

30
???????
31
??????

• ?? COLLATE ?????????????????????, ??????? SQL
  Server ?????

32
??????

• ? Query Analyzer ????????, ??????????,
  ?????????????, ??? COLLATE ?????

33
????????
34
?????
35
?????
36
?????
37
???????

• ????????????????, ??????????

38
?????
39
?????
40
?????
41
?????
42
?????

• ?? CREATE DATEBASE ???? FOR ATTACH ??????????????
  SQL Server

43
?????

• ??? sp_attach_db ??????????

44
? Enterprise Manager ?
???????

• ???????????
• ????
• ??????
• ???????
• ??????
• ????
• ????

45
???????????
46
????
47
??????
48
???????
49
??????
50
????
51
????

• ???

52
????

• ???? 3 ????????
• ???????????????????
• ???????????????
• ??????????????

53
????

• ???

54
????
55
? ALTER DATABASE ???????
56
????

• ALTER DATABASE database
• ADD FILE ltfilespecgt ,n TO FILEGROUP
  filegroup_name

57
????

• ADD LOG FILE lt filespec gt ,n
• REMOVE FILE logical_file_name
• ADD FILEGROUP filegroup_name
• REMOVE FILGROUP filegroup_name

58
????

• MODIFY FILE lt filespecgt

59
?????????????sp_helpfile
60
????

• MODIFY NAME new_dbname

61
???????sp_renamedb
62
????

• MODIFY FILEGROUP filegroup_name
  filegroup_property NAME new_ filegroup_name

63
???????????sp_helpfilegroup
64
????

• SET lt optionspec gt ,n WITH lt termination gt

65
????
66
????

• COLLATE lt collation_name gt

67
????
68
? Enterprise Manager ??????
69
? Enterprise Manager ??????
70
????? DROP DATABASE ??
71
?? SQL Server ??????sp_helpdb