Contents

1 旧
2 blocksize旧
3 blocksize, maxtransfersize 旧
4 ろ語 覦煙 ろ


旧 磯殊 覦煙 焔レ 企至 覲讌 ろ碁ゼ 企慨. 2000覯 blocksize朱 れ螳 覓語 讌襷, maxtransfersize 覓語讌 旧企. 企 覓語 誤螻伎 cpu i/o 螳 4096byte手 覲 . 蠏碁 蠏碁一 blocksize螳 4096byte 蟆曙郁 螳 焔レ 譬. 蟆磯朱 blocksize, maxtransfersize 旧 覃 10% 伎 焔ロレ 螻 覲 も螻 蟆. ろ 蟆郁骸. 谿瑚襦 CPU 2.4 GHz, RAM 2G, Disk 1螳 PC ろ . 譯殊 蟆 蟆曙 磯殊 旧 譟一伎 る 蟆企. 蠍 る 螳れ 旧 .

[edit]

1 旧 #

backup database sample to disk = 'f:\sample.bak'
--BACKUP DATABASE(螳) 407185伎襯 45.081豐(73.992MB/豐)襷 豌襴給.

[edit]

2 blocksize旧 #

backup database sample to disk = 'f:\sample.bak' with blocksize = 65536
--BACKUP DATABASE(螳) 407186伎襯 44.837豐(74.395MB/豐)襷 豌襴給.

backup database sample to disk = 'f:\sample.bak' with blocksize = 32768
--BACKUP DATABASE(螳) 405063伎襯 42.789豐(77.549MB/豐)襷 豌襴給.

backup database sample to disk = 'f:\sample.bak' with blocksize = 16384
--BACKUP DATABASE(螳) 424447伎襯 45.562豐(76.315MB/豐)襷 豌襴給.

backup database sample to disk = 'f:\sample.bak' with blocksize = 8192
--BACKUP DATABASE(螳) 407185伎襯 41.560豐(80.261MB/豐)襷 豌襴給.

backup database sample to disk = 'f:\sample.bak' with blocksize = 4096
--BACKUP DATABASE(螳) 407185伎襯 41.487豐(80.402MB/豐)襷 豌襴給. ======> 蠍!!

backup database sample to disk = 'f:\sample.bak' with blocksize = 2048
--BACKUP DATABASE(螳) 407185伎襯 41.991豐(79.437MB/豐)襷 豌襴給.

[edit]

3 blocksize, maxtransfersize 旧 #

backup database sample to disk = 'f:\sample.bak' with blocksize = 65536, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 407186伎襯 44.837豐(74.395MB/豐)襷 豌襴給.
--maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 37.741豐(88.382MB/豐)襷 豌襴給.

backup database sample to disk = 'f:\sample.bak' with blocksize = 32768, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 405063伎襯 42.789豐(77.549MB/豐)襷 豌襴給.
--maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407191伎襯 35.431豐(94.146MB/豐)襷 豌襴給.

backup database sample to disk = 'f:\sample.bak' with blocksize = 16384, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 424447伎襯 45.562豐(76.315MB/豐)襷 豌襴給.
--maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 34.327豐(97.172MB/豐)襷 豌襴給. ======> 蠍!!

backup database sample to disk = 'f:\sample.bak' with blocksize = 8192, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 407185伎襯 41.560豐(80.261MB/豐)襷 豌襴給.
--maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 34.993豐(95.323MB/豐)襷 豌襴給.

backup database sample to disk = 'f:\sample.bak' with blocksize = 4096, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 407185伎襯 41.487豐(80.402MB/豐)襷 豌襴給.
--maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 34.898豐(95.582MB/豐)襷 豌襴給.

backup database sample to disk = 'f:\sample.bak' with blocksize = 2048, maxtransfersize = 4194304
--BACKUP DATABASE(螳) 407185伎襯 41.991豐(79.437MB/豐)襷 豌襴給.
--maxtransfersize旧豢螳: BACKUP DATABASE(螳) 407185伎襯 40.486豐(82.390MB/豐)襷 豌襴給.

[edit]

4 ろ語 覦煙 ろ #

backup database sample
to disk = '\\1.1.1.10\f$\sample.bak'
with blocksize = 16384, maxtransfersize = 65536, buffercount = 200

--with blocksize = 16384, maxtransfersize = 65536, buffercount = 100
--BACKUP DATABASE(螳) 536985螳 伎襯 64.417豐 豌襴給(68.289MB/豐).

--with blocksize = 16384, maxtransfersize = 65536, buffercount = 200
--BACKUP DATABASE(螳) 536985螳 伎襯 64.157豐 豌襴給(68.565MB/豐).





BACKUP DATABASE sample
TO DISK='\\1.1.1.10\d$\sample1.bak',
DISK='\\1.1.1.10\e$\sample2.bak2',
DISK='\\1.1.1.10\f$\sample3.bak',
disk='\\1.1.1.10\g$\sample4.bak'
with blocksize = 16384, maxtransfersize = 65536, buffercount = 200
--BACKUP DATABASE(螳) 536985螳 伎襯 57.390豐 豌襴給(76.650MB/豐).



BACKUP DATABASE sample
TO DISK='\\1.1.1.10\d$\sample1.bak',
DISK='\\1.1.1.10\e$\sample2.bak2',
DISK='\\1.1.1.10\f$\sample3.bak',
disk='\\1.1.1.10\g$\sample4.bak',
disk='\\1.1.1.10\h$\sample5.bak',
disk='\\1.1.1.10\i$\sample6.bak',
disk='\\1.1.1.10\j$\sample7.bak'
with blocksize = 16384, maxtransfersize = 65536, buffercount = 200
/*
1 一危磯伎 'sample', 'sample_Data' 268480螳 伎襯 豌襴給 .
1 一危磯伎 'sample', 'sample_Data1' 268504螳 伎襯 豌襴給 .
1 一危磯伎 'sample', 'sample_Log' 1螳 伎襯 豌襴給 .
BACKUP DATABASE(螳) 536985螳 伎襯 44.453豐 豌襴給(98.958MB/豐).
*/