SQLAdmin/Scripts/obscure_master_database.sql at master · NielsGrove/SQLAdmin · 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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
/*
Description
    Fooling around master-database(s)
*/
USE [tempdb];
GO

--**  Does not work  **
CREATE DATABASE [master ] ON  PRIMARY
( NAME = N'master_data', FILENAME = N'L:\SSDB2019\Data\master_data.mdf', SIZE = 8MB, FILEGROWTH = 8MB )
 LOG ON
( NAME = N'master_log', FILENAME = N'L:\SSDB2019\TransLog\master_log.ldf', SIZE = 8MB, FILEGROWTH = 8MB );
GO
/*
Msg 1801, Level 16, State 3, Line 8
Database 'master ' already exists. Choose a different database name.
*/

-- DROP DATABASE [ master];
CREATE DATABASE [ master] ON  PRIMARY
( NAME = N'master0_data', FILENAME = N'L:\SSDB2019\Data\master0_data.mdf', SIZE = 8MB, FILEGROWTH = 8MB )
 LOG ON
( NAME = N'master0_log', FILENAME = N'L:\SSDB2019\TransLog\master0_log.ldf', SIZE = 8MB, FILEGROWTH = 8MB );
GO
ALTER AUTHORIZATION ON DATABASE::[ master] TO [sa];
GO

CREATE DATABASE [ master ] ON  PRIMARY
( NAME = N'master1_data', FILENAME = N'L:\SSDB2019\Data\master1_data.mdf', SIZE = 8MB, FILEGROWTH = 8MB )
 LOG ON
( NAME = N'master1_log', FILENAME = N'L:\SSDB2019\TransLog\master1_log.ldf', SIZE = 8MB, FILEGROWTH = 8MB );
GO
/**  Error when [ master] exists  **
Msg 1801, Level 16, State 3, Line 18
Database ' master ' already exists. Choose a different database name.
*/

-- DROP DATABASE [master.];
CREATE DATABASE [master.] ON  PRIMARY
( NAME = N'master_dot_data', FILENAME = N'L:\SSDB2019\Data\master_dot_data.mdf', SIZE = 8MB, FILEGROWTH = 8MB )
 LOG ON
( NAME = N'master_dot_log', FILENAME = N'L:\SSDB2019\TransLog\master_dot_log.ldf', SIZE = 8MB, FILEGROWTH = 8MB );
GO
ALTER AUTHORIZATION ON DATABASE::[master.] TO [sa];
GO

CREATE DATABASE [master.dbo] ON  PRIMARY
( NAME = N'master_dbo_data', FILENAME = N'L:\SSDB2019\Data\master_dbo_data.mdf', SIZE = 8MB, FILEGROWTH = 8MB )
 LOG ON
( NAME = N'master_dbo_log', FILENAME = N'L:\SSDB2019\TransLog\master_dbo_log.ldf', SIZE = 8MB, FILEGROWTH = 8MB );
GO
ALTER AUTHORIZATION ON DATABASE::[master.dbo] TO [sa];
GO