-
Notifications
You must be signed in to change notification settings - Fork 1
/
channel10backup.sql
72 lines (69 loc) · 3.53 KB
/
channel10backup.sql
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
backup database channeldb10 to
disk = 'c:\data\ssd0\channeldb10\channeldb10.01.bak',
disk = 'c:\data\ssd0\channeldb10\channeldb10.02.bak',
disk = 'c:\data\ssd0\channeldb10\channeldb10.03.bak',
disk = 'c:\data\ssd0\channeldb10\channeldb10.04.bak',
disk = 'c:\data\ssd0\channeldb10\channeldb10.05.bak',
disk = 'c:\data\ssd0\channeldb10\channeldb10.06.bak',
disk = 'c:\data\ssd1\channeldb10\channeldb10.07.bak',
disk = 'c:\data\ssd1\channeldb10\channeldb10.08.bak',
disk = 'c:\data\ssd1\channeldb10\channeldb10.09.bak',
disk = 'c:\data\ssd1\channeldb10\channeldb10.10.bak',
disk = 'c:\data\ssd1\channeldb10\channeldb10.11.bak',
disk = 'c:\data\ssd1\channeldb10\channeldb10.12.bak',
disk = 'c:\data\ssd2\channeldb10\channeldb10.13.bak',
disk = 'c:\data\ssd2\channeldb10\channeldb10.14.bak',
disk = 'c:\data\ssd2\channeldb10\channeldb10.15.bak',
disk = 'c:\data\ssd2\channeldb10\channeldb10.16.bak',
disk = 'c:\data\ssd2\channeldb10\channeldb10.17.bak',
disk = 'c:\data\ssd2\channeldb10\channeldb10.18.bak',
disk = 'c:\data\ssd3\channeldb10\channeldb10.19.bak',
disk = 'c:\data\ssd3\channeldb10\channeldb10.20.bak',
disk = 'c:\data\ssd3\channeldb10\channeldb10.21.bak',
disk = 'c:\data\ssd3\channeldb10\channeldb10.22.bak',
disk = 'c:\data\ssd3\channeldb10\channeldb10.23.bak',
disk = 'c:\data\ssd3\channeldb10\channeldb10.24.bak',
disk = 'c:\data\ssd4\channeldb10\channeldb10.25.bak',
disk = 'c:\data\ssd4\channeldb10\channeldb10.26.bak',
disk = 'c:\data\ssd4\channeldb10\channeldb10.27.bak',
disk = 'c:\data\ssd4\channeldb10\channeldb10.28.bak',
disk = 'c:\data\ssd4\channeldb10\channeldb10.29.bak',
disk = 'c:\data\ssd4\channeldb10\channeldb10.30.bak',
disk = 'c:\data\ssd5\channeldb10\channeldb10.31.bak',
disk = 'c:\data\ssd5\channeldb10\channeldb10.32.bak',
disk = 'c:\data\ssd5\channeldb10\channeldb10.33.bak',
disk = 'c:\data\ssd5\channeldb10\channeldb10.34.bak',
disk = 'c:\data\ssd5\channeldb10\channeldb10.35.bak',
disk = 'c:\data\ssd5\channeldb10\channeldb10.36.bak',
disk = 'c:\data\ssd6\channeldb10\channeldb10.37.bak',
disk = 'c:\data\ssd6\channeldb10\channeldb10.38.bak',
disk = 'c:\data\ssd6\channeldb10\channeldb10.39.bak',
disk = 'c:\data\ssd6\channeldb10\channeldb10.40.bak',
disk = 'c:\data\ssd6\channeldb10\channeldb10.41.bak',
disk = 'c:\data\ssd6\channeldb10\channeldb10.42.bak',
disk = 'c:\data\ssd7\channeldb10\channeldb10.43.bak',
disk = 'c:\data\ssd7\channeldb10\channeldb10.44.bak',
disk = 'c:\data\ssd7\channeldb10\channeldb10.45.bak',
disk = 'c:\data\ssd7\channeldb10\channeldb10.46.bak',
disk = 'c:\data\ssd7\channeldb10\channeldb10.47.bak',
disk = 'c:\data\ssd7\channeldb10\channeldb10.48.bak',
disk = 'c:\data\ssd8\channeldb10\channeldb10.49.bak',
disk = 'c:\data\ssd8\channeldb10\channeldb10.50.bak',
disk = 'c:\data\ssd8\channeldb10\channeldb10.51.bak',
disk = 'c:\data\ssd8\channeldb10\channeldb10.52.bak',
disk = 'c:\data\ssd8\channeldb10\channeldb10.53.bak',
disk = 'c:\data\ssd8\channeldb10\channeldb10.54.bak',
disk = 'c:\data\ssd9\channeldb10\channeldb10.55.bak',
disk = 'c:\data\ssd9\channeldb10\channeldb10.56.bak',
disk = 'c:\data\ssd9\channeldb10\channeldb10.57.bak',
disk = 'c:\data\ssd9\channeldb10\channeldb10.58.bak',
disk = 'c:\data\ssd9\channeldb10\channeldb10.59.bak',
disk = 'c:\data\ssd9\channeldb10\channeldb10.60.bak',
disk = 'c:\data\ssd10\channeldb10\channeldb10.61.bak',
disk = 'c:\data\ssd10\channeldb10\channeldb10.62.bak',
disk = 'c:\data\ssd10\channeldb10\channeldb10.63.bak',
disk = 'c:\data\ssd10\channeldb10\channeldb10.64.bak'
with compression,checksum, stats=1
backup log channeldb10 to disk = 'c:\data\ssd0\channeldb10.log.trn'
with checksum
go