Data Protection for Microsoft SQL Server w P...

IBM Tivoli Storage Managerfor Databases

Data Protection for Microsoft SQLServerwPΓU

5.2

SC40-1151-01

N

ΩTMΣΣúºeA²\¬ 151yNzU@δΩTC

G (2003 9 δ)

A≤ IBM Tivoli Storage Manager for Databases Data Protection for Microsoft SQL Server 5.2.1 (ús5698-APD) Hß≥AsNsTñtⁿεC

2002 9 δºß@≤Aúbñ¬ΣZW½u (|) [HCTwzw∩úhTC

zLNϕϕaqqXC

Q½°zQNúA]oNúiHUúTB¬ΦΩTCpGz∩≤⌠≤ΣL IBMTivoli Storage Manager σ≤⌠≤NúA\ viiiypßΣñzC

© Copyright International Business Machines Corporation 1997, 2003. All rights reserved.

||

²

≤J. . . . . . . . . . . . . . . v2003 9 δA5.2.1 . . . . . . . . . . . v

eÑ . . . . . . . . . . . . . . . . viiAX¬ . . . . . . . . . . . . . viiIBM Tivoli Storage Manager ⌠ . . . . . . . viiIBM Tivoli Storage Manager X . . . . . . viiipßΣñ . . . . . . . . . . . . viiiD . . . . . . . . . . . . . . . ix\¬yk . . . . . . . . . . . . . . . x

ϕ. . . . . . . . . . . . . . . . . xiii

1 Data Protection for SQL 1sS . . . . . . . . . . . . . . . . 1αM@sN . . . . . . . . . . 1Data Protection for SQL S . . . . . . . . . 2Data Protection for SQL \α . . . . . . . . . 3

SQL Server Ωw≈ . . . . . . . . . . 3SQL Server Ωw . . . . . . . . . . 4Data Protection for SQL d . . . . . . . . 5SQL Server Ωw . . . . . . . . . . 6

Data Protection for SQL w . . . . . . . . . 6Tivoli Storage Manager w . . . . . . . . 7SQL Server nJΩT . . . . . . . . . . 7

Data Protection for SQL α . . . . . . . . . 7Data Protection for SQL ≈ªñN . . . . 8ΣLªñN . . . . . . . . . . . 9

uWí . . . . . . . . . . . . . . . 11yΣ . . . . . . . . . . . . . . 11b MSCS W⌡µ Data Protection for SQL . . . . 11

2 w Data Protection for SQL 13Data Protection for SQL ≥D . . . . . . . 13nΘ@tD . . . . . . . . . . 13wΘD . . . . . . . . . . . . . . 13qT . . . . . . . . . . . . . . . . 14

w Data Protection for SQL . . . . . . . . 14yÑM≤ . . . . . . . . . . . . . . 15

b MSCS ⌠ñw Data Protection for SQL . . . 15

3 tm Data Protection for SQL 17 Tivoli Storage Manager Server n² DataProtection for SQL . . . . . . . . . . . . 17tm Tivoli Storage Manager Server . . . . . . 17tm Data Protection for SQL ∩ . . . . . . 18]w . . . . . . . . . . . . . . 19Tivoli Storage Manager hDM . . . . . 21

4 í . . . . . 25GUI º[ . . . . . . . . . . . . . . . 25

\αϕC . . . . . . . . . . . . . . 25uπC . . . . . . . . . . . . . . . 27≈°í . . . . . . . . . . . . 28

≈ SQL Ωw . . . . . . . . . . . . 30≈Ωw . . . . . . . . . . . . 30≈s/ . . . . . . . . . . . 31≈≡¼c . . . . . . . . . . . . . 31≈Mµ . . . . . . . . . . . . . . 32

SQL Ωw . . . . . . . . . . . . 33Ωw . . . . . . . . . . . . 33s/ . . . . . . . . . . . 34∩ . . . . . . . . . . . . . . 34≡¼c . . . . . . . . . . . . . 35Mµ . . . . . . . . . . . . . . 36

SQL Ωw . . . . . . . . . . . . 37≡¼cMMµ . . . . . . . . . . 38

5 ⁿOµ . . . . . . . . 39ⁿOykº[ . . . . . . . . . . . . . 39

Data Protection for SQL ⁿO . . . . . . . 39m . . . . . . . . . . . . . . 39∩ . . . . . . . . . . . . . . 42Φ . . . . . . . . . . . . . . 44N . . . . . . . . . . . . . . 45

Data Protection for SQL ⁿO . . . . . . . . 46Backup ⁿO . . . . . . . . . . . . . 46Query ⁿO . . . . . . . . . . . . . 52Restore ⁿO . . . . . . . . . . . . . 62Inactivate ⁿO . . . . . . . . . . . . 75Help ⁿO . . . . . . . . . . . . . . 79Set ⁿO . . . . . . . . . . . . . . 83Changetsmpassword ⁿO . . . . . . . . . 85

6 ⁿOµ . . . . . . . . . 87m . . . . . . . . . . . . . . . 87

dbname . . . . . . . . . . . . . . . 87≈½≤¼ . . . . . . . . . . . . . 87Query . . . . . . . . . . . . . . . 92Set . . . . . . . . . . . . . . . . 95CHANGETSMPassword . . . . . . . . . . 99

∩ . . . . . . . . . . . . . . . 100

² A. Tivoli Storage Manager . . . . . . . . . . . . . . 117d . . . . . . . . . . . . . . . 117N . . . . . . . . . . . . . 122

² B. Lnw . . . . . . . . 125]wí (setup.exe) iµw . . . . . . 127σ . . . . . . . . . . . . . 127

MSI (msiexec.exe) iµw . . . . . . . 127

© Copyright IBM Corp. 1997, 2003 iii

||

||

wDG wΘx . . . . . . . . . . 128b CD °AWM≤ . . . . . . . 128LnwM≤ . . . . . . . . . 128

±Lnw . . . . . . . . . . . . 129]wwTº . . . . . . . . . . . . 129

² C. iÑ . . . . . . . . . . 131d include/exclude »zí . . . . . . . . . 131DnΩw . . . . . . . . . . . . . 134]wí . . . . . . . . . . . . . 134

² D. DRU . . . . . . . . 137

² E. Data Protection for SQL Tº 139

N. . . . . . . . . . . . . . 151 . . . . . . . . . . . . . . . . 152

Wⁿ. . . . . . . . . . . . . . 153

. . . . . . . . . . . . . . . 157

iv IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server wPΓU

≤J

HUJX≤C

2003 9 δA5.2.1

]tUC≤G

v Σ Windows Server 2003C\ 13ynΘ@tDzC

v OwuyÑM≤viCpΩTA\ 15yyÑM≤zC

v Data Protection for SQL Σ SQL Server 2000 (64 )Cp÷ΩTA\

13ynΘ@tDzC

© Copyright IBM Corp. 1997, 2003 v

|

|

|

|

|

vi IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server wPΓU

eÑ

bσñAN IBM Tivoli Storage Manager for Databases Data Protection for

Microsoft SQL Server Data Protection for SQLC

Data Protection for SQL ⌡µ Microsoft SQL Server ΩwuW≈A≈

Tivoli Storage Manager xsΘC

Tivoli Storage Manager O@ODq[cvúAªúh¡xqú⌠xsΘ

zAC

bσ≤ñAWindows NyNϕUC@t (úDtⁿw)G

v Windows NT Server

v Windows 2000 Server

v Windows Server 2003

bσ≤ñASQL Server NyNϕUCú (úDtⁿw)G

v SQL Server 7.0

v SQL Server 2000 (32 )

v SQL Server 2000 (64 )

AX¬

¬sBtwHBtBtzHC

bñA]zwAUCíG

v Microsoft SQL Server

v Tivoli Storage Manager Server

v Tivoli Storage Manager ≈Osß

v Tivoli Storage Manager í]p

]]zwAUCΣñ@@tG

v Windows NT Server

v Windows 2000 Server

v Windows Server 2003

IBM Tivoli Storage Manager ⌠

ziHbUC⌠ oNΣΩTXG

www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

ziHs Tivoli Storage Manager As DDCz]iHHD

s Tivoli Storage Manager úΩTC

© Copyright IBM Corp. 1997, 2003 vii

|

|

|

|

|

|

|

|

http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

IBM Tivoli Storage Manager X

ϕ 1. ÷ Tivoli Storage Manager X

D qs

IBM Tivoli Storage Manager for Windows ≈Osßw

PΓU

GC40-0763

IBM Tivoli Storage Manager for UNIX ≈Osßw

PΓU

GC40-0761

IBM Tivoli Storage Manager for Windows zΓU GC40-0721

IBM Tivoli Storage Manager for Windows zΓU GC40-0722

IBM Tivoli Storage Manager for AIX zΓU GC40-0709

IBM Tivoli Storage Manager for AIX zΓU GC40-0710

IBM Tivoli Storage Manager for Sun Solaris zΓU GC40-0717

IBM Tivoli Storage Manager for Sun Solaris zΓU GC40-0718

IBM Tivoli Storage Manager TºΓU SC40-1906

IBM Tivoli Storage Manager í]p GC40-0765

IBM Tivoli Storage Manager for Windows xsΘNzí

ΓU

GC40-0724-00

UC IBM Xú÷ΩTC

ϕ 2. ÷ IBM X

D qs

Using Tivoli Data Protection for Microsoft SQL Server (IBM

⌡)

SG24-6148

pßΣñ

pú⌠≤ Tivoli úΣAQUCΣñ@ΦkApuIBM Tivoli

nΘΣñvG

v yX IBM Tivoli Software Support ⌠A⌠G

www.ibm.com/software/sysmgmt/products/support

v uIBM ΣMΦvΩwtσΩTwAoσΩTOP≈

@÷DCbUC⌠s ΩTG

www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManagerforDatabases.html

b Self Help ϕµñ÷@U Hints and TipsBSolutions Support Flashes AHjMΩTC

v HqlΦíeXDzO² (PMR) IBMSERV/IBMLINKCziHq IBM ⌠

s IBMLINKA⌠G

www.ibm.com/ibmlink

v bUC⌠HqlΦíeXDzO² (PMR)G

www.ibm.com/software/support/probsub.html

viii IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server wPΓU

|

|

||

|

|

http://www.ibm.com/software/sysmgmt/products/support

http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManagerforDatabases.html

http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManagerforDatabases.html

http://www.ibm.com/ibmlink

http://www.ibm.com/software/support/probsub.html

v ÑßyX TDD/TTY Voice Relay services and Accessibility Center ⌠A

⌠G

www.ibm.com/able/voicerelay.html

ⁿΩß]i 1-800-IBM-SERV (1-800-426-7378)C

ΩßyX⌠AH oßΣñqXC

z]iH\ib⌠ o IBM Software Support GuideA⌠G

techsupport.services.ibm.com/guides/handbook.html

ϕzpuIBM nΘΣñvAnzqOΩTAHKΣHiH

a≤UzCzqOΩTAαn²H oib⌠WúuWΣC

Σ⌠iúsxΩTA]AΣAΓU (IBM Software Support Guide)F

úD (FAQ)FHuIBM nΘvúíσ≤AΣñ]AuN

vBu⌡v BD°i (APAR) MΦCí≈úPú

PDF HTML µííσ≤Cí≈ú]wσ≤C

Tivoli XúiHzLqlΦíUⁿAOV IBM Publications Center qG

www.ibm.com/shop/publications/order/

D≤Ñz Tivoli úíσ≤gτCP]w∩zúXUA

@∩iCpGz∩íσ≤⌠≤NúAbUC⌠

¬²CñA∩ Feedback A±gßNúϕG

www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

ϕz°iDAnUCΩTG

v Tivoli Storage Manager Server BB qAhXCziHb Tivoli

Storage Manager ⁿOµΘJ query status ⁿOA oΩTC

v Tivoli Storage Manager ßBB qAhXCziHbⁿOµ

ΘJ dsmc ⁿOA oΩTC

v zbqT≤w (pATCP/IP)BXC

v ϕDo!zbiµíAPCXbDo!ºeAzϕBJC

v ⌠≤TºδTσrC

D

σ≤hrΘDNϕSϕⁿJP@CUDNqpUG

ϕ 3. rΘD

d í

Θ ⁿOB÷ΣrBvñΓΣLΩ

TAúHΘπCdGH root ¡≈nJ°AC

Θ zúHΘπCⁿj

rⁿMⁿ]HΘπCdG !ú

IM≈IIWúiHPC

eÑ ix

http://www.ibm.com/able/voicerelay.html

http://techsupport.services.ibm.com/guides/handbook.html

http://www.ibm.com/shop/publications/order/

http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

ϕ 3. rΘD (≥)

d í

Θ ∩HΘπCdGⁿwúY

∩C

ÑerΘ ²BBURL ΘXdúHÑerΘ

πCdGúwwb C:\program

files\tivoli\tsm\client\ba ²ñC

jgrΘ P Tivoli Storage ManagerB@t SQL

Server ÷⌠úHujgrΘvX

CdGTw DSM_DIR ⌠]w

TC

\¬yk

íp≤\¬ñykCYn\¬ykAϕµ⌠CH"¬V

k"WUΦí\¬C

v "" ⁿykYC

v µ " ⁿyk≥U@µC

v µ " ⁿyk≥W@µC

v "$ ⁿykC

yk (p÷Σr) pUG

v bµW (n)

v bµWΦ (w])

v bµUΦ (∩)C

ykí d

YgG

jgr$ϕiⁿuICY

Hjgr$πAhLkQIC

ziHjgpgr$⌠≤XΣJ

C

bdñAziHΘJ KEYWOBKEYWORD

KEYWOrdC

"" KEYWOrd "$

G

oPykñXPΘ

JC

* P

jA

:

, rI

= Ñ

- Θ

() A

. yI

µ

x IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server wPΓU

ykí d

G

Θr¼pg (var_name) ϕC

bdñAϕzΘJ KEYWORD ⁿOAz

iHⁿw var_nameC

"" KEYWOrd var_name "$

½G

αV¬bYϕziH½C

bYrµϕzHr

µj½C

bYϕzi½C

"" * repeat "$

"" *

,

repeat "$

"" *(1)

repeat "$

:

1 ⁿw repeat 5 ºhC

n∩G

ϕ∩ñΓhBΣñ@≤µ

WAzⁿw@C

bdñAz∩ ABB CC

"" ABC

"$

∩∩G

ϕ≤µUΦA∩Cb

@dñAziH∩ A ú⌠≤∩

C

ϕΓh≤µUΦ∩ñA

íúO∩CbGdñAziH∩

ABBBC ú⌠≤∩C

""A

"$

""ABC

"$

w]G

w]ObµWΦCúDzm½w]A

h∩ w]CziH"JµU∩

ñ∩m½w]C

bdñAA Ow]CziH∩ B C

m½ AC]iHTⁿww]C

""A

BC

"$

eÑ xi

ykí d

i½∩G

ßV¬bY∩ϕziH∩ W

L@AbYípUi½µ@

C

bdñAziH∩ ABB C ⌠≤

XC

"" * ABC

"$

ykqG

Yyk]°÷YANyk

qCqWXbykΓ°½uº

íCbPqWYßAiqX

bykΓ°½uºíC

"" qW "$

qW:A

BC

xii IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server wPΓU

ϕ

1. ÷ Tivoli Storage Manager X . . . . viii2. ÷ IBM X . . . . . . . . . . viii3. rΘD. . . . . . . . . . . . . . ix4. Data Protection for SQL GUI \α . . . . . 255. GUI \α . . . . . . . . . . . . 286. Data Protection for SQL ⁿO . . . . . . . 397. Data Protection for SQL ≈¼ . . . . 408. ÷ⁿOCX Data Protection for SQL m . . . . . . . . . . . . . . . . 41

9. ÷ⁿOCX Data Protection for SQL ∩ . . . . . . . . . . . . . . . . 43

10. Data Protection for SQL m . . . . . 8711. Data Protection for SQL ≈½≤¼ . . . . 8812. Data Protection for SQL ∩ . . . . . 10013. Lnw∩ . . . . . . . . . . 12514. Lnw\α (¡≥ß) . . . . 12615. Lnw\α (¡yÑM≤) . . . . . 12616. Lnwα½ . . . . . . . . . . 126

© Copyright IBM Corp. 1997, 2003 xiii

||||

xiv IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server wPΓU

1 Data Protection for SQL

Data Protection for SQL iH⌡µuW≈AHb Windows NTBWindows 2000 M

Windows 2003 WⁿOµí (GUI) N Microsoft SQL Server Ω

w Tivoli Storage Manager Server xsΘCo@úUC Data Protection for

SQL ÷ΩTG

v αM@s

v S

v \α

v w

v α

v ≈ªñN

v uWí

v Microsoft Cluster Server (MSCS) N

sS

Data Protection for SQL 5.2.1 sWUCSG

SQL Server 2000 (64 )Data Protection for SQL Σb Windows Server 2003 (¡ 64 ) W⌡µ

SQL Server 2000 (64 )C\ 13ynΘ@tDzC

Windows Server 2003Data Protection for SQL Σ Windows Server 2003C\ 13ynΘ

@tDzC

yÑM≤

Data Protection for SQL 5.2.1 HiOwuyÑM≤víúyÑ

ΣCpGzQnσH&yÑAzwyÑuyÑM

≤vCσH≥íX@wCpΩTA\ 15

yyÑM≤zC

αM@sN

½nI

Data Protection for SQL 5.2.1 M Data Protection for SQL 5.1.5 P≈

RWDBíW±mAH meta eCpP 5.1.5AData Protection for

SQL 5.2.1 M Data Protection for SQL 1 úeCzúα 5.1.5 5.2.1

d" 1 ≈½≤C]ApGz" 1 ≈

½≤AzNOd 1 A@OdúAOdo≈½≤εC 5.2.1 M 5.1.5

iHM 1 PsbCMApP 5.1.5 AData Protection for SQL 5.2.1

M 1 úeCúúN 1 ⁿOµ script α½¿ 5.2.1 yk

αuπC 5.2.1 wíú N⌠≤ww 1 C

© Copyright IBM Corp. 1997, 2003 1

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

Data Protection for SQL 5.2.1 M Data Protection for SQL 2.2.x P 5.1.5 eC

Data Protection for SQL S

Data Protection for SQL i≤UzO@Mz SQL Server ΩAΣΦíO²ª≤

÷≤G

v N⌠≤ SQL Ωw≈⌠≤ Tivoli Storage Manager Server WC

v ⌡µπMºΘx≈H SQL ΩwC

v XRd≥∩ (ptºBBs@) ⌡µ≈CpΩTA

\ 3ySQL Server Ωw≈zC

v bM Data Protection for SQL (w∩ SQL Server 2000) P≈Wh SQL

Server ΩW⌡µ@C

: Data Protection for SQL C⌡µAziHs SQL Server @AúO

ⁿOµ GUIC

v ⌡µ⌠≤b¡µ⌡µⁿWΩÑq≈A¡µ⌡µⁿ¡µÑq@

(SQL Server 7.0 hiⁿ 32 ÑqA SQL Server 2000 hiⁿ

64 Ñq)C

v ⌡µww≈C\ 117² A, y Tivoli Storage Manager

zC

v ⌡µb≈½≤ñwi@Ap½stmB¿ⁿWOAHí

π≈C\ 4ySQL Server ΩwzC

v NΩw≈úP SQL ServerC

– Data Protection for SQL 5.2.1 iHwb 32 64 SQL Server

W⌡µΩw≈C\ Microsoft íσ≤AH o Microsoft ΣXC

v OdΩT≈H½ SQL ΩwApBrX Unicode

ΩTAOs ΦPΩΘWC meta ½≤ΩTP≈Ω½≤O

Odb Tivoli Storage Manager Server WC

v @ñ½≤BSw≈¼½≤Sw½≤C

v Y±ⁿw#½≤C\ 6ySQL Server ΩwzC

v ≥≤¡εMOdíAn]w≈½≤ΘC\ 21yTivoli

Storage Manager hDMzC

v d⌠≤ SQL Server ⌠≤ws Tivoli Storage Manager ServerAH o

ΩwB¼AtmΩTC\ 5yData Protection for SQL dzC

v °zL Data Protection for SQL íΘx °GR∩íΘxC

v N Tivoli Storage Manager suΩT∩]wb Tivoli Storage Manager ServerC

v ]w Tivoli Storage Manager wMα∩C\ 6yData Protection for

SQL wzC

v P MSCS M Windows 2000 OC\ 11yb MSCS W⌡µ Data

Protection for SQLzC

v bDO¼pUMO (F@DnΩw)C

v ouW%Xϕípn@Mº íC\ 11yuWízC

v °A≤ Data Protection for SQL uWíσ≤C

v yΣ

2 IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server wPΓU

|

|

|

Data Protection for SQL \α

Data Protection for SQL úo\αG

v ≈ ( 3 )

v ( 4 )

v d ( 5 )

v ( 6 )

SQL Server Ωw≈

≈Ní≈ SQL Ωwb Tivoli Storage Manager xsCΘWC

Data Protection for SQL ú∩≈εM ΦAΣO≈ SQL ΩnC

pAϕzl≈@AData Protection for SQL G

1. Tivoli Storage Manager Server lYÑq@AStorage Manager Server Q

Tivoli Storage Manager API M]tbß∩ΩTC

2. SQL Server lYÑq@ASQL Server O SQL-DMO C

3. ⁿ SQL Server SQL VDI lw∩ Ωw½≤≈C

4. q SQL Server ¼ΩANΣe Tivoli Storage Manager ServerC

5. ⌠ Tivoli Storage Manager SQL Server Ñq@C

:

1. Data Protection for SQL iHbSNΩe Tivoli Storage Manager Server

eAúY SQL ΩC

2. Meta ΩG

⌡µ≈AData Protection for SQL Od SQL Server MΩw÷ΩTC

b¿≈ßAo≈ΩTi≤dM@CΩwsMºW

jpΩTMΩwΩ@xsA@½≤C½≤iQ meta Ω

CϕubnOΩws÷ΩTAn ″meta″ ½≤C

Data Protection for SQL úFπΘx≈AúXR≈¼AϕzúQ≈

πΩwA]≈íMαDP@kúiµAo≈

iⁿ≤juCData Protection for SQL ú&≈¼G

πΩw≈

Data Protection for SQL Nπ SQL Server ΩwMí≈ú@PΩ

w¼AºΘx≈Cπtº≈ú]A⌠≤÷ºΘx

¼≈ΩTAHK¿Mσ@P≈CΘxí≈u]tq≈l

¿o!ºC

: únFc¿PÑπ≈h@≈π≈CNΩwñsΘx≈ASQL Server N@°@≈π≈C@

≈≥≈iαOπBsBC

tº≈

Data Protection for SQL u≈b SQL Server Ωwñqeπ≈M

í≈ºΘxH≤ΩCÑ≤uTivoli Storage Manager ≈O

sßvWWq≈C

Θx≈

Data Protection for SQL u≈e¿\Θx≈HASQL Server Ωwº

ΘxeC@Θx≈A²¿@≈π≈Ñ

1 Data Protection for SQL 3

≈CΘx≈qϕπ≈CtbπMtº≈Θxí≈úÑ

≤Θx≈Ct&AbπMtº≈ñAΘxúbΘx≈í@

QICMA@≈ϕπtº≈Θx≈N]AMπtºΘ

xPºCΘx≈útº≈[FªMb≥≈

MTC

: b SQL Server ⁿJWΘx≈úÑ≤b Tivoli Storage Manager ⁿ

JWq≈C

≈

Data Protection for SQL u≈ⁿw SQL Server ΦeCoi

≈Ñj¼Ωw≤PA]i²AbúPww≈í

h≈úPCΘx≈ϕBs≈A²π≈h

únC

s≈

Data Protection for SQL u≈ⁿw SQL Server seCoi²

zu≈bⁿwsñΩwϕµM'C

≈ Data Protection for SQL ≈ⁿw SQL Server sMeAH

Nª@µC

p GUI ⌡µ≈ΩTA\ 30y≈ SQL ΩwzF

ⁿOµ⌡µ≈ΩTA\ 46yBackup ⁿOz 87 6

, yⁿOµzCt\ 8yData Protection for SQL ≈ªñN

zC

SQL Server Ωw

Data Protection for SQL α oí@h SQL Ωw≈AN

ª" SQL ServerC@≈πΩw]Aπ≈ΣPÑ≈ (≤

sB≈) Heπ≈HºΘxC

∩≤AData Protection for SQL iG

1. Tivoli Storage Manager Server lYÑq@AStorage Manager Server Q

Tivoli Storage Manager API M]tbß∩ΩTC

2. SQL Server lYÑq@ASQL Server O SQL-DMO C

3. d Tivoli Storage Manager ServerAH oΩw≈MµC

4. ⁿ SQL Server SQL VDI lw∩ Ωw½≤C

5. ¼q Tivoli Storage Manager Server oΩANªα SQL Server WC

6. ⌠ Tivoli Storage Manager SQL Server Ñq@C

Data Protection for SQL úM≈Pd≥½≤¼G

πΩw

Data Protection for SQL A≤ⁿw SQLΩwπΩw≈C

tº

Data Protection for SQL uA≤ⁿw SQL ΩwtºΩw≈

½≤Cuϕ±tº≈Q (÷π≈Qºß)Aí

ε(C

Θx

Data Protection for SQL uA≤ⁿw SQLΩwΘx≈½≤C


Data Protection for SQL un≈½≤A½≤≤π≈B

s≈B≈AA≤ⁿw SQL Ωw≈C

s

Data Protection for SQL uns≈½≤A½≤≤π≈B

s≈B≈AA≤ⁿw SQL Ωw≈C

Data Protection for SQL uA≤ SQL Ωw≈½≤C

°z∩≈ªñwA SQL Ωw]\]Ah≤ Tivoli

Storage Manager Server ≈½≤C\ 8yData Protection for SQL ≈

ªñNzC

bΣe SQL Server \αΦAData Protection for SQL ]úbí

½swm\αM⌡µíIBⁿWOí≈G

½swm

i²zNOΩwsmAú²oC

íI i²zNºΘx≈Sw SQL ºΘMíC

ⁿWO

SQL Server 2000 i²zYºΘx≈YⁿWIYⁿWIº

eA\bⁿwíIºßAα²zNh÷Ωw"Pⁿ

WOC

í SQL Server 2000Ai²zN¼≈Ωw smHKsSwϕ

µ@ñΩwC

i@B÷ Data Protection for SQL \α]AUCeG

v M≈PqΩÑq≈ SQL Server 2000 iH(

ÑqC

v ²ú"eπ"C

v ⌠≤" Data Protection for SQL 5.2.1 B5.1.5 2.2 i≈

C

v wΩw NΩw (½swmwΩw N)C

v úP SQL Server ≈ SQL ServerC

v ≈½≤Ao≈½≤n" GUI z¼∩s@π

C

p GUI ⌡µΩTA\ 33y SQL ΩwzF

ⁿOµ⌡µΩTA\ 62yRestore ⁿOz 87 6

, yⁿOµzC

Data Protection for SQL d

Data Protection for SQL dúoΩTG

v d SQL Server ¼AC

v b SQL Server WCXΩwC

v CXb Tivoli Storage Manager xsΘWΩw½≤C

v ú÷≤ Data Protection for SQL ÷ΩT


|

|

v ú÷≤ Tivoli Storage Manager Server suΩTC

d SQL Serverbp Data Protection for SQL PIW⌠≤ SQL Server dú

oΩTG

v ÷≤Sw SQL Serve ΩT

v ≤ SQL Server Ωw

v ⌠≤ SQL Server Ωwtm

d Tivoli Storage Manager ServeriHd Tivoli Storage Manager Server HKCXUCMµG

v A≤Sw SQL Ωw SQL Ωw≈¼MqKn

v qSw SQL Server Q≈e Tivoli Storage Manager Server M

IWΩw

v ÷≤ Tivoli Storage Manager Server suΩT

v ⌠≤≈½≤wxstm

v ≈ñ@ñBSw≈¼Sw≈

v s

d Data Protection for SQLCXb Data Protection for SQL tmñΩC

pⁿOµ⌡µ Data Protection for SQL dΩTA\ 52yQuery

ⁿOzM 92yQueryzC Data Protection for SQL GUIAiHΓ°ABΩ

wM≈½≤÷ΩTzL≈°íMµ εíµπXCp

ΩTA\ 32y≈MµzM 36yMµzC

SQL Server Ωw

\αi² SQL Ωw≈½≤b Tivoli Storage Manager Server WQAMß[

J Tivoli Storage Manager BzCσ¼≈únoⁿOA] Tivoli

Storage Manager ⌡µO Tivoli Storage Manager hz@íC]Aq

Q≈½≤Oww≈Bz@íCData Protection for SQL iG

1. Tivoli Storage Manager Server Ñq@

2. ⁿwD@ñ½≤C

3. ⌠ Tivoli Storage Manager Ñq@C

∩≤BzαOú¼ípA\αTa@h () b

Tivoli Storage Manager Server @ñ≈½≤C]≈AData Protection

for SQLi∩ ⌠≤&≈½≤¼@@GπBtºBΘxBBs

C&A⌠≤±Yⁿw#½≤½≤¼oOiαC

p GUI ⌡µΩTA\ 37y SQL ΩwzF

ⁿOµ⌡µΩTA\ 75yInactivate ⁿOz 87

6 , yⁿOµzC

Data Protection for SQL w

Data Protection for SQL nDzn Windows zv¡αiµwC


Tivoli Storage Manager w

Tivoli Storage Manager wDA≤ Data Protection for SQLCData Protection

for SQL n² Tivoli Storage Manager ServerABϕsu Tivoli Storage

Manager Server AAϕIWMKXC

SQL Server nJΩT

ⁿw SQL Server nJΩTAData Protection for SQL úT∩G

v ⁿw] sa bßM KXC

v SQL ID wⁿw SQL WKXC SQL ID

wASQL Server zúis SQL Server nJ ID MKXC

v Hsu² Windows τnJC

: N SQL nJW Windows WsW SQL Server

SYSADMIN Tw°AñΓAData Protection for SQL αWC

Data Protection for SQL α

\h]vT Data Protection for SQL ≈MαApAwΘtmB⌠

⌠¼MeqCo]úbσ≤d≥CMAí≈P Data Protection for SQL

÷iQπαC

wG

Data Protection for SQL Oh½⌡µⁿíAªDPB⌡µ⌡µⁿe

≤ SQL M Tivoli Storage Manager Server ºíΩCYnF¿AϕY⌡µ

ⁿeΩ@ΣAhΩw QHKt@⌡µⁿh¼qt@Σ

ΩCpAY⌡µⁿNΩe Tivoli Storage Manager Server At@

⌡µⁿKiq SQL Server ñ¬ ΩCQ Data Protection for SQL tmo⌡

µⁿw qAQⁿwb /buffers M /sqlbuffers ⁿOµñCow jpib /buffersize M /sqlbuffersize ñQⁿwCp÷ΩTA\ 100y∩zC

ΩÑqG

úFbµ@Ñq@Wh⌡µⁿHFjúαH&AData Protection for SQL

O⌡µⁿΣ SQL ΩÑqA+\h¡µÑq@≈

µ@ΩwCoOt@jΩúαΦkCpGµ@Ñq@úαi

WeAh¡µÑq@iHWiΩúαA,ΣOpΩwMhΩΘ

C

pGbA≤ SQL Server M Tivoli Storage Manager Server C@ΩΘ

@ΩÑqAα (Qq≈Sw SQL Ωwí) b

*ÑqΩñπX∩ (j MQΩÑq¿±íA≤

m¡εMQ⌠⌠AHb SQL ServeBTivoli Storage Manager Server M Data

Protection for SQL ñB&WÑq)CpⁿOC⌡µÑqΩ

TA\ 114 C


|

:

1. ptΩMOΘBCPUB⌠⌠dB⌠⌠B¬ gJmM RAID

t¡ε¿íM¼AeqWX¼AAB&ΩÑqú@w∩α

BYεαC

2. pM SQL w sÑqAnTⁿw SQL w MÑq

@j±ªjC

3. Data Protection for SQL ⁿww Bw jpMÑqw]iαb Data

Protection for SQL tmñQ≤C set ⁿO GUI sΦ\αϕ ∩tmC

Ωm

Microsoft SQL Server 7.0 ' VDI ≈MΩwCData Protection for SQL

wRWD¬αNΦAⁿWDM¡°A

@C

LAN-Free (LzL⌠⌠)

bS LAN-Free ⌠⌡µ Data Protection for SQL iK⌠⌠¡εCb Data

Protection for SQL ∩ⁿw enablelanfree yesCp]w LAN-Free ⌠÷

ΩTA\ Tivoli X IBM Tivoli Storage Manager for Windows xsΘNz

íΓUC

Data Protection for SQL ≈ªñN

°z∩≤⌠⌠yqB≈°íMiⁿíSwDwAziH∩ϕ

úP≈ªñCí≈@PªñípUG

π≈

ΦíDA≤p SQL ΩwA]ªN²CπΩwQ

≈C⌡µC@π≈ßíU°A²BzOvC]

± (ΣªAϕ) π≈nQC∩≤tΩwÑ (pA

masterBmodel msdb) oOAϕªñA]qΣjppC

πΘx≈

ϕ@δ≈°í⌠⌠eqúαCΣπ≈ANπ

ºΘx≈ªñCboAt@tCΘx≈wπ≈i

≈°íM⌠⌠yqpCpAiHbg,⌡µπ≈b¡⌡µΘx

≈Cϕj≈°íMW[⌠⌠yqiQⁿ¼pUAπ≈iH

bCí¿CMABzo≤°AoO]n

π≈Hß≥Θx≈C

: i⌡µíIANºΘxⁿwΘíC

tº≈

bπ≈ºí⌡µ≈¼CtºΩw≈iHíMíA]

Oqeπ≈ßAΩwñwQ≤∩í$í (ªO[)AB

ΣíO]@íiKMOΘx≈AGí(C

Φk]Ab@WF²uetº≈ (s) nQC

pGí±≈í≤½jAiαNn SQL Server 7.0 tº≈CM

A SQL 7.0 @tº≈\ß±Θx≈n°íAB±w

°AYeπ≈ºßΩwu≤F@IICoO] SQL 7.0


BzΩwC@AHMwONª]Abtº≈C≤ASQL Server

2000AhO²eπ≈ñΩww≤ºA²únBz⌠≤ú

]Abtº≈C

πBttºΘx≈

ªñ"ε(iαnQMºΘxAKi[tC

pACg¿@≈π≈AC¿tº≈AHC-p¿Θx

≈Aiα]Aπ≈Btº≈AHh¡≈Θx≈CMA

bP⌠Wπ≈[Θx≈ΦAiHnD@π≈[

Wh-Q@Θx≈ (6 # 6 Θx≈[Wπ≈Q¿# 5

≈≈)C

s≈

ϕ]Ωwjp±HíMαDúα≈πΩwA

≈ªñCNAϕ⌡µs@AnúO

ºΘx≈C

s∩]iH≈MíAíbϕYϕµ'

h≤sBnQ≈CNoΩ±mbªvs

AMßuN≈Ao@kOπívC

ΣLªñN

∩A≤ SQL Server ≈ªñ ( Data Protection for SQL 5.2.1 ) AU

CMµú@NΣLΩTC

í

v p SQL Server o!DAuWiH

íC

v hΩÑqiH[t≈íCp≈xs

CΘApaxsA¿qhÑqANpha≈@δAa

≈Qtm SQL ≈FhAOÑq@εCHÑ@aCH

SQL Server 7.0 ÑAΩÑqM≈PC

v ΩúYNε(⌠⌠yqMxsΘDCMAW[εC≈í

n°]wAo]]ABzúYtMi⌠⌠WeC

Ht⌠⌠ÑAúYW[≈úYCpΩTA\

18 C

ΩÑq

v pGΩÑqA]Nn Tivoli Storage Manager Server

ítmAHKCÑqOsbúPxsΘC Tivoli

Storage Manager ⁿO update stgpool H]wCún+\ meta

Ω (QpOí) iaCΘC

v iHΩÑqj± SQL Server ΣjpA

B± Tivoli Storage Manager Server txngroupmax ∩(A∩b dsmserv.opt ñCSQL Server 7.0 hiⁿ 32 ΩÑqA

SQL Server 2000 hiⁿ 64 ΩÑqC

O pGFΣ Microsoft Cluster Server OAbCOI

w Data Protection for SQL Bntm@@Cn¿w⌠

nB&]wCz"Ω°AWhOwO SQL ServerA

b Data Protection for SQL Ws SQL ServerC


|

|

|

|

|

|

pΩTA\ 11 yb MSCS W⌡µ Data Protection for

SQLzC

bdIIΘx∩G

ϕ∩u⌡µb SQL π≈A]iHⁿXbdIºßzQnIΘxC

oN εΘxbL¡ípUjC

IΘx∩

ϕ∩⌡µºΘx≈AiHⁿXzúQIΘxCqϕ½ lΩ

wAzúQnIΘxC∩i°ANºΘx≈A²ú

H⌠≤Φíh ΩCªgJeΘx≈íΩw lI

ºΘxCH SQL Server 7.0 ÑADnsOis C

m pπBtΘx≈ªñAMwOn ∩ Tivoli Storage Manager

xsΘzhHTwΘx≈Q@xsb Tivoli Storage Manager

ServerC"ε(CΘⁿiU∩αAoCΘⁿO@

tCΘx≈úiCpmΩTAó Tivoli Storage Manager

zC

h SQL ServerG

v ph SQL Server Ωb⌡µAB&Ω÷WOC

b Data Protection for SQL Ws SQL ServerC

v pQnNY≈≈úP SQL Server °AAhb SQL Server 7.0

ñA°AMl°APBrXAHUnicode tmF

hASQL Server 7.0 NoXTºC

hG

v maxnummp AoOb Tivoli Storage Manager register node update node ⁿOAF+\IhbiúCΘ (ªnhQ

tmIWⁿI) WxsΩhÑq@C

v ≈OFSϕípCpG.ΓTw≈sMANª

O≈AFbzOα¡εC

v úα≈ tempdb ΩwCªO sΩwACϕ SQL Server QA

sΩwQ½C

v SQL ΩwπbdIIΘx∩ (master msdb) SQL Server

2000 µ"íúiHQ≈ºΘxC

v úΩw≈Wvp≤AbjPzAbC≈ΩwºeA

lbΩwW⌡µ dbcc checkdb M dbcc checkcatalog HdΩw ΦΩΘ@PCp÷≤ SQL Server Ωw@Pdí

÷ΩTA\z SQL Server íσ≤C

v Data Protection for SQL ú SQL Ωw≈M\αM÷º

ΘxCMA Data Protection for SQL ¡úúA≤ SQL Server

πa"MΦC\hΣªO SQL Server w⌠@í

Conba"¼pUQ"CopGi⌡µMt

mC@δ Windows Tivoli Storage Manager ≈OsßA

P Data Protection for SQL @ftAYi oπa"peC

p SQL Server ≈ªñMWΩTAd\ Microsoft SQL Server íσ≤C


|

|

uWí

Data Protection for SQL úziHq GUI °uWíC∩ GUI uπCW

í ->eAHKuWíCuWí]AHU÷ΩTG

v p≤tm Data Protection for SQLC

v p≤≈BΩwC

v ÷≤ Data Protection for SQL [ ΩTC

Data Protection for SQL ]úFwPΓUuWA HTML PDF

sµíCoQwb Program Files\Tivoli\TSM\doc ²UC

yΣ

Data Protection for SQL ΣUCyÑG

v ⁿíσ

v /Φσ0σ

v kσ

v wσ

v qjQσ

v Θσ

v σ

v Θñσ

v ΦZ0σ

v cΘñσ

pGzQnσH&yÑAzwyÑuyÑM≤vCpΩ

TA\ 15yyÑM≤zíC

b MSCS W⌡µ Data Protection for SQLData Protection for SQL Σ SQL Server b MSCS ⌠ñ⌡µCw∩ Windows 2000

M Windows 2003A Data Protection for SQL Active Directory ΣO

CUCMµúb Microsoft Cluster Server ⌠W⌡µ Data Protection for SQL

nNΩTC

v ñ÷≤ SQL Server ΩⁿOM≤b MSCS ⌠Ω SQL Server

WC

v bOIWw Data Protection for SQLC&Aϕw Data Protection

for SQLANªwbC@IW (úOb@"O)C

v b Data Protection for SQL ∩ñⁿw clusternode yesC

v bOCIWtm Data Protection for SQL A≤ Data Protection for SQL

∩ñPtmC

v pG≈ Tivoli Storage Manager ANAíwbO

ΓΣIWAHKΣCp÷ΩTA\ 117² A, y

Tivoli Storage Manager zC

v Tivoli Storage Manager Server °≈≤µ@°A (Ω°A)Aú≈O

bOIW⌡µC

q GUI s MSCS ANUCΩTG


|

|

|

|

v /sqlserver Is GUICpApGbz MSCS W SQL Server W

O sqlvs2A≥ GUI IsOG

tdpsql /sqlserver=sqlvs2

v pGzObα½¿ Microsoft Cluster Server ⌠ºew Data Protection for SQLA

n ∩ Data Protection for SQL GUI íulv\αϕCziH"s

W /sqlserver tdpsql Is⌡µ@CpApGww Data

Protection for SQL w]mABΩ SQL Server WO sqlvs2AznN

∩G

"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe /sqlserver=sqlvs2"

pGzπ ACTIVE/ACTIVE SQL Server O⌠Aw∩C@ib≈⌡

µΩ SQL Server ulv\αϕC


2 w Data Protection for SQL

ú Data Protection for SQL DΩTAQí≈bwNn∩C

Data Protection for SQL ibUCM≤ñ oG

πIO

M≤]tv≤ABM≤Oπµ≈úC

í (PTF)M≤ú]tv≤CªO≤wb Data Protection for SQL ²ew

WC

M≤]tv≤A+\ 60 #wPC

Data Protection for SQL ≥D

úw Data Protection for SQL nΘB@tBwΘqTΩTC

÷≤ Data Protection for SQL 1 ewDA\ 1y

αM@sNzC

nΘ@tD

Data Protection for SQL ΣUCnΘ@tXG

SQL Server

@t

Windows NT4(SP5+)

Windows 2000(SP3+)

Windows 2003(32 )

Windows 2003(64 )

S Q L S e r v e r 7 . 0

(SP3+)

O O

SQL Server 2000

(SP3+) (32 )

O O O

SQL Server 2000 (64

)

O

:

1. Windows Server 2003 (64 ) WúΣ Data Protection for SQL 2.2 B5.1.5

5.2.1 (32 )C

2. pGbP≈⌡µ SQL Server 7.0 M SQL Server 2000Aiαo!≈óC

\uMicrosoft wvσ Q280759Aª≤G

http://support.microsoft.com/support/kb/articles/q280/7/59.asp

3. n Tivoli Storage Manager ≈Osß 5.1.5 (≤s) HQ Tivoli

Storage Manager Ma"peC

wΘD

UCOnwΘG

v Intel Itanium Itanium II 64 Bz


|

|

|

|

|

|

|

||||||||

||||||

||||||

||||||

|

|

|

|

|

|

|

|

|

http://support.microsoft.com/support/kb/articles/q280/7/59.asp

v 48 MB RAM (jP 96 MB ¬≤ 96 MB RAM)

v 12 MB ií

: pGzqlUⁿµ@ .exe wAb Windows tM s²ñnB&

X MB iíCBúYnB& su@íC

psΩTA\úwCΘñ readsql.txt C

qT

Data Protection for SQL M SQL Server wbP≈WCData Protection for

SQL Tivoli Storage Manager API M Tivoli Storage Manager Server qTCData

Protection for SQL ] SQL-DMO SQL-VDI M SQL Server qTC

Data Protection for SQL iPb⌠≤Σ@tW⌡µ Tivoli Storage Manager

Server 5.1.0 (≤s) qTC Data Protection for SQL Mww Tivoli

Storage Manager API hΣPqTΦkC Tivoli Storage Manager

Server HMwªΣ≤qT≤wCTivoli Storage Manager Server iP Data Protection

for SQL ≤búP≈WC

w Data Protection for SQLπzMvbßN Data Protection for SQL wtWC

NwG

v w]w²O c:\Program Files\Tivoli\TSM\TDPSqlCpGz≈Wwsb Tivoli

Storage ManagerAhú≥⌠ (c:\Program Files\Tivoli\TSM) ¿w]

w²CbjPN Tivoli Storage Manager úM≤wbP≥

²UC

v pGtW Data Protection for SQL 1 h Data Protection for SQL 5.2.1

wbúP≤ 1 l²CpGzb" Data Protection for SQL 1

≈½≤ANN 1 OdMOdo≈½≤@[CData

Protection for SQL 5.2.1 ú g Data Protection for SQL ∩Btm

ΘxC

ϕUCⁿw Data Protection for SQLG

1. N Data Protection for SQL 1íJ1≈C

: Windows InstallShield WizardCpG⌡µíLkA⌡

µUCBJG

a. qulv\αϕ∩ u⌡µvC

b. ΘJ x:\setupAΣñ x ONϕ1≈r$C

c. ÷@UuTwvHwíC

A]iHqzñ÷ΓU setup.exeC

2. ∩ wyÑC

3. °íúWπwⁿO⌡µC

4. ÷@Uu¿vH¿wC


|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

|

yÑM≤

YnσH&yÑ° Data Protection for SQL GUIBⁿOµΘXMTºAw

ú CD-ROM WzQnuyÑM≤vCuyÑM≤vObú CD-ROM W

TDPSql\win32\languages\xxx ²i⌡µCxxx ²NϕPyÑ÷Tr

$ΩXCwuyÑM≤vßAUCΣñ@ΦkA≤s Data Protection for SQL

tm (w]A tdpsql.cfg)AyÑC

v set ⁿOft language ⁿwzQnyÑCpG

tdpsqlc set lang=fra

piyÑΣTr$ΩXMµA\ 96 language íC

v ∩ sΦ->tm->->yÑAH Data Protection for SQL GUI ñutms

ΦvC uGUI tmsΦvNH°µíπwwyÑCpG

σ (ⁿΩ)

¿wAG

v Tivoli Storage Manager Server n²qu@CpΩTA\ 17

y Tivoli Storage Manager Server n² Data Protection for SQLzC

v tm Data Protection for SQLCpΩTA\ 18ytm Data Protection

for SQL ∩zC

b MSCS ⌠ñw Data Protection for SQLb MSCS ⌠w Data Protection for SQL nUCUG

v pGzbwO SQL Server Data Protection for SQLAzb MSCS

ΣIWw Data Protection for SQLC

v pGzObα½¿ MCSC ⌠ºew Data Protection for SQLA ∩ Data

Protection for SQL GUI íulv\αϕC"sW /sqlserver tdpsql ⁿOIs⌡µ@CpApGww Data Protection for SQL w

]mABΩ SQL Server WO marssql1AznN ∩G

"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe /sqlserver=marssql1"

pGzπ Active/Active SQL Server O⌠Aw∩C@ib≈⌡µ

Ω SQL Server ulv\αϕC

2 w Data Protection for SQL 15

|

|

|

|

|

|

|

|

|

|

|

|

|

3 tm Data Protection for SQL

Tivoli Storage Manager Server n² Data Protection for SQLbnDAºeAData Protection for SQL IW Tivoli Storage Manager Server

n²C Tivoli Storage Manager z@≤e÷AbQ Data Protection

for SQL Iu≤ SQL Server ≈CTivoli Storage Manager IWM

KXP Windows ID KXΦíPC

Tivoli Storage Manager zN Data Protection for SQL n²°Aß

ICz Tivoli Storage Manager zwqUCΩG

v z Data Protection for SQL IW

: pGzb Microsoft Cluster Server ⌡µ Data Protection for SQLAIW

úαqúWC

v lKX (°ípn)

v Data Protection for SQL h⌠

ph⌠÷ΩTA\ 21yTivoli Storage Manager hDM

z C

v Tivoli Storage Manager

v OtmⁿI (a≈) zI

oO"n²IⁿO maxnummp ¿CpGQ SQL ΩÑq

AµΩÑqaxsAhN]wj≤w]

1C

v O≤°AºeúYC

tm Tivoli Storage Manager Serverb Tivoli Storage Manager Server iHq SQL °A¼Ωw≈e Tivoli

Storage Manager IATivoli Storage Manager Server z⌡µUCtmⁿ

OG

v register update node backdelete O yesCw]O noC

v ϕiúCΘ (pa) b≈@í⌡µαA register update node maxnummp (O≈ºÑqjCw]O 1Cow]OI@αⁿIjCpGΣª≈

Po!Aj¼≈eíⁿIC

v define stgpool collocate Q] filespaceAHTOOΩÑq

dbOiúCw]O noCpGúo≥Aiαn@A

HC≤ÑqΩiPQs C

v L≤CΘATivoli Storage Manager Server ∩ (qO dsmserv.opt) ñ

txngroupmax ∩AΣ(j≤n≤≈@ºÑqW¡Cw]O 40C

v A≤ Data Protection for SQL meta ΩzOAM∩zOPA

zOA≤ΩwΩAúF meta ΩzOúⁿiúCΘC


pG⌠≤ Data Protection for SQL meta ΩObiúCΘAd]\nCΘ

ⁿAB≈]\nB&CΘⁿCpzO÷ΩTA

\ 21yTivoli Storage Manager hDMzC

: ϕj¼ SQL ΩwAb commtimeout ∩ñⁿw( 10000 AN

U≤K@ú¡⌠CpGObL LAN ⌠ñ⌡µ@Ah

∩uxsΘNzvⁿwoC

tm Data Protection for SQL ∩

@2 Data Protection for SQL Qn²b Tivoli Storage Manager ServerA Data

Protection for SQL QtmCTivoli Storage Manager zúzIW

BKXqTΦkAHiHs Tivoli Storage Manager Server AϕC

oMΣª@Qxsb Data Protection for SQL ²U∩Cw]∩

WO dsm.optCF ∩l dsm.opt AiσrsΦπ dsm.opt C

∩]AUCAoOltmnG

nodenameTivoli Storage Manager IWO@WA Tivoli Storage Manager "

o@WD⌡µ Data Protection for SQL ≈C

servernameoO Tivoli Storage Manager Server WAzN SQL Ωw≈C

commmethodqT≤w Data Protection for SQL IP Tivoli Storage Manager ServerC

Data Protection for SQL iΣΣL Tivoli Storage Manager ßΣ

PqT≤wC

UCB&∩úOltmnCw]ípOúⁿwA²ziH ∩w]]

wG

passwordaccesspasswordaccess generate ]wⁿ Tivoli Storage Manager API xsb

Windows n²µKX (w[K)ABϕµKXAsKXú

!Cϕb⌡µwwB≈AKXzΦkA]ªiTO

≈ú]KXóCw]O promptC

dsmcutil.exe íi²zz (≤sπ) xsbn²KXCo

íPuTivoli Storage Manager ≈OsßvM≤@teCp

dsmcutil í÷ΩTA\ dsmcutil.hlp dsmcutil.txt Ao

PuTivoli Storage Manager ≈OsßvM≤@teC

compressioncompression on ]wⁿ Tivoli Storage ManagerAPI NΩe Tivoli

Storage Manager Server ºe²úYΩFo≥ε(ΩyqMOΘ

DCpGzúYAªHΓΦívTαG

v CPU vb⌡µ Data Protection for SQL ≈W¬C

v ]eε(AH⌠⌠WevεCC

v ε( Tivoli Storage Manager Server WxsΘC


|

|

|

|

|

|

YHU⌠@ípAz]\QnúY\αG

v ⌠⌠dΩWⁿC

v Data Protection for SQL M Tivoli Storage Manager Server ºíqTOC

WesuC

v ⌠⌠yqjC

NG

nbUCñ]w compression offG

v b⌡µ Data Protection for SQL qú CPU WⁿíFW[ CPU

ΣªíA]A SQL ServerCziH Windows

Huα °ví ° CPU M⌠⌠ΩvC

v zúQ⌠⌠We¡εFbípUAziH]w compression off

ba≈WwΘúYHFαAo@]iHε(OΘ

DC

: ϕn²≤sIATivoli Storage Manager ziHm½ Data

Protection for SQL IúY∩]wAΦkOb Tivoli Storage Manager

Server ⁿwSwIG

v 3úYC

v 3úúYC

v ßMª (w])C

clusternodeb MSCS ⌠ñ⌡µA clusternode yes ]w Tivoli Storage Manager

API Data Protection for SQL iOC Data Protection for SQL

ⁿw∩AHKb MSCS WAϕaB@C

enablelanfreepGz.Γo≥@Aenablelanfree yes ]wi² Data Protection for SQL

bú LAN ⌠U⌡µC

:

1. pGzb MSCS W⌡µ Data Protection for SQLAbOΓIñ∩

PC

2. ziHΣL Data Protection for SQL ∩HKⁿVΣL Tivoli Storage

Manager ServerCz]\Qn@HW∩ABC∩úP

AHPµ@ Tivoli Storage Manager Server ftC

]w

hAData Protection for SQL i+\z Tivoli Storage Manager M

εC¿]w≈ΩhOzL Data Protection for SQL ∩C

b∩ñ include M exclude »zíwqXBzANSwzOⁿw½≤RWDC

: zTwi≤d meta ΩúPⁿCb Tivoli Storage

Manager Server WAmeta ΩQxsYΩ½≤AB meta ΩiHα

iúCΘApGªh+\o!C

Data Protection for SQL ≈½≤WO"@tCH \ j¡w¿C

3 tm Data Protection for SQL 19

|

A≤½≤RW@δ include/exclude ykOG

include "objectNameSpecification" [ManagementClassName]exclude "objectNameSpecification"

ΣñG

objectNameSpecification OG

SqlServerName[\InstanceName]\dataType\...\DatabaseName[\typeInfo]\backupType*

dataType OG

meta | data

typeInfo OG

LogicalFileName (≤ file ≈¼)

GroupName (≤ group ≈¼)

... (≤ log M set ≈¼)

D≤ full M diff ≈¼

backupType OG

full | diff | log | group | file | set

NG

v Ur * Xs≤hrCUr ? X⌠≤rC

v b¡wUr * α N¡ws≤hr²C¡w¡sb≤X½≤WC

v FXs≤h¡wAnñG\...\

v WµHUr * ⌠CoO]WµX½≤WM sWCpGo!A sWQ" (roll back) Y≈ºC sWOt

@rΩ½≤WArΩ[ backupType ¡wC

v objectNameSpecification Q±mb'CpGWµ]AµSϕrN

n'C

v Y exclude »zíAmeta ObWµñXAoONqTHUrñϕCú meta úoπ½≤C

v include »zíαOaMTaⁿw meta dataAOUrñⁿw meta dataC

v ziHb include ∩Mµⁿw data M meta ½≤AHKαⁿwzOCMA

ϕ exclude »zíAⁿw meta ½≤CpGS≈ data ½≤Ahú

ª meta ½≤C

v log M set ½≤W3O@CtypeInfo ]t¡wA¡wª¿

@C]ªOb≈Qú!AHªLkQwB]úαⁿwLC

v qUWBz Include/exclude MµABBzbo@XN

εCFTw≤hSwWµ@wQBzAbCX≤hSwWµºeAC

X≤h@δWµAHbSwWµºßo@δWµNQBzChAb≤h

SwWµQºeA≤h@δWµNXC

– ΣXAεMµBzBdX»zíCpGªO

exclude »zíANú≈X½≤WCpGªO include »zíAN

≈X½≤WCpG i n c l u d e »zí]AzOW


(ManagementClassName)AzOMo≈W÷A≈WA≤

o≈≤AHIWPW≈C

– pGΣúXAIw]zO≈½≤C

– pGΣXA≤ include ( include ⁿwzO)A²ⁿwz

O∩ILANA≤Iw]zOC

v Include/exclude Bzúú!LWµTºC]AzJa

include/exclude MµCⁿwLzOWNb dsierror.log ú!TºC

v ÷≤jpgAWindows Tivoli Storage Manager API eA≤ Windows

tWµBújpgCMA ]*jpgrΘ≤Az3

TjpgrΘC,ΣA

– SQL WTjpgrΘ (°ABΩwBsW)ApP" querysql query tsm ⁿOπC

– Data Protection for SQL pgG metaBdataBfullB diffBlogBgroupBfile setC

UCOO objectNameSpecifications dA]ª]\Xb include/exclude »

zíG

SqlServerNamesGSQL70BSQL2000

InstanceNamesGINST1BINST2

DatabaseNamesGDb1BDb2BDb3

GroupNamesGg1Bg2Bg3

LogicalFileNamesGf1Bf2Bf3

÷ include M exclude »zíWCykπdA\ 131²

C, yiÑzC

Tivoli Storage Manager hDM

Data Protection for SQL RW Tivoli Storage Manager Server Wxs≈½≤Φí

P 1 ΦíjúPCo≤OFα≈Q Tivoli Storage Manager

Server úh¼\αC]AúnP Data Protection forSQL 1 PzOCUCOeh]wC

Oss

Data Protection for SQL xs½≤@b Tivoli Storage Manager W

≈½≤AoO≤≈OΘxsñAHúnOssAY

sbC

ε

Fwq SQL Ωw≈½≤¡εMOdíAz]wUCs

G

v versions data exists


v versions data deletedv retain extra versionsv retain only version

s

]ªúA≤ Data Protection for SQLAHⁿ≤UC≈

sw]G

v copy modev copy serializationv copy frequency

Log M Set

] log M set ½≤3O@WA¡εtGªúDCMAData Protection for SQL SQL Ωw≈½≤Aú

MCϕ⌡µ SQL ΩwsπΩw≈A]C]AOdí

O" retain only version wqAOdí εΘxM≈CqúWL@HWΘx (Log) (Set) ½≤sbC

NG

v ϕΘx≈∩ retain only AnTwª(PΘx÷≈½≤ϕCz]iHPzOAzOA≤Θx≈M≈½

≤A½≤OOd[HTwzAϕC

v ≈OFbúMµ@¼pC (pΩTA\b 87

y≈½≤¼zñ÷≤'@ºsNC)

v pGzúµÑU@πΩw≈AziHTa⌠≤Sw@

ñ½≤ (pGúAnª)A±⌠≤ⁿw# (oO inactivate ⁿO) [@ñ½≤C

Meta M Data ½≤

Data ½≤MΣ÷ meta ½≤P¡εMOdCMA]

meta ½≤]\nQ¿Y Data Protection for SQL dGAz]

\uQb≈xsΘxsxs meta ½≤AoCΘⁿNúRd

Cno≥AziHG

1. wqt Copy Destination OzOA Copy Destination ⁿV

xsAxsÑhñS⌠≤iúCΘC

2. s meta ½≤zOAzOb Data Protection for SQL

∩ñ include »zíC

ps≈½≤SwzOi@BΩTA\ 19y]w

zC

OAziH∩A≤ meta M data ½≤PzO (MOΘxs

)ApGzXGún meta ½≤AuϕⁿnªY⌡µY

C

: b\hñA]iHq SQL Server ≥o meta ½≤ΩTAªO²b msdb

ΩwñC


ΩÑq

pGzΩÑqAC≈ÑqP¡εMOd

AHTwµ@ Φ≈½≤YíúbΣL Φ≈½≤ºeL

C

m

µ@Bπ]\n@≈πΩw≈B@tº≈MhΘx

≈AO@HWsB≈HhΘx≈Cz

mApGo≈QxsbiúCΘC

pGzΩÑqA÷xsΘxsWít

mAH@OxsΘWÑqC+\P¡µCÑq

s v¡OnCpGhA≤P½≤hÑqbP

⌠ (]ú¼)A Tivoli Storage Manager Server move data ⁿOiH½≤xsΘxsAxsΘxssWs

AHi¡µs ΩÑqC

pwq≤sh⌠Ms÷ΩTAóz Tivoli Storage Manager

zA\z°A¡xº Tivoli Storage Manager zΓUC


4 í

í Data Protection for SQL GUIC GUI ⌡µUCG

ϕ 4. Data Protection for SQL GUI \α

GUI \α

q Data Protection for SQL \αϕMuπC∩ \αC 25

∩ π SQL ΩwΩTC 28

≈ SQL ΩwC 30

SQL ΩwC 33

SQL ΩwC 37

GUI º[

Data Protection for SQL GUI @D°íAϕñt@δ\αϕCBuπCAH¡

n°íGΓ≈@°íBΓ@°íM@@°íCC@°

ít@≡¼² ε (b¬íµ) H@ ε (bkíµ)A ε

]A@ εM@πΩTMµ εC

\αϕC

\αϕCtUCM\αϕMµG

⌠í

sΦ tm Data Protection for SQLCw]tmO tdpsql.cfgC

° ½sπz≡¼°eπC

í

≤ Tivoli Storage Manager KXB]w SQL Server nJΩTAπ Tivoli

Storage Manager Server M SQL Server Γ°AΩTC

í o Data Protection for SQL íBuWyBTivoli Storage Manager Web

s AH Data Protection for SQL ÷ΩTC

sΦ\αϕ

tm i²z ∩ Data Protection for SQL tmCY*ⁿwtmA

tdpsql.cfg CpGΣútmAhut lastprunedate w]F

ΣL∩w]CiqⁿOµⁿw /configfile Is GUIA

ⁿwúPtmC

÷@U\αϕπu Data Protection for SQL ]wv∩Aϕñt

UC-Σ]wG

1. @δ

v SQL Server

v q SQL Server

v SQL τ

– πX (w])


– SQL ID

: pGzb∩ SQL IDAnsΦΣw] ID MKXAh

zzLuív\αϕnJ]wiµC

v Ñuaⁿv≈ (w])

v w⌠tº≈≤ % (w] 20)

2. α

v TDP w (w] 3)

v TDP w jp (w] 1024)

v Ñq (w] 1)

v SQL w (w] 0)

v SQL w jp (w] 1024)

3. Oⁿ

v ΘxW (w] tdpsql.log)

v R∩n² (w]∩ )

– Od# (w] 60)

– YR∩

4. a

v yÑ (w]ⁿíσ)

v Θµí (w] mm/dd/yyyy)

v íµí (w] hh:mm:ss)

v Xµíúw] xxx,xxx.dd)

pMotm]w÷πΘNA\ 95ySetzC

°\αϕ

½sπz≡¼°e

½sπz GUIAziHG

v Mú⌠≤∩C

v ¼X≡¼czw2 hC

v ¼X∩≡¼cAYLeSQπX (pA½sπz

≈Ωw≡¼c½sπz≈s/≡¼c )

v b≡¼cñπs≈@C

: pGzb"S½sπzAzú≥óµ∩≡¼°eC

3∩sW ε≈°íAi²zb Tivoli Storage Manager

xsΘ SQL ΩwC

í\αϕ

≤ TSM KX

∩úzΘJKXMs≥ΘJΓsKXHτsKXCt\

99yCHANGETSMPasswordzC

SQL °AnJ]w

uSQL °AnJΩTv∩i²z∩ UCUG


v Windows τ (w]∩ )

v SQL τFpGz∩ o∩Az±g ID (w] sa) KX (w] )C

t\ SQL τ (q 110 l)C

π TSM °AΩT

°íπUCusuΩTvG

v IW

v °A⌠⌠D≈W

v Tivoli Storage Manager API

v °AW

v °A¼

v °A

v úYí

v ⌠W

v @ñh

v w]zO

π MS SQL Server ΩT

°íπUC SQL Server ΩTG

v SQL Server W

v

v O

v w] ID

v w]rX ID

v Unicode ID

v Unicode ±í ID

í\αϕ

Data Protection for SQL í

∩uWíC

uWΓU

∩ Tivoli Storage Manager M Data Protection for SQL uWΓUC

TSM Web s

∩ Web s²H° Tivoli Storage Manager uWΩTC

÷≤ Data Protection for SQL∩BAH Data Protection for SQL qhΩTC

uπC

uπCúgC-i÷sG

v ½sπz≡¼c

v sΦ Data Protection for SQL tm

v s Tivoli Storage Manager Web

v uWΓU

4 í 27

≈°í

Data Protection for SQL úO°íiµ≈@AC°íúv≡

¼cBMµAH εCb 1A≡¼c (SQL Ωw) eú]w

∩ ≈≤C]A"l∩ (½sπz) úd

GuQΣJbñ≈MµC]Au εMµ∩ C

&AQRúΩwúπb≡¼cAd÷sO≡¼c÷

sC

Data Protection for SQL úT≡¼cΩwWFMµ επ≡¼

°eñQ2 ΩTCY≈@AData Protection for SQL b≡¼cπA

²CΩwWu@n²CMAb≡¼cC@ΩwW∩

≈½≤AB@ΩwW]\h≈½≤CziHq≡¼cMMµ

εs@≈C

:

1. GUI ßl°íO≈°íA,ΣⁿO≈Ωw°íC

2. zúαµWaqD°í÷¼BYpA≈°íC

XR≈∩FΣ Data Protection for SQL XR≈∩AData Protection for SQL GUI ú

Au¡≤bΩwMΘxAΘxi°pi∩ ≈µCbziH∩

s≈ (ΩwYí)A≈ (sYí)Atº≈ (Ωwñw

≤)CData Protection for SQL ]ⁿ≈jεµ@ Tivoli Storage Manager ½

≤A½≤]AA≤ϕYípnosSwC

÷M⌠≤uΩ°í≡¼cMµúoúA²C°íkíµϕπ

≈A (LO≈°í) °ew∩ \αwC¡iQ

∩ G

ϕ 5. GUI \α

∩ \α

≈Ωw ⌡µπBtºΘx≈C 30

≈s/ ⌡µsB≈C 31

Ωw qπBtºΘx≈ñC 33

s/ qπB sBBΘx≈ñC 33

úFAiH∩ A≤Sw½≤C 37

∩ΩwMπΩTkíµCñAMµ εú÷≤b≡¼c°²U2 ∩

ΩwΩTCuϕªb≡¼cñ]Q∩ (wQ∩ )AP

≈@C≡¼c ε∩ ΩwπΩwΩTA⌡µUCU

G

1. l²i≡¼c²AQ÷ΓU SQL Server I≤ DataProtection for SQL ≈ Data Protection for SQL IºU SQLServer IWA÷@U[i≡¼c²CMßX SQL Server W

Ω¿C


: pGúP SQL Server Ω≈½≤sb≤PIAh°AW]

\Xb≡¼cA²zúαF≈@ GUI %½°AΩC

2. ÷ΓU°AWΩ¿∩ AO÷@U[ú+) i°AWΩ

¿Ci≡¼cπ≈½≤Ai≈≡¼cπb SQL

Server WΩwC

3. Q÷@UΦ∩ W2 ≡¼cñΩwΩw½≤C2

π÷≤MµñⁿwΩTAYb≡¼cñ*QiCn

∩ªiµ@Au2 Wú∩ ªC

: úF≈Ωw≡¼cAziH≥i≡¼°eHπΩw

≤ApsMC≡¼cNq≈@ñπ≈½≤

¼Cb≈Ωw≡¼cΩwúnil²C

4. Q÷@U∩ ∩ HPY@CXbΓ⌡Γ3ⁿ

YwQ∩ C÷@Uo∩ iµ%½AziHG

v ∩ ª (pGoºeSQ∩ )C

v °∩ ª (pGºeªwQ∩ )C

:

1. zúαbMµñh²°∩ F@uα2 @²CFαqh

Ωw°∩ Ab≡¼c2 z SQL Server WC

2. Ωw∩ O"WUVUÑh+F]NOíAªl²úQ

∩ C∩ s]nP∩ ªC&Aϕ∩ l]n∩

¡CRúBJτPC

3. ϕzFY@u∩ ΩwYí≈A≥bª⌠ñCNϕo

u@b (í≈) Q∩ C

4. ≈@ñLkAb∩ Nπ¿ XC

5. OuúivNb∩ ñπ ! orABLk∩ C

6. ]zwgⁿw sqluserid SQL τΦkAbz Data Protection for SQL

tmAϕzi SQL Server IAX SQL nJΩT (SQL z ID M

KX) úAH]ΩTúαbnJñQMΣCData Protection for SQL

bⁿw SQL Server WnJCpGz*ⁿOCΘJ°AWAnJ

Nw]b SQL Server WCpGnJóAzQnD⌠M½sΘJ

/sqlserver ∩íCnJΩTxsbn²ñC Data Protection for

SQL GUI ÷¼AzN@nJb SQL °AWC

7. pGzwgbPIW@HW SQL Server ≈ΩA≥ΣL°A

πb≡¼cñC

8. F°úPIW≈AznⁿwúP dsm.opt (ziH

/sqlserverB /configfile /tsmoptfile )CúP∩ /tsmoptfile ]iH°búP Tivoli Storage Manager Server ≈C

4 í 29

≈ SQL Ωw

ϕUCBJ≈ SQL ΩwG

1. Data Protection for SQL GUIC

: pGzb MSCS W⌡µ Data Protection for SQLAzqⁿOCH

/sqlserver Is GUICpΩTA\ 11 C

2. °zQn≈¼A÷@U≈Ωw≈s/ εCpΩ

TA\y≈ΩwzM 31y≈s/zC

3. q≡¼°eA∩ n≈@h SQL Ωwí≈ΩwC

#z∩≈wAUCú≤hΩTAUz¿C@¼

≈@C

≈Ωw

b≈Ωw εñΣT≈¼G

π

≈ΩweHí≈ºΘxC

tº eπ≈ßeΩweí≈ºΘxC

Θx

u≈ºΘxAtútIC

po≈¼÷ΩTA\ 87y≈½≤¼zC

pGb≈¼ñ⌠≤Aϕ¼AϕUCBJG

1. q≈ΩwA÷@Ub≈¼sAϕΩsCπOw]∩C

2. b≈∩ñA∩ Aϕ⌠@∩ApG∩OG

Ñq

i²zⁿwnb≈ñh(ΩÑqCw]O 1C∩ϕ

QCpΩTA\ 114 /stripes C

:

1. TwÑqqM SQL w @±ª(Abtmñ SQL w

q@l 0C

2. SQL Server 7.0 hiⁿ 32 ΩÑqA SQL Server 2000

hiⁿ 64 ΩÑqC

w⌠tº≤ %tº≈Ab⌠≤ SQL ServerAΦ⌠i²zw⌠w≤Ωw,

±Cw]O 20CpΩTA\ 103 ñ /diffestimateC

IΘx

YΘx≈AuϕzúQb≈ßIΘxQIAMú3∩

CpA\ 115 ñ /truncate C

w⌠Θx≤ %b SQL Server 2000 Θx≈AoΦ⌠i²zw⌠w≤Ωw

,±AΩw≤O]eΘx≈*⌡µnJ@Cw]

O 0CpΩTA\ 104 /logestimate C


3. ÷@U≈÷sHl≈@C

πu≈iv°íHKqz@OQ¿ACX≈½≤Σ

¼AΩTC

NG

v pGzFΘx≈∩ YΩwAΩwtwdIW sql IΘx∩

A∩wAData Protection for SQL ±m xAªb≡¼cMMµ ε

ñ∩ ñAHⁿXzúα⌡µo≈¼CoO]to SQL Ω

wΘxúαQ≈C

v bΦ⌠ñ,±⌠pQ≤≈LA≈b Tivoli Storage Manager

Server WlxsΘ⌠AxsΘA≤≈CpG°AWS¼≈xs

Θhí¼l⌠pAo≈NóCpGo≈±wjATivoli Storage

Manager b≈í o≤hxsΘCpGS¼≈xsΘA≈Nó

C

≈s/

b≈s/ εñΣT≈¼G

s

≈ⁿwseC

≈ⁿw ΦeC

≈ⁿwsMeC

po≈¼÷ΩTA\ 87y≈½≤¼zC

pGb≈¼ñ⌠≤Aϕ¼AϕUCBJG

1. q≈s/A÷@Ub≈¼sAϕΩsCsOw]∩C

2. b≈∩A∩ AϕUC∩G

Ñq

i²zⁿwnb≈ñh(ΩÑqCw]O 1C∩ϕ

QCpΩTA\ 114 /stripes C

:

1. Two∩w∩ SQL w ]wC


hiⁿ 64 ΩÑqC

3. ÷@U≈÷sHl≈@C

≈≡¼ c

b≈Ωw°íAzúαb≡¼ciΩwCϕzb≡¼c2 Ω

wAΩwΩTπbeWC

b≈s/°íAziHb≡¼ciΩwA]o°íΣbl

Ωwh≈C2 ΩwπsMµA2 sπM

µCSϕ∩A≤°íG

4 í 31

v Ys≈A∩NÑhFshCpApGzNΩwiAb

≡¼c∩ YAtmsªΣL]Q∩ C

v YM≈A∩LkVWÑhC

v Y≈AbΩwhY∩N²N≈ísC

≈Mµ

ϕzq≈@ñN SQL Server WΩw2 iAMµ επ

UCΩTG

v ΩwW

v wΩwí

v wºΘxí

v Ωweh

v Ωw (@Mµ)

– ∩ /jv

– bdIIΘx

– ¬

– µ@

– tΩw

– DB

q≈s/AπUCΩG

v Ωw2 s½≤ (ΩTnαA²iΩw)G

– sW

– í

v s2 ½≤G

– ΦW

– ΩΘW

– í


SQL Ωw

ΩwAnOϕ¿ßsb≤ΩwΩQ gBúAiCΓ

°íΣ SQL @G

Ωw

i²zΩwu≤πBtºΘx≈í≈Ωwe

s/

i²zΩwqsBBΘx≈í≈ΩweC

Ynq GUI ⌡µ@AϕHUBJG

1. Data Protection for SQL GUIC

: pGzb MSCS W⌡µ Data Protection for SQLAhz /sqlserver Is GUICpΩTA\ 11 C

2. °zQn¼A÷@UΩws/C

πb≡¼cMMµ≈½≤∩zw∩ C

3. q≡¼cA∩ Tivoli Storage Manager ServerAª]A≈AMß∩ @h

SQL Ωwí≈ΩwC

4. YXAA∩ b∩s∩CpΩTA\ 34y

∩zC

5. ÷@U÷sAH@C

Ωw

Sϕ∩WhA≤Ωw εC

bíAπBtºΘx≈b≡¼cñXC

v ∩ π F₀...

– MúΣLπM÷ΘxMtºC

v ∩ tº D₀...

– ∩ ºeπ F₀C– Múb F₀ M D₀ ºítºMΘxC

v ∩ Θx L₀...

– ∩ e@tº D₀ (pG)C

– ∩ e@π F₀C– pG D₀ sbA∩ b L₀ M D₀ ºíΘxFpG D₀ úsbA∩ b L₀ M F₀ ºíΘxC

– pG D₀ sbAMúb F₀ M D₀ ºíΘxMtºCv Múπ F₀...

– Múª÷ΘxMtºC

v Mútº D₀...

– ∩ e@tº D₁ (pG)C

– pGw∩ Θx L₀A∩ b L₀ M D₁ ºíΘxApGªsbApG D₁ úsbA∩ b L₀ M÷πΩºíΘxC

v MúΘx L₀...

– Mú L₀ ºßΘxC

4 í 33

s/

Sϕ∩WhA≤s/ εC

bíUAπBsBBΘx≈b≡¼cXC

v ∩ DΘx≈ N₀...

– ∩ N₀ ºßΘx≈Cv ∩ Θx≈ L₀...

– ∩ N₀ ºeDΘx≈C– ∩ N₀ ºßΘx≈C

v MúDΘx≈ N₀...

– pGosbAMúb N₀ MU@w∩ DΘx≈ N₁ ºíΘxApG N₁ úsbAMú N₀ ºßΘxC

v MúΘx≈ L₀...

– Mú L₀ ºeΘxMDΘx≈C– Mú L₀ ºßΘx≈A@U@w∩ DΘx≈ (pGªsb

)AMú L₀ ºßΘx≈C

∩

úqΩws/AziH∩ UC∩C

π@ñMD@ñ

"∩ o3∩AzαND@ñ≈½≤Jb≡¼cMMµCo≥

i²z÷aFⁿwD@ñ½≤Cw]uπ@ñ

½≤Cϕzl∩ ∩A Data Protection for SQL iµpUBJG

1. oX∩@ñMD@ñ½≤ Tivoli Storage Manager dC

2. Mú≡¼c⌠≤∩C

3. ¿dºßAN≡¼c±mbªl¼AC

Ñq

ziHⁿwb@ΩÑqCw]O 1C∩ϕQ

CpΩTA\ 114 /stripes C

:

1. Two∩w∩ SQL w ]wC


hiⁿ 64 ΩÑqC

N b∩ 3∩¿íAziH NΩwCw]O not H

K NΩwC∩3QCt\ 109 C

pGzb GUI ñ∩ ½≤iµ (p fullBdifffullBlog) AB²

∩b∩ ¼AAh Data Protection for SQL NTwbC@Ωw

A SQL zW@≈½≤ñ"∩Co∩O"w]∩

AzαbnMúo3∩Cpi@BΩTA\ 108

C

Ωw

ziH∩ 3∩u¡bºßΩw Ω

wCw]D C∩3QCt\ 103 C

ÑaⁿH

ziHⁿwAL Data Protection for SQL @OÑ Tivoli Storage


Manager Server ⁿiúCΘApGa1≈Cϕz÷[ (+) o

Hi≡¼cAoΩTiq Tivoli Storage Manager ñ oCo

∩w]∩ Ct\ 106 C

pΩTÑaⁿ

ϕFΩTd Tivoli Storage Manager AziHⁿw Data Protection

for SQL OÑ Tivoli Storage Manager Server ⁿiúCΘC∩

w]*∩ Ct\ 103 M 106 C

ubΩwAUCB&∩iG

í≈

∩ 3∩AziHí≈π≈Co≥ΩwlA

iA≤tºMΘx≈C∩w]*∩ C

Data Protection for SQL GUI úΣ /relocate M /to Cϕz⌡µí≈Aí≈noAzⁿOµCp /relocateM /to ÷ΩTA\ 109 C

: SQL Server 2000 °AΣí≈Co3∩b SQL Server 7.0

°Ab SQL Server 2000 W3C

íI ÷@UíI÷szQΩwCuϕz∩ π≈½≤M

(@Θx≈A÷sC

íI∩

÷@UíI÷sπ∩MUC∩G

v LíI

v ε≤

v bOBε

v bOeε

: bOBεMbOeε∩uαb SQL Server 2000C

εΩsi²zⁿwΘíCQbOBεMbOeεAziH

RWONΘíJHUMΣOC

FMúQ]wíIAzn∩ LíIΩsC

ϕíIbñARAµQHπ@GC píI

÷ΩTA\ 112 /stopatC

≡¼ c

úF@δ≡¼cΦwQQ&AUCΩuAbΩwMs/

°íñ≡¼cC

v 2 SQL Server ΩwAbMµ εñπ Tivoli Storage Manager Server

W≈½≤MµC

v o≈Mµπ÷≤≈½≤ΩTCpΩTA\ 36 yM

µzC

v ≈½≤H≈Θ (±e) WπC

∩ °íUCSwΦG

4 í 35

v bΩw°íAzúαi≡¼cñ≈½≤AúDªOπ≈B

zwg∩ í≈3∩C

v bs/°íAziHb≡¼cñi≈½≤Cϕz2 Y½≤AJ

b≈ñsMµNQπApGz@lwgi≈½≤πb≈

ñsMµCϕz2 sAπMµC

: tº≈½≤b≡¼cMMµ εñNXtºC

Mµ

ϕzF@NYΩw2 AoMµ επ≈½≤UCΩTG

v ≈½≤¼

v ¼A (@ñ/D@ñ)

v ≈½≤Θí

v jp

v ΩÑq

v O

v ≈½≤Or

qΩwAziHb≡¼cñ2 Sw≈ANπXUCB&Ω

TG

v tmΩí

v Ωí

v tmΘxí

v Θxí

v Data Protection for SQL

v SQL Server

v SQL Ωweh

v w]rX ID

v Unicode yÑ⌠ ID

v Unicode ±í


qs/Aϕ2 ≈½≤πs½≤UCΩT (@2≈wQi

)G

v sW

v wtmsí

v wsí

v Dns

qs/Aϕ2 sπ½≤UCΩTG

v ΦW

v ΩΘW

v wtmí

v wí

\αϕ

bMµ εñ∩ W÷@U½kΣAπB&@Cq

s/Auϕz2 ≡¼cΩwA\αϕiCª≈

½≤πbMµ εABo\αϕA≤⌠≤w∩ ½≤C

: ϕí≈3∩Q∩ Ao\αϕLkC

÷@U½kΣA\αϕXUCG

∩HⁿwΩwHKNY≈½≤ΩwC÷@UHπ

YsΦCpGzw∩ nΩwAozⁿwW

uAQzkΣ÷@Uw∩ ≈CpGΣLw∩ ≈n restore intoAzNPⁿwLA²zuαb@@ño≥C

½swm

≈A∩hⁿws SQL ΩwmC÷@U½swmHπ

@MµAΣñwnisΦ Φ/ΩΘWt∩MµCo\αϕ

uXΩw°íBi≤≈AúF SQL Server 7.0 WΘ

x≈½≤C

≈°A

∩ⁿw≈ SQL ΩwCpG SQL Ωwúb

≈íAªNQ±mb≈íCo\αϕuXbΩw°í

Bi≤πBtºΘx≈¼A²@ui≤@ΩwC÷@Uo

∩HπA≤WsΦC@2zΩwⁿw∩Aª

NMbΩw≈½≤CPaA2z≈½≤ú∩

AτúíC

SQL Ωw

°íi²z⌠≤b Tivoli Storage Manager Server W@ñ≈CYn

≈½≤G

1. °\αϕM÷@UC

QsW εABbz÷@Uπ≡¼cMMµC

2. ∩ ≈½≤C

3. ÷@U÷sHl@C

4 í 37

pΩw≈÷ΩTA\ 6ySQL Server ΩwzC

≡¼ cMMµ

o≡¼cPΩw°íñ≡¼cPABoMµMΩ

wMµⁿC


5 ⁿOµ

íp≤ Data Protection for SQL ⁿOµ (CLI)A]AykMdⁿO

ΘXCData Protection for SQL ⁿOµW tdpsqlc.exeCoi⌡µ≤w Data Protection for SQL ²ñC

ⁿOykº[

Data Protection for SQL UCⁿOµykG

tdpsqlc <ⁿO> <m> <0 h∩>

tdpsqlc i⌡µßO¬Ñ@AⁿOCC@ⁿOⁿUⁿOµCoO"mM∩¿Cm≤ⁿOµΣL∩º

eCbUCñAbackup ⁿOΣΩwW xyz (n≈½≤) ßO≈

¼ full (m) ß∩ /sqlbuffersC

tdpsqlc backup xyz full /sqlbuffers=2

píUmM∩ Data Protection for SQL ⁿOΘXdA\

C@ⁿOykßuΘXdv@C

: unΘJ tdpsqlc tdpsqlc help|? ⁿOAzNiHπ Data Protection for SQL

ⁿOΣπMµC\ 79yHelp ⁿOzC

Data Protection for SQL ⁿO

ϕ 6 CX Data Protection for SQL úDnⁿO@CC@@íMykb

ⁿXWC

ϕ 6. Data Protection for SQL ⁿO

ⁿO í

Backup ≈@h SQL Ωwíí≈ Tivoli

Storage Manager ServerC

46

Query π÷≤°ABΩwB≈½≤M Data Protection

for SQL tmΩTC

52

Restore @h SQL Ωwíí≈ SQL °

AC

62

INACTIVate Tivoli Storage Manager Server W@h@

ñ≈½≤C

75

Help π Data Protection for SQL ⁿOykC 79

Set ≤tmC 83

CHANGETSMPassword

≤ Data Protection for SQL Tivoli Storage

Manager KXC

85

m

CXi Data Protection for SQL ⁿOµmAⁿ'z\ΓUñC

@íC


≈½≤¼ϕ 7 CX Data Protection for SQL backup @i&≈½≤¼C 6

CXºñNπíC

ϕ 7. Data Protection for SQL ≈¼

ⁿO í

Full ≈πΩw@í≈ºΘxCoO≈

w]C

88

Difffull ≈eπ≈ºß≤Ωwí≈@í≈

ºΘxC

89

Group ≈Ωwñµ@sC 89

FIle ≈Ωwñµ@C 88

Set ≈hMsC 91

Log u≈ºΘxAtútIC 90

Query Query

Data Protection for SQL query ⁿOnTmñΣñ@G

Query SQLπ÷≤ SQL °AMΩwΩTC

Query TSMπ÷≤ Tivoli Storage Manager Server M≈½≤ΩTC

Query TDPπe Data Protection for SQL tmC

p query ⁿOµykA\ 52yQuery ⁿOzCpom

πíA\ 92yQueryzC


UCykπ Data Protection for SQL ⁿOMmG"" TDPSQLC BACKup

RESTore DIFFINACTIVate FIle

* FULLGroupLogSet

QuerySQLTDPTDP

DIFFFIleFULLGroupLogSetTypes*

HelpSetCHANGETSMPassword

"$

Y set ⁿOmA\ 83ySet ⁿOzM 95ySetzCY

changetsmpassword mA\ 85yChangetsmpassword ⁿOzM

99yCHANGETSMPasswordzC

÷ⁿOCXmϕ 8 ⁿOCXi Data Protection for SQL mCpG∩Pt@

m@AhbϕµñⁿXCpC@πíA\ 87

ymzC

ϕ 8. ÷ⁿOCX Data Protection for SQL m

m Backup Restore Query Set≤

TSMKX

BUFFers X

BUFFERSIze

X

DATEformat X

dbnameX X

X

t SQL TSM

X

DifffullX X

X

t TSMX

DIFFESTimate X

FIleX X

X

t TSMX

FROMSQLSERVer

X

5 ⁿOµ 41

ϕ 8. ÷ⁿOCX Data Protection for SQL m (≥)

m Backup Restore Query Set≤

TSMKX

FullX X

X

t TSMX

GroupX X

X

t TSMX

LogX X

X

t TSMX

LOGFile X

LOGPrune X

MOUNTWaitfordata

X

newpassword X

NUMBERformat

X

oldpassword X

SetX X

X

t TSMX

SQL X

SQLAUTHentication

X

SQLBUFFers X

SQLBUFFERSIze

X

SQLSERVer X

STRIPes X

TDP X

TIMEformat X

TSM X

Types X

t TSM

verifypassword X

* X

t TSMX

∩

43ϕ 9 ⁿOCXi Data Protection for SQL ∩CpG∩

P@m@AhbϕµñⁿXCpC@πíA\

100y∩zC


ϕ 9. ÷ⁿOCX Data Protection for SQL ∩

∩ Backup Restore Query Set≤

TSMKX

/ACtive X

t TSM

/ALl X

t TSM

/BUFFersX X

X

t TSM

/BUFFERSIze X X X

/COMPATibilityinfo

X

t SQL TSM

/CONFIGfile X X X X X X

/DBOonly X

/DIFFESTimate

X

t diff

/FILEInfo X

t TSM

/FIlesX

t set

X

t fullBgroupB

set

/FROMSQLSERVer

XX

t TSMX

/GRoupsX

t set

X

t fullBset

/INTO X

/LOGESTimate

X

t log

/LOGFile X X X X X

/LOGPrune X X X X X

/MOUNTWaitX X

X

t TSM

/OBJectX

X

t TSMX

/OLDerthan X

/PARTial X

t full

/Quiet X X X

/RECOVery X

t fullBdiffBlog

5 ⁿOµ 43

ϕ 9. ÷ⁿOCX Data Protection for SQL ∩ (≥)

∩ Backup Restore Query Set≤

TSMKX

/RELocate/TO

X

/REPlace X

t

log H&í

/SQLAUTHentication

X XX

t SQL

/SQLBUFFers X X

/SQLBUFFERSIze

X X

/SQLPasswordX X

X

t SQL

/SQLSERVerX X

X

t SQL

/SQLUSer X X

/STANDby X

t fullBdiffBlog

/STOPAT X

t log

/STOPATMark/AFTER

X

t log

/STOPBEFOREMark/AFTER

X

t log

/STRIPes X X

/TRUNCate X

t log

/TSMNODeX X

X

t TSMX X

/TSMOPTFileX X

X

t TSMX X

/TSMPasswordX X

X

t TSMX

Φ

pºeⁿOµykAb Data Protection for SQL ⁿOµñnNXΦG

v bmºe4]AuΩuC

v ∩Yu (/) Ωu (-)C

v bmºßA≤C@IsⁿOñi#⌠≤±mh∩C

v ziHN÷ΣrYgCbykñA(YgOHjgrΘⁿC


v Ωw SQL WΩw≤únjpgC

v (@µjC

v í≈÷ΣrnFHÑ (=) j÷ΣrPC

v pG]AµSϕrAH'AϕC

v bC@IsⁿOñAjí≈mM∩úuα@CUC&e

\Mµ½G

– FIle=

– Group=

– Log=

– Set=

– /FIles=

– /GRoups=

– /RELocate=

– /TO=

pG/files=a,b /files=a /files=b

: ∩h½Ωúns≥CpG/files=a /groups=y /files=b /groups=z

v YX½ykAHrIjhApUG

"" TDPSQLC *

,

Backup dbname*

"$

v bⁿOßUrP (*) ∩ ΩwWWº°AWΩ

C

:

1. Data Protection for SQL ⁿOßúA (G)AoP Data Protection for SQL

1 úPC

2. b\¬ykp≤UA\ xy\¬ykzC

N

bw SQL Ωw≈AziHⁿOñ Data Protection for SQL ⁿOC

÷ Tivoli Storage Manager ñíP Data Protection for SQL ftQ

eA\ 117² A, y Tivoli Storage Manager zC

b⌡µⁿOºeA∩sb≤w Data Protection for SQL ²ñC

pG(A /tsmoptfile Cpp≤ ∩ Data Protection for SQL t

m÷ΩTA\ 18ytm Data Protection for SQL ∩zC

5 ⁿOµ 45

Data Protection for SQL ⁿO

UCíC@ Data Protection for SQL ⁿOAΣßiykMⁿO

dΘXCpC@ⁿOíA\ 87 6 , yⁿOµzC

Backup ⁿO

backup ⁿON SQL Server ñ@h SQL Ωwíí≈≈ Tivoli

Storage Manager Server W Tivoli Storage Manager xsΘCziHΘJ * r≈ΩwCz@iHⁿwWL@Ωwiµh½ΩwMºΘx≈C

NG

v zúα≈ tempdb ΩwA]ªObC°A" SQL °A

C

v ÷MπMtº≈]A@í≈ºΘxA²í≈uOn@Pí

CªúOΘx≈AúIΘxC

v Data Protection for SQL nJ SQL °A ID SQL Server

SYSADMIN Tw°AñΓC

v b≈ΩwºeAziH TRANSACT-SQL Ωw@Pdí»zí

DBCC CHECKDB (’DBNAME’) τ SQL ΩwπXC

v ϕ SQL Server 7.0 b⌡µUC@AzúαbΣñ⌡µ≈G

– Rú SQL Ωw

– ¼Y SQL Ωw

– 'A²ºΘx≈&

– *Oⁿ@Ap BULK COPY M SELECT INTO

v pG≈Ob SQL Server 7.0 ≤sAhzúα≈ 7.0 H

e SQL Server C

yk

"" TDPSQLC *

,

Backup dbname*

*

*

FULL

,

FIle= logicalfilename*

DIFFerential A,

Group= groupname*

Log BSet C

"$

bUCu∩vºßAO∩Wzr$ (A,B,C) º≈¼∩ykC

p backup míA\ 87y≈½≤¼zC

≈∩G


""=3 [ cfg ]

/BUFFers=numbuffers

=1024 [ cfg ]/BUFFERSIze

=buffersizeinkb

"

"=tdpsql.cfg

/CONFIGfile=configfilename

"

"=tdpsql.log [ cfg ]

/LOGFile=logfilename

"

"=60 [ cfg ]

/LOGPrune=numdays=No

=Yes [ cfg ]/MOUNTWait

=No

"

"/Quiet =INTegrated [ cfg ]

/SQLAUTHentication=SQLuserid

"

"=0 [ cfg ]

/SQLBUFFers=numsqlbuffers

"

"=1024 [ cfg ]

/SQLBUFFERSIze=sqlbuffersizeinkb

"

"=″ ″

/SQLPassword=sqlpasswordname

"

"=[qúW cfg ]

/SQLSERVer=sqlservername

=sa/SQLUSer

=sqlusername

"

"=1 [ cfg ]

/STRIPes=numstripes

=[dsm.opt ]/TSMNODe

=tsmnodename

"

"=dsm.opt

/TSMOPTFile=dsmoptfilename

=[dsm.opt ]/TSMPassword

=tsmpasswordname

"$

A Difffull ∩:

5 ⁿOµ 47

=20 [ cfg ]/DIFFESTimate

=numpercent

B Log ∩:

=Yes/TRUNCate

=No

=0/LOGESTimate

=numpercent

C Set ∩:

*

*

*

,

/FIles= logicalfilename*

,

/GRoups= groupname*

p backup ∩íA\ 100y∩zC

Backup ΘXdBackup 1-Full

Backup 1 π≈ΓπΩw model M msdb Tivoli Storage Manager Server

W Tivoli Storage Manager xsΘC]AΓ∩G/sqlbuffers M /stripesC

ⁿOG

tdpsqlc back model,msdb full /sqlbuff=2 /strip=2

ΘXG

IBM Tivoli Storage Manager for Databases:Data Protection for Microsoft SQL Server 5A 2Ah 1.0(C) Copyright IBM Corporation 1997, 2003. All rights reserved.

b SQL Ωw≈...

blΩwíπ≈A2 º 1CwíG0 w¬G1218832 wgJG1218832 tvG 322.48 Kb/ϕ

í≈wQ¿C

blΩw msdb π≈A2 º 2CwíG0 w¬G8250640 wgJG 8250640 tvG2,463.24 Kb/ϕ

msdb ≈wQ¿C

w∩ SQL ≈G 2w SQL ≈G 2w¿ SQL ≈G 2wú SQL ≈G 0w SQL ≈G 0


úvG 1,327.52 Kb/ϕeG 9,469,472gBzíG 6.97 ϕ

Backup 2-Full

"≤ /quiet AH Backup 2 πútΘX test2 Ωwπ≈C&A

w] Windows τíwQ /sqlauthentication m½C

ⁿOG

tdpsqlc back test2 full /q /sqlauth=sql

ΘXG

IBM Tivoli Storage Manager for DatabasesData Protection for Microsoft SQL Server 5A 2Ah 1.0(C) Copyright IBM Corporation 1997, 2003. All rights reserved.

Backup 3-Differential

b Backup 3Atº≈O≥e@π≈ test2C]A test2 w≤í≈

⌠pC

ⁿOG

tdpsqlc back test2 difffull /diffest=10

ΘXG


b SQL Ωw≈...

blΩw test2 diffull ≈A1 º 1CwíG0 w¬G 5341016 wgJG 5341016 tvG 1,120.96 Kb/ϕ

test2 ≈wQ¿C

w∩ SQL ≈G 1w SQL ≈G 1w¿ SQL ≈G 1wú SQL ≈G 0

úvG 1,120.24 Kb/ϕeG 5,341,016gBzíG 4.66 ϕ

: b CLI ΘX GUI ≡¼cMMµñAtº≈½≤OH ″difffull″ ϕC

Backup 4-Log

b Backup 4Atest2 M model ²eπ≈ßUΣΘx≈CIΘxw]

Qm½C

ⁿOG

tdpsqlc back test2,model log /trunc=no

ΘXG

5 ⁿOµ 49


b SQL Ωw≈...

blΩwíΘx≈A2 º 1CwíG0 w¬G 80656 wgJG 80656 tvG 67.55 Kb/ϕ

í≈wQ¿C

blΩw test2 Θx≈A2 º 2CwíG0 w¬G 88920 wgJG 88920 tvG 73.28 Kb/ϕ

test2 ≈wQ¿C


úvG 70.44 Kb/ϕeG 169,576gBzíG 2.35 ϕ

Backup 5-Group

Backup 5 π≈@s@ group1 sAª≤ test2 ΩwC

ⁿOG

tdpsqlc back test2 group=group1

ΘXG


b SQL Ωw≈...

blΩw test2 s≈A1 º 1CwíG0 w¬G 866888 wgJG 866888 tvG 513.07 Kb/ϕ

test2 ≈wQ¿C


úvG 512.76 Kb/ϕeG 866,888gBzíG 1.65 ϕ

Backup 6-File

Backup 6 Ur (*) π≈≤ test2 CoO"@Ωw

ΓsñT¿C

ⁿOG

tdpsqlc back test2 file=*

ΘXG



b SQL Ωw≈...

blΩw test2 ≈A3 º 1CwíG0 w¬G 669832 wgJG 669832 tvG 569.31 Kb/ϕ

test2 ≈wQ¿C

blΩw test2 ≈A 3 º 2C.wíG0 w¬G 669832 wgJG 669832 tvG 388.90 Kb/ϕ

test2 ≈wQ¿C

blΩw test2 ≈A3 º 3CwíG0 w¬G 13958280 wgJG 13958280 tvG 2,911.39 Kb/ϕ

test2 ≈wQ¿C


úvG 1,987.15 Kb/ϕeG 15,297,944gBzíG 7.52 ϕ

Backup 7-Set

Backup 7 π≈ test2 Ωwñ@sMΓO (X¿µ@≈½

≤)C /groups M /files ⁿwc¿≈C

ⁿOG

tdpsqlc back test2 s /groups=primary /files=test2_2data,test2_3data

ΘXG


b SQL Ωw≈...

blΩw test2 ≈A1 º 1CwíG0 w¬G 14706896 wgJG 14706896tvG 3,404.98 Kb/ϕ

test2 ≈wQ¿C


úvG 3,402.56 Kb/ϕeG 14,706,896gBzíG 4.22 ϕ

5 ⁿOµ 51

Query ⁿO

query ⁿOπ÷≤ SQL °AΣΩwB÷≤ Tivoli Storage Manager Server

Σ≈½≤H Data Protection for SQL ΩTC

NG

v í≈ΩTπeiαt5°σrµABiαπgííCziH

Windows ⁿOΘX½sVyk (ⁿOú)AN Data Protection for SQL dⁿO

ΘX½sV@σrG

TDPcommandstatement > [[drive:]path\]filename.exto NC

TDPcommandstatement >> [[drive:]path\]filename.exto[C

MßziHs²sΦC

v ziHft Windows ⁿODrA Windows more LoⁿO (ⁿOú)

πΘXA@@eG

TDPcommandstatement | more

yk"" TDPSQLC

*

*

Query SQL,

dbname *TDPTSM A

,

dbname*

"$

bUC∩ßAO∩Wzr$ (A) Tivoli Storage Manager ∩ykC

p query míA\ 92yQueryzC

d∩G""

=3 [ cfg ]/BUFFers

=numbuffers


=buffersizeinkb

"

"/COMPATibilityinfo =tdpsql.cfg


"

"=sqlserver [ cfg. ]

/FROMSQLSERVer==sqlservername

"




"

"=60 [ cfg ]


*

,

/OBJect= objectname*

"

"=INTegrated [ cfg ]


"

"=″ ″


"

"=[qúW cfg ]


=sa/SQLUSer

=sqlusername

"

"=[dsm.opt ]

/TSMNODe=tsmnodename

=dsm.opt/TSMOPTFile

=dsmoptfilename

"

"=[dsm.opt ]

/TSMPassword=tsmpasswordname

"$

5 ⁿOµ 53

A d TSM ∩:

*

*

*

*

*

FullDifffull

,

Log= logobjectname*

,


,

Group= groupname*,

Set= setobjectname*

Types

*

*

/ACtive

/ALl,


"

"/FILEInfo

=No/MOUNTWait

=Yes

p query ∩íA\ 100y∩zC


Quary ΘXdQuery 1-SQL Server

Query 1 d SQL °A mutaliskA]AeΩTC

ⁿOG

tdpsqlc query sql /compat

ΘXG


SQL Server ΩT----------------------

SQL Server W ........................ MUTALISKSQL Server ....................... 7.0

w] ID .................... 52w]rX ID ...................1252Unicode yÑ⌠ ID .............1033Unicode ±í ID .............196609O ............................No

Query 2-SQL Database

Query 2 dSw SQL °AΩw test2 A]A SQL Server 7.0 eΩTC

ⁿOG

tdpsqlc query sql test2 /compat

ΘXG


SQL Server ΩT----------------------

SQL Server W ........................ MUTALISKSQL Server ....................... 7.0

w] ID .................... 52w]rX ID ...................1252Unicode yÑ⌠ ID .............1033Unicode ±í ID .............196609O ............................No

SQL ΩwΩT------------------------

SQL ΩwW ................test2wtm SQL ΩwΩí .....104,857,600w SQL ΩwΩí .....14,680,064wtm SQL ΩwΘxí .....104,857,600w SQL ΩwΘxí .....14,192,640SQL Ωweh.......... 70SQL Ωw∩ ...........................

5 ⁿOµ 55

Query 3-TDP

Query 3 V Data Protection for SQL dtmΩTC

ⁿOG

tdpsqlc query tdp

ΘXG


Microsoft SQL Server TDP tm]w---------------------------------------------------

BUFFers ................................... 3BUFFERSIze ................................ 1024DATEformat ................................ 1DIFFESTimate .............................. 20FROMSQLserver .............................LANGuage .................................. AMENGLOGFile ................................... tdpsql.logLOGPrune .................................. 60MOUNTWaitfordata .......................... YesNUMBERformat .............................. 1SQLAUTHentication ......................... INTegratedSQLBUFFers ................................ 0SQLBUFFERSIze ............................. 1024SQLSERVer ................................. .STRIPes ................................... 1TIMEformat ................................ 1

Query 4-TSM Types

Query 4 V Tivoli Storage Manager Server dΩw≈½≤¼A]A@

ñMD@ñ½≤C

ⁿOG

tdpsqlc query tsm * types /all

ΘXG


≈½≤ΩT-------------------------

SQL ΩwW ......................modelSQL Server W .................. MUTALISKπ@ñ≈½≤q ............. 1πD@ñ≈½≤q ........... 1Θx@ñ≈½≤q ............. 1

SQL ΩwW ..................... msdbSQL Server W .................. MUTALISKπ@ñ≈½≤q ............. 1

SQL ΩwW ..................... test1SQL Server W .................. MUTALISKπ@ñ≈½≤q ............. 1πD@ñ≈½≤q ........... 1


Θx@ñ≈½≤q ............. 1

SQL ΩwW ..................... test2SQL Server W .................. MUTALISKπ@ñ≈½≤q ............. 1πD@ñ≈½≤q ........... 1tº@ñ≈½≤q ............. 1tºD@ñ≈½≤q ........... 1Θx@ñ≈½≤q ............. 4ΘxD@ñ≈½≤q ........... 3s@ñ≈½≤q ............. 1sD@ñ≈½≤q ........... 1@ñ≈½≤q ..............1D@ñ≈½≤q ........... 3@ñ≈½≤q ............... 1D@ñ≈½≤q ............... 2

Query 5-Tivoli Storage Manager Database

Query 5 V Tivoli Storage Manager Server dSwΩw test2A#w]πª

@ñ≈½≤C

ⁿOG

tdpsqlc query tsm test2

ΘXG


≈½≤ΩT-------------------------

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈½≤¼ ............................. Full≈½≤¼A ............................. Active≈Θ / í ..................... 06/27/2003 15:25:43≈jp ................................. 15,236,608Ωw½≤W .......................... 20030627152543\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈½≤¼ ............................. Difffull≈½≤¼A ............................. Active≈Θ / í ..................... 06/27/2003 15:26:19≈jp ................................. 4,682,240Ωw½≤W ........................... 20030627152619\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈½≤¼ ............................. Log≈½≤¼A ............................. Active≈Θ / í ...................... 06/27/2003 15:26:44≈jp ................................. 86,528Ωw½≤W ........................... 20030627152644\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2

5 ⁿOµ 57

≈½≤¼ ............................. GroupSQL sΦW ......................... group1≈½≤¼A ............................. Active≈Θ / í ...................... 06/27/2003 15:27:50≈jp ................................. 865,792Ωw½≤W ........................... 20030627152750\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈½≤¼ ............................. Log≈½≤¼A ............................. Active≈Θ / í ..................... 06/27/2003 15:27:51≈jp ................................. 86,528Ωw½≤W .......................... 20030627152751\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈ ½≤ ¼ ........................... FileSQL ΦW ......................... test2_2data≈½≤¼A ............................. Active≈Θ / í ...................... 06/27/2003 15:29:31≈jp ................................. 669,184Ωw½≤W .......................... 20030627152931\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈½≤¼ ............................. Log≈½≤¼A ............................. Active≈Θ / í ..................... 06/27/2003 15:29:35≈jp ................................. 86,528Ωw½≤W ........................... 20030627152935\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈½≤¼ ............................. Set≈½≤¼A ............................. Active≈Θ / í ...................... 06/27/2003 15:30:02≈jp ................................. 14,326,272Ωw½≤W ........................... 20030627153002\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈½≤¼ ............................. Log≈½≤¼A ............................. Active≈Θ / í ..................... 06/27/2003 15:30:38≈jp ................................. 86,528Ωw½≤W ........................... 20030627153038\0000015F≈½≤ñÑqq ................. 1


Query 6-TSM Database

Query 6 V Tivoli Storage Manager Server dΩw Test1 ΩTA]AeΩT

bC

: πΩTO÷≤q SQL Server 2000 ≈½≤Cw∩b SQL Server 7

≈½≤πeΩTN]tΣL÷ΩTC

ⁿOG

tdpsqlc q tsm Test1 full /compat

ΘXG


≈½≤ΩT-------------------------

SQL Server W ........................ RBSTEST11\RBSTEST11_2000SQL ΩwW ........................... Test1≈½≤¼ ............................. Full≈½≤¼A ............................. Active≈Θ / í ...................... 06/27/2003 11:15:44≈jp ................................. 89,607,680Ωw½≤W ........................... 20030627111544\00000700≈½≤ñÑqq ................. 1SQL Server .......................... 8.0.194O ..................................... NoTDP ................................. 2.2.0.0SQL ΩweÑh...................... 80wtm SQL ΩwΩí ................ 93,585,408w SQL ΩwΩí ................ 90,439,680wtm SQL ΩwΘxí ................ 104,595,456w SQL ΩwΘxí .................14,225,408SQL Ωw∩ ........................... Torn page detection

Query 7-TSM Database

Query 7 πΩw Test1 @ñMD@ñπ≈½≤C&AnDΩTC

ⁿOG

tdpsqlc q tsm Test1 full /fileinfo /all

ΘXG


≈½≤ΩT-------------------------

SQL Server W ........................ RBSTEST11\RBSTEST11_2000SQL ΩwW ........................... Test1≈½≤¼ ............................. Full≈½≤¼A ............................. Inactive≈Θ / í ...................... 06/27/2003 11:15:44≈jp ................................. 89,607,680

5 ⁿOµ 59

Ωw½≤W ........................... 20030627111544\00000700≈½≤ñÑqq ................. 1

SQL sΦW ......................... Group1wtm SQL sí ...................... 90,439,680w SQL sí....................... 87,293,952SQL ΦW ......................... File1Group1SQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\File1Group1_Data.NDFwtm SQL í ...................... 47,382,528w SQL í ...................... 44,236,800SQL ΦW ......................... File2Group1SQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\File2Group1_Data.NDFwtm SQL í ...................... 43,057,152w SQL í ...................... 43,057,152

SQL sΦW ......................... Group2wtm SQL sí ...................... 2,097,152w SQL sí ...................... 2,097,152SQL ΦW ......................... File1Group2SQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\File1Group2_Data.NDFwtm SQL í ...................... 1,048,576w SQL í ...................... 1,048,576SQL ΦW ......................... File2Group2SQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\File2Group2_Data.NDFwtm SQL í ...................... 1,048,576w SQL í ...................... 1,048,576

SQL sΦW ......................... PRIMARYwtm SQL sí ...................... 1,048,576w SQL sí ...................... 1,048,576SQL ΦW ......................... Test1_DataSQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\Test1_Data.MDFwtm SQL í ...................... 1,048,576w SQL í ...................... 1,048,576

SQL sΦW ......................... TRANSACTION LOGwtm SQL sí ...................... 104,595,456w SQL sí ...................... 14,225,408SQL ΦW ......................... Test1_LogSQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\Test1_Log.LDFwtm SQL í ...................... 104,595,456

SQL Server W ........................ RBSTEST11\RBSTEST11_2000SQL ΩwW ........................... Test1≈½≤¼ ............................. Full≈½≤¼A ............................. Active≈Θ / í ..................... 06/27/2003 11:32:59≈jp ................................. 89,607,680Ωw½≤W ........................... 20030627113259\00000700≈½≤ñÑqq ................. 1

SQL sΦW ......................... Group1wtm SQL sí ...................... 90,439,680w SQL sí....................... 87,293,952


SQL ΦW ......................... File1Group1SQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\`File1Group1_Data.NDFwtm SQL í ...................... 47,382,528w SQL í ...................... 44,236,800SQL ΦW ......................... File2Group1SQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\File2Group1_Data.NDFwtm SQL í ...................... 43,057,152w SQL í ...................... 43,057,152

SQL sΦW ......................... Group2wtm SQL sí ...................... 2,097,152w SQL sí ...................... 2,097,152SQL ΦW ......................... File1Group2SQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\File1Group2_Data.NDFwtm SQL í ...................... 1,048,576w SQL í ...................... 1,048,576SQL ΦW ......................... File2Group2SQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\File2Group2_Data.NDFwtm SQL í ...................... 1,048,576w SQL í ...................... 1,048,576

SQL sΦW ......................... PRIMARYwtm SQL sí ...................... 1,048,576w SQL sí ...................... 1,048,576SQL ΦW ......................... Test1_DataSQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\Test1_Data.MDFwtm SQL í ...................... 1,048,576w SQL í ...................... 1,048,576

SQL sΦW ......................... TRANSACTION LOGwtm SQL sí ...................... 104,595,456w SQL sí ...................... 12,009,472SQL ΦW ......................... Test1_LogSQL ΩΘW ......................... C:\Program Files\Microsoft SQL Server\MSSQL$RBSTEST11_2003\data\Test1_Log.LDFwtm SQL í ...................... 104,595,456

5 ⁿOµ 61

Restore ⁿO

ⁿOiq Tivoli Storage Manager xsΘ@h SQL Ωwíí

≈ SQL °AC

NG

v zúα Data Protection for SQL 2 Data Protection for SQL 1

≈½≤C

v zLkeb SQL ΩwCNn SQL ΩwB≤µ@

íAzNiHKoCpGznDnΩwAz -m SQL

SERVER ∩AHµ@í SQL °ACpíΩ

TA\ 134y]wízC

:

1. SQL Ωw°Aµ@O Data Protection for SQL nJ SQL

°Aiµ@PC

2. SQL Enterprise ManagerBSQL Server Application Client MΣL SQL Server A

iHOΩwM SQL °AC

v Data Protection for SQL nJ SQL °A SQL Server

SYSADMIN Tw°AñΓC

v ziH TRANSACT-SQL Ωw@Pdí»zí DBCC CHECKDB

(’DBNAME’) τw SQL ΩwπXC

v pG≈Ob SQL Server 7.0 HeAhzúα≈ SQL Server

7.0 ≤sC

: ϕj¼ SQL ΩwAb commtimeout ∩ñⁿw( 10000 AN

U≤K@ú¡⌠CpGObL LAN ⌠ñ⌡µ@Ah

∩uxsΘNzvⁿwoC


|

|

|

yk

"" TDPSQLC *

,

Restore dbname*

"

"

*

*

*

*

FULL

,

FIle= logicalfilename A*

FULL BDIFFerential C

,

Group= groupname D*,

Log= logobjectname E*

,

Set= setobjectname F*

"$

bUC∩ºßAO∩Wzr$ (A,B,C,D,E,F) ≈¼∩ykC

p restore míA\ 87y≈½≤¼zC

∩G""

=3 [ cfg ]/BUFFers

=numbuffers


=buffersizeinkb

"

"=tdpsql.cfg


/DBOonly"



/INTO= dbname"

5 ⁿOµ 63



"

"=60 [ cfg ]


=Yes [ cfg ]/MOUNTWait

=No

"

"

*

,


/Quiet"

" * *

, ,

/RELocate= logicalfilename /TO= physicalfilename "

"=INTegrated [ cfg ]


"

"=0 [ cfg ]


"

"=1024 [ cfg ]


"

"=″ ″


"


"=[qúW cfg ]


=sa/SQLUSer

=sqlusername

"

"=1 [ cfg ]

/STRIPes=numstripes

=[dsm.opt ]/TSMNODe

=tsmnodename

"

"=dsm.opt



=tsmpasswordname

"$

A Restore File ∩:

*

/REPlace

B Restore Full ∩:

B1B2

B1 Restore Full ∩ 1:

*

=Yes/RECOVery

=No/STANDby= undofilename

/REPlace

B2 Restore Full ∩ 2:

5 ⁿOµ 65

*

*

*

,


,

/GRoups= groupname*

/PARTial=Yes

/RECOVery=No

/REPlace

C Restore Diff ∩:

=Yes/RECOVery

=No/STANDby= undofilename/REPlace

D Restore Group ∩:

*

*

,


/REPlace


E Restore Log ∩:

*

=Yes/RECOVery

=No/STANDby= undofilename/STOPAT= datetime/STOPATMark= markname

/AFTER= datetime/STOPBEFOREMark= markname

/AFTER= datetime

F Restore Set ∩:

*

*

*

,


,

/GRoups= groupname*

/REPlace

p restore ∩íA\ 100y∩zCp restore ∩ helpΘXdA\ 79yHelp ΘXdzC

5 ⁿOµ 67

Restore ΘXdRestore 1-Full

Restore 1 πNΩw Test1 π≈½≤úP°AADqñ≈ª

°AC

ⁿOG

tdpsqlc restore Test1 full /fromsqlserver=rbstest07\rbstest07_2003

ΘXG


b Sql Ωw@...

bV Tivoli Storage Manager °AdΩw≈MµAy...

bl≈½≤ Test1 π@A1 º 1,Ωw Test1wíG0 w¬G 89607680 wgJG 89607680 tvG 3,003.42 Kb/ϕTest1 @wQ¿C

wdΩw≈G 1nDwΩw≈G 1wΩw≈G 1wñLΩwG 0

úvG 3,002.90 Kb/ϕeG 89,607,680gBzíG 29.14 ϕ

Restore 2-Differential

Restore 2 πΩw Test1 tº≈½≤Ωw Test2C NGTest2 Ω

wwgsbA@¿\C

ⁿOG

tdpsqlc restore Test1 diff /into=Test2

ΘXG


b Sql Ωw@...


bl≈½≤ Test1 difffull @A1 º 1,Ωw Test2wíG0 w¬G 478720 wgJG 478720 tvG 40.62 Kb/ϕTest1 @wQ¿C



|

|

úvG 40.61 Kb/ϕeG 478,720gBzíG 11.51 ϕ

Restore 3-Group

Restore 3 πN@W Group1 s≈½≤Ωw Test1C

ⁿOG

tdpsqlc restore Test1 group=Group1

ΘXG


b Sql Ωw@...


b meta Ω ...

bl≈½≤ Test1\Group1 s@, 1 º 1AΩw Test1wíG0 w¬G 86982144 wgJG 86982144 tvG 8,188.11 Kb/ϕTest1\Group1 @wQ¿C


úvG 8,185.75 Kb/ϕeG 86,982,144gBzíG 10.38 ϕ

Restore 4-Set

Restore 4 π@ñ≈½≤Ωw Test1C

ⁿOG

tdpsqlc restore Test1 set=*

ΘXG


b Sql Ωw@...


b meta Ω ...

bl≈½≤ Test1\20030718141546\00000700 @A1 º 1AΩw Test1wíG0 w¬G 88489472 wgJG 88489472 tvG 8,125.58 Kb/ϕTest1\20030718141546\00000700 @wQ¿C

5 ⁿOµ 69


úvG 8,122.52 Kb/ϕeG 88,489,472gBzíG 10.64 ϕ

Restore 5-Log (íI)

Restore 5 πΩw Test1 @ñΘx≈½≤ⁿwíIC-º

TΘx≈XΘíhC

ⁿOG

tdpsqlc restore Test1 log=* /stopat="07/01/2003 13:56:00"

ΘXG


b Sql Ωw@...

bV Tivoli Storage Manager °AdΩw≈MµAy...bl≈½≤ Test1\20030701135511\00000700 Θx@A4 º 1AΩw Test1wíG0 w¬G 214528 wgJG 214528 tvG 59.75 Kb/ϕTest1\20030701135511\00000700 @wQ¿C

bl≈½≤ Test1\20030701135605\00000700 Θx@A4 º 2AΩw Test1wíG0 w¬G 147968 wgJG 147968 tvG 32.15 Kb/ϕTest1\20030701135605\00000700 @wQ¿C

bl≈½≤ Test1\20030701135712\00000700 Θx@A4 º 3AΩw Test1wíG0 w¬G 0 wgJG 0 tvG 0.00 Kb/ϕTest1\20030701135712\00000700 @wQ¿C

ñL Test1\20030701135817\00000700≤iµñóíIC

wdΩw≈G 4nDΩw≈G 4wΩw≈G 3wñLΩwG 1

úvG 37.21 Kb/ϕeG 362,496gBzíG 9.51 ϕ


Restore 6-Log (ⁿWO)

Restore 6 πΩw Testmark @ñΘx≈½≤ⁿwíICt

ⁿwW mark2 @OXbM@TΘx≈½≤ñC@2o

OYεC

ⁿOG

tdpsqlc restore Testmark log=* /stopatmark=mark2

ΘXG


b Sql Ωw@...

bV Tivoli Storage Manager °AdΩw≈MµAy...blN≈½≤ Testmark\20030701102947\0000065C Θx@A≈ database TestmarkAw¿ 4 º 1wíG0 w¬: 159232 wgJ: 159232 tv: 61.68 Kb/ϕTestmark\20030701102947\0000065C @wQ¿C

blN≈½≤ Testmark\20030701103127\000001DC Θx@A≈ database TestmarkAw¿ 4 º 2wíG0 w¬G 159232 wgJG 159232 tvG 34.51 Kb/ϕTestmark\20030701103127\000001DC @wQ¿C

blN≈½≤ Testmark\20030701103325\00000680 Θx@A≈ database TestmarkAw¿ 4 º 3wíG0 w¬G 0 wgJG 0 tvG 0.00 Kb/ϕTestmark\20030701103325\00000680 @wQ¿C

ñL Testmark\20030701103556\00000694≤iµñóíIC

wdΩw≈G 4nDΩw≈G 4wΩw≈G 3wñLΩwG 4

úvG 38.60 Kb/ϕeG 318,464gBzíG 8.06 ϕ

Restore 7-Log (D@ñ½≤)

Restore 7 ldOπΩw Test1 @ñMD@ñΘx≈½≤C

ⁿOG

tdpsqlc q tsm Test1 log=* /all

ΘXG


≈½≤ΩT-------------------------

SQL Server W ........................ RBSTEST11\RBSTEST11_2000

5 ⁿOµ 71

SQL ΩwW ........................... Test1≈½≤¼ ............................. Log≈½≤¼A ............................. Inactive≈Θ / í ...................... 06/22/2003 13:55:11≈jp ................................. 214,528Ωw½≤W ........................... 20030622135511\00000700≈½≤ñÑqq ................. 1

SQL Server W ........................ RBSTEST11\RBSTEST11_2000SQL ΩwW ........................... Test1≈½≤¼ ............................. Log≈½≤¼A ............................. Active≈Θ / í ...................... 06/22/2003 13:56:05≈jp ................................. 147,968Ωw½≤W ........................... 20030622135605\00000700≈½≤ñÑqq ................. 1

SQL Server W ........................ RBSTEST11\RBSTEST11_2000SQL ΩwW ........................... Test1≈½≤¼ ............................. Log≈½≤¼A ............................. Active≈Θ / í ........ ............. 06/22/2003 13:57:12≈jp ................................. 147,968Ωw½≤W ........................... 20030622135712\00000700≈½≤ñÑqq ................. 1

SQL Server W ........................ RBSTEST11\RBSTEST11_2000SQL ΩwW ........................... Test1≈½≤¼ ............................. Log≈½≤¼A ............................. Active≈Θ / í ...................... 06/22/2003 13:58:17≈jp ................................. 147,968Ωw½≤W ........................... 20030622135817\00000700≈½≤ñÑqq ................. 1

Restore 7 @ONΩw Test1 SOⁿWD@ñΘx≈½≤MC

"≤nDD@ñΘx≈½≤AHb restore ⁿOW /object C

ⁿOG

tdpsqlc restore Test1 log=* /object=20030622135511\00000700

ΘXG


b Sql Ωw@...

bV Tivoli Storage Manager °AdΩw≈MµAy...blN≈½≤ Test1\20030622135511\00000700 Θx@Ωw Test1Aw¿ 1 º 1wíG0 w¬G 214528 wgJG 214528 tvG 29.47 Kb/ϕTest1\20030622135511\00000700 @wQ¿C

wdΩw≈G 1nDwΩw≈G 1wΩw≈G 1


wñLΩwG 0

úvG 29.46 Kb/ϕeG 214,528gBzíG 7.11 ϕ

Restore 8-Full (í≈)

Restore 8 ππ≈½≤s Group1 @í≈Ωw Test1C

ⁿOG

tdpsqlc restore Test1 full /partial /gr=Group1

ΘXG


b Sql Ωw@...

bV Tivoli Storage Manager °AdΩw≈MµAy...b meta Ω ...



úvG 3,359.21 Kb/ϕeG 89,607,680gBzíG 26.05 ϕ

5 ⁿOµ 73

Restore 9-Full (½stm)

Restore 9 πNΩw Test1 @π≈½≤ (@SO½stm Φ

File1Group1) sΩΘmC

ⁿOG

tdpsqlc restore Test1 full /relocate=File1Group1/to=e:\sqldata\File1Group1.NDF

ΘXG


b Sql Ωw@...

bV Tivoli Storage Manager °AdΩw≈MµAy...b meta Ω ...



úvG 3,929.64 Kb/ϕeG 88,100,352gBzíG 21.89 ϕ


Inactivate ⁿO

inactivate ⁿO Tivoli Storage Manager Server W@h@ñ≈

½≤Cjí≈≈½≤AoO≈Bz@í≈u@CJBz

ú≈ípAziH inactivate ⁿOC

Tivoli Storage Manager Server úRúⁿ Tivoli Storage Manager zxsΘñ@

ñ≈½≤FªuRúD@ñ≈½≤C@2≈½≤¿D@ñAwqb

½≤zOñBzNPwb≤Rú≈½≤C

: ⁿO N Data Protection for SQL 1 adsmdelete M adsmautodeleteⁿOCYnⁿw÷gíAinactivate /olderthan ∩ N 1

/ifolder DC

yk

"" TDPSQLC *

,

INACTIVate dbname*

*

*

*

*

,


FULLDIFFerential

,

Group= groupname*,

Log= logobjectname*

,

Set= setobjectname*

*

"$

p inactivate míA\ 87y≈½≤¼zC

Inactivate ∩G""

=tdpsql.cfg/CONFIGfile

=configfilename

"



"



"

5 ⁿOµ 75

"=60 [ cfg ]


*

,


"

"/OLDerthan= numdaysold /Quiet =[dsm.opt ]


"

"=dsm.opt



=tsmpasswordname

"$

p inactivate ∩íA\ 100y∩zC


Inactivate ΘXdUC@TaΩw≈½≤C≈½≤@2ANOdh

CbípUqúP SQL °A≈½≤C²A⌡µdπ¼AΩTA

p@ñ¼AM≈ΘC

ⁿOG

tdpsqlc query tsm test1,test2 * /fromsqlserv=mutalisk

ΘXG


≈½≤ΩT-------------------------

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test1≈½≤¼ ............................. Full≈½≤¼A ............................. Active≈Θ / í ...................... 06/17/2003 13:04:41≈jp ................................. 2,209,512,960Ωw½≤W ........................... 20030617130441\0000012D≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test1≈½≤¼ ............................. Log≈½≤¼A ............................. Active≈Θ / í ...................... 06/17/2003 15:26:59≈jp ................................. 92,672Ωw½≤W ........................... 20030617152659\0000015F≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test2≈½≤¼ ............................. Full≈½≤¼A ............................. Active≈Θ / í ...................... 06/17/2003 16:06:58≈jp ................................. 15,236,608Ωw½≤W ........................... 20030617160658\00000163≈½≤ñÑqq ................. 1

MßMwnwOsWLΓP (b 11 δ 28 ΘHe) test1 Ωw

½≤A@ΓC

ⁿOG

tdpsqlc inactiv test1 * /fromsqlserv=mutalisk /olderthan=14

ΘXG


b Sql Ωw≈...bV Tivoli Storage Manager °AdΩw≈MµAy...bπ≈ test1bΘx≈ test1\20030617152659\0000015F

wdΩw≈G 2nDΩw≈G 2wΩw≈G 2

5 ⁿOµ 77

wñLΩwG 0

gBzíG 1.26 ϕ

t@ Tivoli Storage Manager query /all πo≈½≤e¼AFb test1 πMΘx≈úOD@ñC

ⁿOG

tdpsqlc query tsm test1 /fromsqlserv=mutalisk /all

ΘXG


≈½≤ΩT-------------------------

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test1≈½≤¼ ............................. Full≈½≤¼A ............................. Inactive≈Θ / í ...................... 06/17/2003 13:04:41≈jp ................................. 2,209,512,960Ωw½≤W ........................... 20030617130441\0000012D≈½≤ñÑqq ................. 1

SQL Server W ........................ MUTALISKSQL ΩwW ........................... test1≈½≤¼ ............................. Log≈½≤¼A ............................. Inactive≈Θ / í ...................... 06/17/2003 15:26:59≈jp ................................. 92,672Ωw½≤W ........................... 20030617152659\0000015F≈½≤ñÑqq ................. 1


Help ⁿO

help ⁿOAHσrϕkπw∩ Data Protection for SQL ⁿOy

kC

Help UCϕkG

[a] a O∩Fa iαXs@

a | b∩ a bA²úαP∩ Γ

a + a (X@

a * a iαXs≤h

(a) DⁿO@í≈

UPPERCASE(Yg (z]iHpgΘJ)

yk

"" TDPSQLC Help?

*

BACKupINACTIVate DIFF

* FIleRESTore FULL

GroupLogSet

HelpQuery

SQLTDPTDP

DIFFFIleFULLGroupLogSetTypes*

SETCHANGETDPPassword

"$

Help ΘXdHelp 1-Query TSM

ⁿOG

tdpsqlc help query tsm *

ΘXG


ACO5057I C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.log

5 ⁿOµ 79

ΘxwQRúC

TDPSQLC Query TSM *|dbname[,dbname,...] [*][/ACtive][/ALl][/BUFFers=numbuffers] w]G3 ( cfg )[/BUFFERSIze=buffersizeinkb] w]G1024 ( cfg )[/COMPATibilityinfo][/CONFIGfile=configfilename] w]Gtdpsql.cfg[/FROMSQLserver=sqlservername] w]Gsqlserver ( cfg )[/LOGFile=logfilename] w]Gtdpsql.log ( cfg )[/LOGPrune=numdays|No] w]G60 ( cfg )[/OBJect=*|objectname[,objectname,...]][/TSMNODe=tsmnodename] w]Gdsm.opt [/TSMOPTFile=dsmoptfilename] w]Gdsm.opt[/TSMPassword=tsmpassword] w]Gdsm.opt

Help 2-Restore Full

ⁿOG

tdpsqlc help rest full

ΘXG


TDPSQLC Restore *|dbname[,dbname,...] [Full][/BUFFers=numbuffers] w]G3 ( cfg )[/BUFFERSIze=buffersizeinkb] w]G1024 ( cfg )[/CONFIGfile=configfilename] w]Gtdpsql.cfg[/DBOonly][/FIles=*|logicalname[,logicalname,...] ][/FROMSQLserver=sqlservername] w]Gsqlserver ( cfg )[/GRoups=*|groupname[,groupname,...] ][/INTO=dbname][/LOGFile=logfilename] w]Gtdpsql.log ( cfg )[/LOGPrune=numdays|No] w]G60 ( cfg )[/MOUNTWait=Yes|No] w]GYes ( cfg )[/OBJect=*|objectname[,objectname,...] ][/PARTial][/Quiet][/RECOVery=Yes|No] w]G Yes[/RELocate=lname /TO=pname [/RELocate=lname /TO=pname ...] ][/REPlace][/SQLAUTHentication=INTegrated|SQLuserid] w]GINTegrated ( cfg )[/SQLBUFFers=numsqlbuffers] w]G0 ( cfg )[/SQLBUFFERSIze=sqlbuffersizeinkb] w]G1024 ( cfg )[/SQLPassword=sqlpasswordname] w]G" "[/SQLSERVer=sqlservername] w]GqúW ( cfg )[/SQLUSer=sqlusername] w]Gsa[/STANDby=undofilename][/STRIPes=numstripes] w]G1 ( cfg )[/TSMNODe=tsmnodename] w]Gdsm.opt [/TSMOPTFile=dsmoptfilename] w]Gdsm.opt[/TSMPassword=tsmpassword] w]Gdsm.opt


Help 3-Restore Log

ⁿOG

tdpsqlc help rest log

ΘXG


TDPSQLC R *|dbname[,dbname,...] Log=*|logobjectname[,logobjectname,...][/BUFFers=numbuffers] w]G3 ( cfg )[/BUFFERSIze=buffersizeinkb] w]G1024 ( cfg )[/CONFIGfile=configfilename] w]Gtdpsql.cfg[/DBOonly][/FROMSQLserver=sqlservername] w]Gsqlserver ( cfg )[/INTO=dbname][/LOGFile=logfilename] w]Gtdpsql.log ( cfg )[/LOGPrune=numdays|No] w]G60 ( cfg )[/MOUNTWait=Yes|No] w]GYes ( cfg )[/OBJect=*|objectname[,objectname,...] ][/Quiet][/RECOVery=Yes|No] w]G Yes[/RELocate=lname /TO=pname [/RELocate=lname /TO=pname ...] ][/SQLAUTHentication=INTegrated|SQLuserid] w]GINTegrated ( cfg )[/SQLBUFFers=numsqlbuffers] w]G0 ( cfg )[/SQLBUFFERSIze=sqlbuffersizeinkb] w]G1024 ( cfg )[/SQLPassword=sqlpasswordname] w]G" "[/SQLSERVer=sqlservername] w]GqúW ( cfg )[/SQLUSer=sqlusername] w]Gsa[/STANDby=undofilename][/STOPAT=datetime][/STOPATMark=markname [/AFTER=datetime] ][/STOPBEFOREMark=markname [/AFTER=datetime] ][/STRIPes=numstripes] w]G1 ( cfg )[/TSMNODe=tsmnodename] w]Gdsm.opt [/TSMOPTFile=dsmoptfilename] w]Gdsm.opt[/TSMPassword=tsmpassword] w]Gdsm.opt

Help 4-Set

ⁿOG

tdpsqlc help set

ΘXG


TDPSQLC Set PARMname=value[/CONFIGfile=configfilename] w]Gtdpsql.cfg

Σñ PARMname HΣiαOGBUFFers=numbuffers (2..8)BUFFERSIze=buffersize (64..8192)DATEformat=dateformatnum

1 MM/DD/YYYY2 DD-MM-YYYY3 YYYY-MM-DD4 DD.MM.YYYY5 YYYY.MM.DD

DIFFESTimate=±r (1..99)FROMSQLserver=SQL Server WLANGUAGE=3 rΩX

5 ⁿOµ 81

ENU ⁿíσPTB ΦσσCHS ΘñσCHT cΘñσFRA kσDEU wσITA qjQσJPN ΘσKOR σESP ΦZσ

LOGFile=ΘxWLOGPrune=[numdays|No] (0..9999) | NoMOUNTWaitfordata=[Yes|No]NUMBERformat=rµí1 n,nnn.dd2 n,nnn,dd3 n nnn,dd4 n nnn.dd5 n.nnn,dd6 n’nnn,dd

SQLAUTHentication=[INTegrated|SQLuserid]SQLBUFFers=numsqlbuffers (0..999)SQLBUFFERSIze=sqlbuffersize (64..4096)SQLSERVer=sqlservernameSTRIPes=numstripes (1..32) A≤ SQL Server 7.0

(1..64) A≤ SQL Server 2000TIMEformat=timeformatnum

1 HH:MM:SS2 HH,MM,SS3 HH.MM.SS4 HH:MM:SSA/P


Set ⁿO

set ⁿO≤ Data Protection for SQL itmM∩Coxsbt

mñCw]O tdpsql.cfgCtm]i]wb GUI sΦ\αϕCñ (\

25y\αϕCz)C

: pG*ⁿwtmAh tdpsql.cfg AuH lastprunedate w]tmCpGⁿwLúsbAhw]C

yk"" TDPSQLC Set BUFFers= numbuffers

BUFFERSIze= buffersizeinkbDATEformat= dateformatnumDIFFESTimate= numpercentFROMSQLserver= fromsqlserverLANGuage= languageLOGFile= logfilenameLOGPrune= numdays

NoNUMBERformat= numberformatnumMOUNTWaitfordata= Yes

NoSQLAUTHentication= INTegrated

SQLuseridSQLBUFFers= numsqlbuffersSQLBUFFERSIze= sqlbuffersizeinkbSQLSERVer= sqlservernameSTRIPes= numstripesTIMEformat= timeformatnum

"$

p set míA\ 95ySetzC

Set ∩G""


=configfilename

"$

p set ∩íA\ 100y∩zC

Set ΘXdUCⁿw mutalisk °A@tmñw] SQL °AC

ⁿOG

tdpsqlc set sqlserver=mutalisk

ΘXG


ACO5054I wQ]wC

UCΓⁿON sqlbuffers M stripes l]w≤ 2C

ⁿOG

5 ⁿOµ 83

tdpsqlc set sqlbuff=2

ΘXG


ACO5054I wQ]wC

ⁿOG

tdpsqlc set strip=2

ΘXG


ACO5054I wQ]wC


Changetsmpassword ⁿO

changetsmpassword ⁿO≤ Data Protection for SQL Tivoli Storage

Manager KXC

yk"" TDPSQLC CHANGETSMPassword

oldpassword newpassword verifypassword"$

p c h a n g e t s m p a s s w o r d míA\ 9 9

yCHANGETSMPasswordzC

∩G""


=configfilename

"



"

"=60 [ cfg ]


=[dsm.opt ]/TSMNODe

=tsmnodename

"

"=dsm.opt


"$

p changetsmpassword ∩íA\ 100y∩zC

Changetsmpassword ΘXdUCπ≤ Tivoli Storage Manager KXC

ⁿOG

tdpsqlc changetsmp fert sqlv2 sqlv2

ΘXG


ACO0260I wQ≤KXC

5 ⁿOµ 85

6 ⁿOµ

ú Data Protection for SQL iⁿOµ (tmM∩) π

íCpⁿOµ@ykA\ 5 46yData Protection for SQL ⁿ

OzC

m

m≤ Data Protection for SQL ⁿOºß∩ºeCíi@

m&≈½≤¼AH≤ queryBset M changetsmpassword ΣL

mC

ϕ 10. Data Protection for SQL m

ⁿO m

Backup dbname H 6 ≈¼∩ 87

Query SQL dbname

TDP

TSM dbname H 8 ∩

92

Restore dbname H 6 ≈¼∩ 87

Inactivate dbname H 6 ≈¼∩ 87

Set 15 ∩ 95

Change TSMPassword

oldpassword newpassword verifypassword 99

dbname

*|dbname,...ⁿwn≈BBd SQL °AΩwWC

N

v b dbname * @Ur NC@XsrC

ⁿwUrϕ SQL °AWΩwC

v 4ⁿw tempdbFΩwLk≈A]ªObC SQL Server

sCbUr@ñú]AªC

v pG⌠≤ dbname ]AµSϕrAzH@∩'Aϕ

dbnameC

v SQL ΩwWnjpgC

v Tivoli Storage Manager include/exclude BzM SQL Ω

wWC

≈½≤¼

UCmOboX Data Protection for SQL backupBrestoreBinactivate M queryⁿOi≈½≤¼G


ϕ 11. Data Protection for SQL ≈½≤¼

≈½≤¼

FIle 88

Full 88

Difffull 89

Group 89

Log 90

Set 91

* (td TSM )

U@N@@íC

FIle=*|logicalfilename,...file ≈]tzⁿw SQL °A ΦeC"≤i≈í

í¡A"≤αDAo≈π SQL Ωwú%ΩAziH

∩C

YA∩izⁿw SQL Ωw≈½≤C

YA∩zⁿw SQL Ωw@ñ≈½≤C

pd Tivoli Storage Manager ≈½≤÷ΩTA\ 93 C

logicalfilename ⁿwzn≈ SQL °AΩw ΦW

C

NG

v ÷≤z≈ SQL ΩwAzbºΘx≈ºßiµ≈C

v C@ⁿOIsiⁿwWL@C

v s≈½≤P SQL ΩwñPW⌠≤@ñ≈½≤C

v ziHb logicalfilename ñ * UrA NX 0 hrC

ⁿwUrϕ SQL °AΩwñ ΦC

: ]C@ Φ≈b Tivoli Storage Manager Server W

O≈½≤AHⁿwUr∩ SQL °AΩwñC@

Φú!O≈½≤C

v Y logicalfilename ]AµSϕrA'AϕªC

v logicalfilename njpgC

v zúα∩UC SQL Ωw⌡µ≈G

– π SQL °A∩bdIIΘxΩwC

– SQL Server 2000 SIMPLE "¼ΩwC

v zLk∩@ⁿw /recovery C

v SQL °Au'v@nzNⁿvTs≈¿@µ

CúD⌡µµ≈AhzLk≈ⁿvTsñC SQL °

ATºⁿXOⁿvTsCYnQ¿≈Az

⌡µπΩw≈(⌡µⁿvTs≈C

FULL full Ωw≈]t SQL °AΩweAHn@P

¼≈ΩwºΘxeC


C@ SQL Ωw≈b Tivoli Storage Manager Server WO

≈½≤CsπΩw≈½≤P SQL Ωw²e@ñ

≈½≤C]A⌠≤@ñπ≈½≤AH⌠≤@ñsBsB

BtºΘx≈½≤C

YA∩izⁿw SQL ΩwπΩw≈½≤C

YA∩zⁿw SQL Ωw@ñπΩw≈½

≤C

DIFFerentialtºΩw≈u]t SQL °AΩw±@π≈ºß≤í

≈A@Pn¼≈ SQL ΩwºΘxeC]Atº≈

q±π≈$(íC∩AYúMeπΩw≈

ºßOΘx≈C

pA∩ibíA]ª N@ºΘx≈

C

pA"≤C@ SQL Ωw≈b Tivoli Storage Manager Server W

O≈½≤AHstºΩw≈½≤P SQL Ωw⌠

≤@ñtº½≤C

Group=*|groupname,...group ≈]tzⁿw SQL °AseC

ϕ∩ SQL Ωwϕµ'ⁿwYsABϕµ'

n≈As≈DC,ΣG

v ún≈ SQL Ωwñú≤ΣLϕµ'i≈íC

v YsPΣL SQL Ωws≤úPWAB

nAhziíC]Azun SQL Ωw

sC

groupname ⁿwzn≈ SQL °AΩwsWC

6 ⁿOµ 89

NG

v C@ⁿOIsiⁿwWL@C

v ss≈½≤P SQL ΩwñPW⌠≤@ñs≈½

≤C

v ziHb groupname ñ * UrA NX 0 hrC

v ⁿwUrϕ SQL °AΩwñsC

: ]C@s≈b Tivoli Storage Manager Server WO

≈½≤AHⁿwUr∩ SQL °AΩwñC@s

ú!O≈½≤C

v Y groupname ]AµSϕrA'AϕªC

v groupname njpgC

v ÷≤z≈ SQL ΩwAzbºΘx≈ºßiµs≈C

v zLk∩UC SQL Ωw⌡µs≈G

– π SQL Server TRUNCATE LOG ON CHECKPOINT ΩwC


v zLk∩s@ⁿw /recovery C

v SQL Server '@nzNⁿvTs≈¿@µC

úD⌡µµ≈AhzLk≈ⁿvTsµ@sC SQL

Server TºⁿXOⁿvTsCYnQ¿s≈A

z⌡µπΩw≈(⌡µⁿvTs≈C

Log or Log=*|logobjectname,...Θx≈]ts¿Θx≈ß@ñ SQL °AΩwºΘx

eC"≤∩n SQL Ωw≈(AHi≈íC

: Y≈@Alog ú⌠≤CúLAYBd@A

log Ur logobjectname C

Y backup H&ⁿOA logobjectname iⁿwnBd

Θx≈½≤Cb logobjectname * @UrA NC@X

0 hrCⁿwUrϕ SQL ΩwñΘx≈½≤C

NG

v Y backup H&ⁿOAhC@ⁿOIsiⁿwWL@C

v ziH εºΘxjpAΦkO²Θx≈IºΘxD@ñí

≈Cw]C

v " /truncate=no AziH≈laBúiúi SQL

Server ΩwºΘxC

v C@≈Θxb Tivoli Storage Manager Server Wπ@W

O≈½≤CsΘx≈½≤ú⌠≤@ñ≈½≤ (ú set≈H&ΣL≈¼)CúDπΩw≈½≤ SQL Ωw

@ñ≈½≤AhΘx≈½≤úP Tivoli Storage Manager Server

BzC]AYπΩw≈úOg⌡µú⌡µA

ziH inactivate ⁿOΘx≈½≤C

v zLk∩UC SQL Ωw⌡µΘx≈G




– b∩ SQL Ωw⌡µF*Oⁿ≤ºípUAπ SQL °A SELECT

INTO / BULKCOPY ∩ SQL Server 7.0 ΩwC

Set Set=*|setobjectname,...set ≈]tz /files /groups ⁿw SQL °As

eC

: Y≈@Aset ú⌠≤CúLAYBd@AsetUr setobjectname C

Y backup H&ⁿOA setobjectname iⁿwnBd

≈½≤Cb setobjectname * @UrA NC@X

0 hrCⁿwUrϕ SQL Ωw≈½≤C

NG

v Y backup H&ⁿOAziH∩CⁿOIshⁿwC

v YOºípSϕµ≈A∩CoípΣñº@N

OA SQL Server nNYs≈@µ²LkπΩ

w≈C\ñ file group íASOO÷≤u'v@C

v C@ SQL Ωw≈b Tivoli Storage Manager Server WO

≈½≤C≈P SQL °AΩw set ≈@í≈

sA]tbµ@≈½≤ñCNGoP group file ≈úPA

]YMs≤P SQL °AΩwA]C@

sO≈½≤C

v s≈½≤ú⌠≤@ñ≈½≤ (ú log ≈H&ΣL≈¼)CúDπΩw≈½≤ SQL Ωw@ñ≈½≤A

h≈½≤úP Tivoli Storage Manager Server BzC

]AYπΩw≈*⌡µúOg⌡µAziH inactivate ⁿO≈½≤C

v ÷≤z≈ SQL ΩwAzbºΘx≈ºßiµ≈C

v zLk∩UC SQL Ωw⌡µ≈G



v zLk∩ restore set @ⁿw /recovery C

:

1. uboX inactivate M query TSM ⁿOziHⁿwUr (*) N

≈½≤¼CY inactivateAoⁿw SQL Ωw@ñ≈½

≤C&A∩≤ΣLⁿO≈½≤¼Ainactivate ≈½≤¼OnABSw]C

2. fileBgroupBlog M set iMµ (i½yk)ABiⁿw@HWC

pG

file=a,b file=a file=b

3. ∩h½Ωúns≥CpG

file=a group=y file=b group=z

6 ⁿOµ 91

QueryboX Data Protection for SQL query ⁿOⁿwUCΣñ@G

Query SQL *|dbname,...oπe SQL °A÷ΩTC≤@ SQL °AOeΩ

TA\ 100y∩zñ /sqlserverC

bdSw SQL Server 7.0 °AAn]AUCΩTG

v W

v

Yzⁿw /compatibilityinfoGv w] ID

v w]rX ID

v Unicode yÑ⌠ ID

v Unicode ±í ID

v O¼A

bdSw SQL Server 2000 °AAn]AUCΩTG

v W

v

Yzⁿw /compatibilityinfoGv O¼A

dbname ⁿwbe SQL °AWnπ÷ΩTΩwCp÷Ω

TA\ 87ymzñ dbnameC

bdSw SQL Server 7.0 °AΩwAn]AUCΩTG

v °AW

v ΩwW

v ΩwwtmΩí

v wΩwí

v ΩwwtmΘxí

v wΩwΘxí

v Ωw∩ (SELECT INTO / BULK COPYBTRUNCATE LOG ON

CHECKPOINT...ÑÑ)

Yzⁿw /compatibilityinfoGv °A

v °AO¼A

v Ωweh

v °Aw] ID

v °Aw]rX ID

v °A Unicode yÑ⌠ ID

v °A Unicode ±í ID

bdSw SQL Server 2000 °AΩwAn]AUCΩTG

v °AW

v ΩwW

v ΩwwtmΩí

v wΩwí


v ΩwwtmΘxí

v wΩwΘxí

v Ωw∩ (SELECT INTO / BULK COPYBTRUNCATE LOG ON

CHECKPOINT...ÑÑ)

Yzⁿw /compatibilityinfoGv °A

v °AO¼A

v Ωweh

Query TDPoπ Data Protection for SQL WMΩTAHe Data Protection

for SQL tmeC≤@tmOeΩTA\ 100

y∩zñ /configfileC

Query TSM *|dbname,...oπ Tivoli Storage Manager API M Tivoli Storage Manager Server

ΩTC

dbname ⁿWbe SQL °Añ≈½≤≤e Tivoli Storage

Manager Server MIWⁿwΩwCpGⁿw½≤b SQL Ωwñ

L≈½≤Ahúπ⌠≤WCp÷ΩTA\ 87ym

zñ dbnameC

dbname,...* Ur∩π@h SQL Ωw≈½≤

÷ΩTC

TSM dbname d⌠≤≈½≤An]AUCΩTG

v SQL °AW

v SQL ΩwW

v ≈½≤¼

v ≈½≤@ñ/D@ñ¼A

v ≈½≤ Data Protection for SQL Θí

v ≈½≤ Data Protection for SQL jp

v Data Protection for SQL ≈½≤½≤W

v ≈½≤ñΩÑqq

pGzⁿw /compatibilityinfoAhn]AUCΩTGv SQL °A

v SQL Server O¼A

v ≈½≤ Data Protection for SQL

v SQL Ωweh

v SQL ΩwwtmΩí

v SQL ΩwwΩí

v SQL ΩwwtmΘxí

v SQL ΩwwΘxí

v SQL Ωw∩

pGOq SQL Server 7.0 ΩwG

v SQL °Aw] ID

v SQL °Aw]rX ID

v SQL °A Unicode yÑ⌠ ID

v SQL °A Unicode ±í ID

6 ⁿOµ 93

:

1. zL query TSM ∩ /active M /allAz]iHMwnπ≈½≤C

2. ≤@ SQL °AOeΩTA\ 100y∩z

ñ /sqlserverC

3. e Tivoli Storage Manager Server Oⁿwbe Tivoli Storage Manager

∩ñC

4. ≤ Tivoli Storage Manager ∩OeΩTA\ 100

y∩zñ /tsmoptfile C

5. ≤@ Tivoli Storage Manager IOeApΩTA\

100y∩zñ /tsmnodeC

6. pGⁿw SQL ΩwS≈½≤Ahúπ⌠≤ΩTC

d TSM ∩

po∩@δΩTA\ 87y≈½≤¼zC

FIle=*|logicalfilename,...oπ@h SQL Ωw (e SQL °ABbµ

Tivoli Storage Manager Server MIW) ≈½≤÷ΩTC

p query TSM ⁿOºU∩A\ 100y∩

zñ /fileinfo M /mountwaitC

Full oπ@h SQL Ωw (e SQL °ABbµ

Tivoli Storage Manager Server MIW) π≈½≤÷ΩTC

Difffulloπ@h SQL Ωw (e SQL °ABbµ

Tivoli Storage Manager Server MIW) tº≈½≤÷ΩTC

Group=*|groupname,...oπ÷≤e SQL °Añ≤e Tivoli Storage Manager

Server MIW@h SQL Ωws≈½≤ΩTC

Log=*|logobjectname,...oπ÷≤e SQL °Añ≤e Tivoli Storage Manager

Server MIW@h SQL Ωw@hΘx≈½≤Ω

TC

logobjectname ⁿwΘx≈½≤nπΣ÷ΩTCb

logobjectname * @UrA NC@Xs

rCⁿwUrϕ SQL ΩwñΘx≈½≤C

Set=*|setobjectname,...oπ÷≤e SQL °Añ≤e Tivoli Storage Manager

Server MIW@h SQL Ωw@h≈½≤Ω

TC

setobjectname ⁿw≈½≤nπΣ÷ΩTCb

setobjectname * @UrA NC@Xs

rCⁿwUrϕ SQL Ωw≈½≤C

Types o÷@h SQL Ωw (e SQL °ABbµ


Tivoli Storage Manager Server MIW) ≈½≤≈¼π

KnCπt@h≈½≤≈¼C

pGⁿw /all ∩Ah]AD@ñ≈½≤qC

/compatibility /fileinfo ∩úαP types @ⁿwC

: b fullBdiffBlogBfileBgroup M set Ue\ /fileinfo ∩CH /fileinfo∩πΩT]ApUG

v SQL ΩwsW

v SQL Ωwwtmsí

v SQL Ωwwsí

v SQL Ωw ΦW

v SQL ΩwΩΘW

v SQL Ωwwtmí

v SQL Ωwwí

SetYnb Data Protection for SQL tmñ]ww]AboX set ⁿOⁿwUCΣñ@C

BUFFers=numbuffers

buffers ⁿwFb Data Protection for SQL M Tivoli Storage Manager

API ºíeΩ≤C@ΩÑqΩw qC

ziHW[w qWiúαA²]]W[xsΘqCC@

w úO /buffersize ⁿwjpC

numbuffers ⁿOnΩw qCrd≥ 2 8C

l 3C

BUFFERSIze=buffersizeinkb

buffersize ⁿw buffers ⁿwC@ Data Protection for SQL w

jpC

buffersizeinkb Ωw jp (KB)Crd≥ 64 8192C

lw] 1024C

DATEformat=dateformatnum

/dateformat ∩ znπΘµíC

dateformatnum d≥ 1 5Cl 1CⁿwUCµíG

1 MM/DD/YYYYC

2 DD-MM-YYYYC

3 YYYY-MM-DDC

4 DD.MM.YYYYC

5 YYYY.MM.DDC

Y≤ dateformat Aiα∩ Data Protection for SQL Θx (

w]A tdpsql.log) ú!úQnR∩CziH⌡µUCΣñ@@

AKóhΘxΩG

6 ⁿOµ 95

v b≤ dateformat ºßAb⌡µ Data Protection for SQL ºeA

²s@ΘxC

v Q /logfile ⁿwsΘxC

DIFFESTimate=numpercent

YO Data Protection for SQL backup ⁿOtºΩw≈A

/diffestimate ⁿwπ SQL ΩwñeπΩw≈ºßwg≤

w⌠í≈C⌠pOnA] SQL Server *úPwtº≈jp

ΦkAB Tivoli Storage Manager Server nTjp⌠pAα

tmíM±m½≤CTivoli Storage Manager Server oPwDnxs

ΘxsO¼≈íi]t SQL Ωw≈C]C@ⁿw SQL

ΩwO≈½≤AH⌠pOaMC@ⁿw SQL Ω

wC

numpercent d≥ 1 99C]tº≈O≈ΩwAH

rOⁿeπΩw≈ºß≤Ωw,±Cl 20C

NG

v Yw⌠πp≤Ω≤Ahiα]≈jpj≤ Tivoli Storage

Manager Server ªtmíAjε Tivoli Storage Manager Server º

ε≈C

v pG⌠pj≤Ω≤qAhiαjε°AN≈½≤±mb±

nÑh≤¬xsΘxsÑhAiαObiúCΘWC

FROMSQLSERVer=sqlservername

fromsqlserver ⁿwqñ≈u≈½≤v SQL °ACn

SQL °AW ( M≤ sqlserver ) úP≤qñ≈½≤

SQL °AWAnCp sqlservername íA\ 111

C

∩ query TSM M inactivate ⁿO fromsqlserverA²O∩ query SQLⁿO sqlserverC

w] sqlserver Data Protection for SQL tmñ]wC

LANGuage=language

HTrXⁿwnπTºyÑG

CHS Θñσ

CHT cΘñσ

DEU wσ

ENU ⁿíσ (oOw])

ESP ΦZ0σ

FRA kσ

ITA qjQσ

JPN Θσ

KOR σ

PTB /Φσ0σ

LOGFile=logfilename

logfile iⁿw Data Protection for SQL ú!íΘxWCí

ΘxO²@½n≤Apw¿ⁿOTºCΘxP SQL Server

ΘxúPC


|

|

||

||

||

||

||

||

||

||

||

||

logfilename iO Data Protection for SQL ú!ºíΘxWC

NG

v YⁿwúsbAhªCYsbAhNsΘx

[ΣñC

v Wi]Aπ⌠FúLAYz*ⁿw⌠AhgJ Data Protection

for SQL w²ñC

v zLk Data Protection for SQL íΘxOⁿCY*ⁿw /logfileAhΘxO²gJw]ΘxñCw]ΘxO tdpsql.logC

LOGPrune=numdays|Nologprune iR∩ Data Protection for SQL íΘxⁿwxs#

Cw]A⌡µ Data Protection for SQL C@#ú⌡µ@

ΘxRúFúLA∩6i²zΘxRúC

numdays NϕxsΘx#C

NG

v Yⁿw numdaysAΣd≥iq 0 9999Cl 60C 0 Rú Data

Protection for SQL íΘxñµⁿOH&C

v Yⁿw noAhúRúΘxC

NUMBERformat=numberformatnum

numberformat iⁿw Data Protection for SQL πrµíC

numberformatnum d≥iq 1 6Cl 1CoⁿwUCµíG

1 1,000.00

2 1,000,00

3 1 000,00

4 1 000.00

5 1.000,00

6 1’000,00

MOUNTWaitfordata=Yes|NoY Tivoli Storage Manager Server tmbiúCΘW (pa1

CΘ) xs≈ΩAh Tivoli Storage Manager Server iαⁿX Data

Protection for SQL bÑⁿnxsΘCYo!oípA∩

i²zⁿwOn Data Protection for SQL backup M restore ⁿOÑCΘⁿAOεe@Cl yesC

NG

v YzΩÑqAhnÑÑqlCΘiA Data

Protection for SQL i¿AúLunΣCΘiA Data Protection for SQL

NiHlC@ΩÑqC] SQL Server bÑqíte

ΩΦíAY⌠≤ÑqSiCΘAhC@ÑqßiαÑ

ªvt@ÑqCΘ¿iCbípUAiα¿q

°Ññε Data Protection for SQL ⁿOCouα"ε Data

Protection for SQL í (÷¼ⁿOú°íΘJ control-c) ¿C

v Y meta ½≤zO]niúCΘAh Data Protection for SQL

ÑCb≈@íAbeΩºßo!ÑA]

6 ⁿOµ 97

nÑΩ½≤πºß meta ½≤Cb@íApGn

meta ΩAhbe⌠≤ΩºeAo!ÑC

v Yⁿw no ²n⌠≤iúCΘAh Data Protection for SQL ε

ⁿOXTºCY meta ½≤zOniúCΘAh]p

F²Ob≈íAnÑΩe¿ºßAo!ⁿOεC

G

v ∩úvT Data Protection for SQL query ⁿOAªuzL query TSM/fileinfo [HⁿwC

v pPb Data Protection for SQL 1 ñATivoli Storage Manager ∩

ñ TAPEPROMPT ∩úAvT@C

SQLAUTHentication=INTegrated | SQLuseridⁿwnJ SQL °AvíC

integrated ⁿw Windows NT Windows 2000 τCznJ Windows

ID PzNnJ SQL °A ID O@CoOw]C

sqluserid ⁿw SQL Server ID vCsqluserid ⁿw ID OzNnJ SQL °A IDC ID SQL

Server SYSADMIN Tw°AñΓC

SQLBUFFers=numsqlbuffers

sqlbuffers iⁿw SQL Server b SQL Server M Data Protection for SQL

ºíeΩΩw C

numsqlbuffers ϕΩw qCrd≥ 0 999Cw

] 0Cϕ sqlbuffers ] 0 ASQL Pwh(w C

numsqlbuffers ⁿ¡≤xsΘ¡εC

pGzⁿwúO 0AhzⁿwrÑ≤j≤zΩÑq

qCY SQL Server 7.0Aiⁿwh 32 ÑqAY SQL Server

2000Aiⁿwh 64 ÑqCpGzⁿwúO 0ABb≈í¼

TºAⁿw 0 ½s≈C

SQLBUFFERSIze=sqlbuffersizeinkb

sqlbuffersize ⁿwC@w jp (" sqlbuffers ⁿw)ASQL

Server ªNΩe Data Protection for SQLC

sqlbuffersizeinkb Ωw jp (KB)Crd≥ 64

4096Clw] 1024C

SQLSERVer=sqlservername

sqlserver ⁿw Data Protection for SQL nJ SQL °ACoO≈

½≤Σñ SQL °ACúLAY≈½≤Oqt@ SQL °AW

Az fromsqlserver C

∩ query SQL ⁿO sqlserverA²O∩ query TSM M inactivate ⁿO fromsqlserverC

pi@BΩTA]AⁿWΩMONA\ 111 C

STRIPes=numstripes

stripes ⁿwb≈@ñΩÑqC


numstripes d≥iq 1 32 (A≤ SQL Server 7.0)AYO SQL Server

2000Ahq 1 64Cw]@l 1C

pΣLNA\ 114 C

TIMEformat=timeformatnum

timeformat iⁿw Data Protection for SQL πíµíC

timeformatnum d≥iq 1 4Cl 1CoⁿwUCµíG

1 23:00:00

2 23,00,00

3 23.00.00

4 11:00:00A/P

Y≤ timeformat Aiα∩ Data Protection for SQL Θx (

w]A tdpsql.log) ú!úQnR∩CziH⌡µUCΣñ@@

AKóhΘxΩG

v b≤ timeformat ºßAb⌡µ Data Protection for SQL ºeA

²s@ΘxC

v Q /logfile ⁿwsΘxC

CHANGETSMPasswordpGzb changetsmpassword ⁿOñ*ⁿwUCAhúzG

oldpassword

ⁿwzn≤ (e) Tivoli Storage Manager KXC

newpassword

ⁿws Tivoli Storage Manager KXC

Tivoli Storage Manager KXújpgAi" 1 63 UCr¿G

v r$ A Z

v r 0 9

v SϕrG[ (+)ByI (.)Bu (_)BΘ (--) M &

verifypassword

Aⁿws Tivoli Storage Manager KXAHτ newpassword OTC

6 ⁿOµ 99

∩

ϕ 12 CX∩AoiHb Data Protection for SQL ⁿOµmº

ßC÷σr$CX∩bCXºπíC

pπC@ⁿOi∩ykA\ 46yData Protection for SQL ⁿ

OzC

ϕ 12. Data Protection for SQL ∩

∩ uí

/ACtive d@ñ≈½≤C 101

/ALl d@ñMD@ñ≈½≤C 101

/BUFFers ⁿwC@ΩÑq Data Protection for SQL

Ωw qC

101

/BUFFERSIze ⁿw /buffers ⁿwC@ Data Protection for

SQL jpC

102

/COMPATibilityinfo d≈½≤P SQL °AeC 102

/CONFIGfile ⁿw Data Protection for SQL tmWC 102

/DBOonly ε@δs ΩwC 103

/DIFFESTimate w⌠ SQL ΩwqeπΩw≈ºß≤

í≈C

103

/FILEInfo dc¿≈½≤sMC 103

/FIles ⁿw≈M@ ΦC 103

/FROMSQLSERVer ⁿwqñ≈½≤ SQL °AC 104

/GRoups ⁿw≈M@sC 104

/INTO ⁿwúPΩwnN≈½≤@

SQL °AΩwC

104

/LOGESTimate w⌠ SQL ΩwqeΘxBtºπΩw

≈ (SQL Server 2000) ºß"≤*Oⁿ@≤

í≈C

104

/LOGFile ⁿw Data Protection for SQL ú!íΘxC 105

/LOGPrune ⁿw Data Protection for SQL íΘxR∩

xs#C

105

/MOUNTWait ⁿw Data Protection for SQL OÑ Tivoli Storage

Manager Server nⁿnxsΘC

106

/OBJect dBⁿw≈½≤C 107

/OLDerthan ⁿwgí≈½≤C 107

/PARTial SQL Server 2000 @í≈ΩwC 107

/Quiet ñⁿO¼AΩTπC 108

/RECOVery ⁿwOnúb≈°AWΩwC 108

/RELocate /TO SQL ΩwsmC 109

/REPlace b@í g SQL C 109

/SQLAUTHentication ⁿwnJ SQL °AvíC 110

/SQLBUFFers ⁿw SQL Server b SQL Server M Data Protection

for SQL ºíeΩw C

110


ϕ 12. Data Protection for SQL ∩ (≥)

∩ uí

/SQLBUFFERSIze ⁿw /sqlbuffers ⁿwC@w jpC 110

/SQLPassword ⁿw Data Protection for SQL nJ SQL °A

SQL KXC

110

/SQLSERVer ⁿw Data Protection for SQL nJ SQL °AC 111

/SQLUSer ⁿw Data Protection for SQL nJ SQL °A

WC

112

/STANDby ≈ SQL °AC 112

/STOPAT SQL ΩwⁿwíIC 112

/STOPATMark/AFTER

ⁿWíIAªiαObⁿwíIº

ßC (SQL Server 2000)

113

/STOPBEFOREMark/AFTER

ⁿWíIAªiαObⁿwíIº

ßC (SQL Server 2000)

113

/STRIPes ⁿwb≈@ñΩÑqC 114

/TRUNCate ⁿwORú SQL ΩwºΘxñúAn

C

115

/TSMNODe ⁿw Data Protection for SQL nJ Tivoli Storage

Manager Server Tivoli Storage Manager IWC

115

/TSMOPTFile ⁿwn Tivoli Storage Manager ∩C 115

/TSMPassword ⁿw Data Protection for SQL nJ Tivoli Storage

Manager Server Tivoli Storage Manager KXC

116

UCOC@∩íG

/ACtive

/ALl Y query TSM @AhoⁿwzOunπ@ñ≈½≤APπ@ñMD@ñ½≤C

NG

v ziH∩ Data Protection for SQLquery ⁿOⁿwoA²ußⁿw@C

v pGzΓú*ⁿwAhw] /activeC

v /object (\ 107 )A GUI (\ 34 )A

ⁿwD@ñ (@ñ) ≈½≤C

p /all dΘXA\ 78 C

/BUFFers=numbuffers

/buffers ⁿwFb Data Protection for SQL M Tivoli Storage Manager

API ºíeΩ≤C@ΩÑqΩw qC

numbuffers ⁿOnΩw qCrd≥ 2 8Cw

] 3C

NG

v ziHW[w qWiúαA²]]W[xsΘqCC@

w úO /buffersize ñⁿwjpC

6 ⁿOµ 101

v w] Data Protection for SQL tmñw itm∩ⁿwC

@l 3C

v pGzⁿw /buffersAhªN Data Protection for SQL tm

ñxsCⁿwú≤tmñC

v pGzⁿw /buffers ²*ⁿw numbuffersAhw] 3C

/BUFFERSIze=buffersizeinkb

/buffersize ⁿw /buffers ⁿwC@ Data Protection for SQL

w jpC

buffersizeinkb Ωw jp (KB)Crd≥ 64 8192C

w] 1024C

NG

v ÷MW[w qiWiúαA²ª]W["MwxsΘ

qC

v w] Data Protection for SQL tmñw itm∩ⁿwC

@l 1024C

v pGzⁿw /buffersizeAhªN Data Protection for SQL t

mñxsCⁿwú≤tmñC

v pGzⁿw /buffersize *ⁿw buffersizeinkbAhw] 1024C

/COMPATibilityinfoY query @Aπ≈½≤P SQL °Ae÷ΩTC

Y SQL Server tm∩eAzα≈≈½≤ SQL °AC

ϕzⁿwACX SQL M Data Protection for SQL tmΩTA≤U

PwY≈½≤∩ SQL °AÑOTA≤UDRCpπe

ñMµA\ 93 C

NG

v zúαb query TSM ⁿOWPⁿwP types C

v eqϕPCMApGzP∩ SQL °AM≈½≤Gi

AhrXiαúPAúLAOriαPúPrπ

CLXC

v M SQL Server 7.0 úPASQL Server 2000 e\b°ABΩwBµM

hWúPCooeDú½nA²6MODC


/configfile ⁿw Data Protection for SQL tmWA]t Data

Protection for SQL itm∩CpeΩTA\ 95

ySetzC

NG

v configfilename i]tπ⌠CpG configfilename ú]t⌠Ahª

w Data Protection for SQL ²C

v pG configfilename ]tµA'AϕªC

v pGz*ⁿw /configfileAhw] tdpsql.cfgC

v pGzⁿw /configfile ²*ⁿw configfilenameAhw]

tdpsql.cfgC


/DBOonlyⁿw /dboonly ε@δbΩwQPwis ºes ªC

Y SQL Server 7.0AiTwb@ºß]wΩw∩ DBO USE

ONLYC

Y SQL Server 2000AiTwb@ºß]wΩw∩

RESTRICTED USERC

/DIFFESTimate=numpercent

YtºΩw≈A /diffestimate ⁿwπ SQL ΩwqeπΩ

w≈ºß≤w⌠í≈C⌠pOnA] SQL Server *úP

wtº≈jpΦkAB Tivoli Storage Manager Server nTjp⌠

pAαtmíM±m½≤CTivoli Storage Manager Server o

PwDnxsΘxsO¼≈íi]t SQL Ωw≈C]C

@ⁿw SQL ΩwO≈½≤AH⌠pOaMC@

ⁿw SQL ΩwC

numpercent d≥ 1 99C]tº≈O≈ΩwAH

rOⁿeπΩw≈ºß≤Ωw,±Cl 20C

NG



ε≈C



v pGzb Data Protection for SQL ⁿOWⁿw /diffestimateAhªN Data Protection for SQL tmñCMAb Data Protection

for SQL ⁿOWⁿwú≤ Data Protection for SQL tmñC

/FILEInfoY query TSM ⁿOAi∩≈¼π≈½≤ΩTCYtºMΘx≈½≤A /fileinfo ib≈πΩwñsCpπΩT¼A\ 93 C

Y Data Protection for SQL meta ½≤ Tivoli Storage Manager zO*

ⁿwMxsAi+\ⁿCp÷ΩTA\ 106

C

/FIles=*|logicalfilename,...Y≈@A /files iⁿw]A≈ñ ΦWC

Y@A /files iⁿwπBs≈½≤ ΦWC

logicalfilename ⁿwzn≈ SQL Server Ωw ΦWC

NG

v ziHb logicalfilename ñ * UrA NX 0 hrC

"ⁿwUrAziHⁿX SQL °AΩwñ ΦC

v Y logicalfilename ]AµSϕrA'AϕªC

6 ⁿOµ 103

v ziHOⁿw /files /groupsAPⁿwΓCYAoM

π≈½≤CYw∩ⁿw /files /groups ΓAh(X /groups /files Wµº@½≤C

/FROMSQLSERVer=sqlservername

YA /fromsqlserver iⁿw≈½≤b SQL °AC

n SQL °AW ( M≤ /sqlserver ) úP≤qñ≈

½≤ SQL °AWAnCp sqlservername íA

\ 111 C

∩ query TSM M inactivate ⁿO /fromsqlserverA²O∩ query SQLⁿO /sqlserverC\ 77 ñ÷ft /fromsqlserver query

inactivate dC

w] /sqlserver Data Protection for SQL tmñ]wC

NG

v YΓ SQL °AWúPAY /fromsqlserver DOw]ΩAz6C

v N SQL Ωwt@ SQL °AºßA SQL ΩwnJiαP

t@ SQL °AnJúCAXAziH SQL xs

SP_CHANGE_USERS_LOGIN MΣ≤o SQL nJúíC

/GRoups=*|groupname,...

Y≈@A /groups iⁿwznJ≈ñsWC

Y@A /groups iⁿwznπ≈½≤sW

CYw∩ⁿw /files /groups ΓAh(X /groups /files Wµº@½≤C

groupname iⁿwzn≈ SQL °AΩwsWC

NG

v ziHb groupname ñ * UrA NX 0 hrCⁿ

wUrϕ SQL °AΩwñsC

v Y groupname ]AµSϕrA'AϕªC

v ziHOⁿw /files /groupsAPⁿwΓC

/INTO=dbname

Y@A/into iⁿwzn≈½≤Σñ SQL °AΩwC

SQL °AΩwWúP≤≈½≤ΩwWAn

C

pΩTA\ 87ydbnamezC

NG

v ϕzⁿw /into AUr (*) iαúXbⁿO dbname /intodbname ñC

v b /into dbname MµⁿO dbname MµñA@P

C

v zµ≈½≤sJ SQL Server ΩwsbA@¿\C

/LOGESTimate=numpercent

P SQL Server 7.0 úPOAYb*Oⁿ@ (p SELECT INTO


|

BULK COPY) ºßA SQL Server 2000 6+\ºΘx≈CSQL Server 2000

kON*Oⁿ@≤xsΘ[ºΘx≈C

Y SQL Server 2000 Θx≈A /logestimate iⁿwßΘxBtºπΩw≈ß*Oⁿ@≤ºπ SQL Ωww⌠í≈Cw⌠

OnA] SQL Server úúΦkPw*Oⁿ≤jpA Tivoli

Storage Manager Server nT%jpw⌠tmím½≤C]

C@ⁿw SQL ΩwO≈½≤AH⌠pOaM

C@ⁿw SQL ΩwC

numpercent d≥iq 0 99C]π*Oⁿ≤ºΘx≈≈

ΩwAHoOßΘxBtºπΩw≈ß≤Ω

w,±Cl 0C

NG



ε≈C



v Y∩ Data Protection for SQL ⁿOⁿw /logestimateAhªAD Data Protection for SQL tmñCMA∩ⁿOⁿwú

≤tmñC


/logfile iⁿw Data Protection for SQL ú!íΘxWCí

ΘxO²@½n≤Apw¿ⁿOTºCData Protection for SQL

íΘxP SQL Server ΘxúPC

logfilename iO Data Protection for SQL ú!ºíΘxWC

NG

v YⁿwúsbAhªCYsbAhNsΘx

[ΣñC

v Wi]Aπ⌠FúLAYz*ⁿw⌠AhgJ Data Protection

for SQL w²ñC

v zLk Data Protection for SQL íΘxOⁿCY*ⁿw /logfileAhΘxO²gJw]ΘxñCw]Θx tdpsql.logC

v hP Data Protection for SQL Ω⌡µ@A /logfileⁿwC@ΩúPΘxCoNC@ΩOⁿ'

úPΘxA] εmΘxO²CYLk∩C@ΩⁿwúPΘ

xAiαú!Lk¬ ΘxC

/LOGPrune=numdays|No/logprune iR∩ Data Protection for SQL íΘxⁿwxs#

Cw]A⌡µ Data Protection for SQL C@#ú⌡µ@

ΘxRúFúLAYϕ#ΘxwQRúA∩6i²zΘxRú

TnDRú@ⁿO⌡µΘxC

numdays NϕxsΘx#Cw]ARúñxs 60 #

ΘxC

6 ⁿOµ 105

NG

v Yⁿw numdaysAΣd≥iq 0 9999C0 Rú Data Protection for

SQL íΘxñµⁿOH&C

v Yⁿw noAhúRúⁿOíΘxC

v Y*ⁿw /logpruneAhw] Data Protection for SQL tmñ logprune

itm∩ⁿwCl 60C

v Yⁿw /logpruneAhªAD Data Protection for SQL tm

ñxsCⁿwú≤tmñC

v ziHⁿw /logprune úⁿw numdays noFbípUAw]60C

v Y≤ timeformat dateformat Aiα∩ Data Protection for

SQL Θxú!úQnR∩CpGzb⌡µ@iHR∩Θxⁿ

OAB timeformat dateformat wg≤FA⌡µUCΣñ@@ ε∩ΘxiµúQnR∩G

– s@ΘxC

– Q /logfile logfile ]wAⁿwsΘxC

/MOUNTWait=Yes|NoY Tivoli Storage Manager Server tmbiúCΘW (pa1

CΘ) xs≈ΩAh Tivoli Storage Manager Server iαⁿX Data

Protection for SQL bÑⁿnxsΘCYo!oípA∩

i²zⁿw Data Protection for SQL backupBrestore query TSM /fileinfoⁿOnÑCΘⁿεe@C

ziHⁿwG

Yes Ñaⁿ (backup restore w])C

No úÑaⁿ (query TSM /fileinfo w])C

NG

v YzΩÑqAhnÑÑqlCΘiA Data

Protection for SQL i¿AúLunΣCΘiA Data Protection for SQL

NiHlC@ΩÑqC] SQL Server bÑqíte

ΩΦíAY⌠≤ÑqSiCΘAhC@ÑqßiαÑ

ªvt@ÑqCΘ¿iCbípUAiα¿q

°Ññε Data Protection for SQL ⁿOCouα"ε Data

Protection for SQL í (÷¼ⁿOú°íΘJ control-c) ¿C

v Y backupApG meta ½≤zO]niúCΘAh Data

Protection for SQL ÑA²]nÑΩ½≤¿ºß

meta ½≤AHbΩe¿ºßo!ÑC

v Yⁿw no ²n⌠≤iúCΘAh Data Protection for SQL ε

ⁿOXTºCY meta ½≤zOniúCΘAh]p

CY backupA]nÑ¿Ω½≤ºß meta ½≤AH

nÑeΩwΩºßo!ⁿOεC

v Y*∩ backup restore ⁿw /mountwaitAhw] Data Protection

for SQL tmñ mountwait itm∩ⁿwCl yesCⁿwú≤tmñC

v Yⁿw /mountwaitA²*ⁿw yes ]*ⁿw noAhw] yesC


v Y*b query TSM /fileinfo nDñⁿw /mountwaitAhw] noC

: pPb Data Protection for SQL 1 ñA Tivoli Storage Manager ∩

ñ TAPEPROMPT ∩úAvT@C

/OBJect=*|objectname,...YM@A /object iⁿwⁿw SQL Ωw≈

½≤¼ (Ywⁿw) Sw≈½≤CYd@A /object ibπ]ASw½≤½≤¼C

objectname ⁿwzn≈½≤WC½≤W" Data

Protection for SQL ABOC@≈½≤Cd°≈½

≤WC

NG

v Y@AziH∩ D@ñ≈½≤AúL

GUI iµiα±e÷ (\ 34 )CY*ⁿwAhb

]A@ñ≈½≤C

v ziHb objectname ñ * UrA NX 0 hrCⁿ

wUrϕⁿw SQL Ωw≈½≤¼≈½≤C

pdA\ 72 C

/OLDerthan=numdaysold

Y@A/olderthan ⁿwⁿOih[He≈½≤C

NG

v numdaysold d≥iq 0 9999C

v Yⁿw 0Ah∩ ≈½≤C

v Yⁿw 1AhΘºew∩ ≈½≤C@#ϕñ⌠≤

íí°@π#C

v /olderthan Sw]C

pdA\ 77 C

/PARTial

:

1. í≈A SQL Server 2000 °AC

2. zuα∩πΩw≈½≤⌡µí≈C

/partial í≈ SQL ΩwCí≈DnO ≥óla

ΩCí≈i SQL ΩwlCiµí≈ºßAtºΩw

ºΘxi" SQL ΩwlnΩsb*lamC

MßAziHq SQL ΩwlNnΩsl SQL ΩwCCϕ

n SQL Ωwl (p≤o°i) Az]iHí≈C

: í≈ϕq Tivoli Storage Manager Server π≈½≤A²

½≤@í≈¿"Cπp2Mq Tivoli Storage

Manager Server ΩqAú2M SQL Server bΩw"Φ

ΩqC

NG

6 ⁿOµ 107

v ziH files groups ⁿwí≈eC– YS files ∩ⁿw SQL sñ SQL Az6Mα

π SQL sC

– ϕ]ADnsC

– * SQL s≈uBLks C

v YnN SQL Ωwl≈bmAz /relocate M/to C

v Data Protection for SQL GUI úΣ /relocate M /to Cϕ⌡µnoí≈AzⁿOµC

v ziHPⁿw /recovery /partialC

pdA\ 73 C

/Quiet /quiet iñLⁿOπ¼AΩTCúLAΩT[ Data Protection

for SQL íΘxñC

/RECOVery=Yes|NoY@A /recovery iⁿwO∩úO≤ SQL °AW SQL

Ωw⌡µΣªCp÷ΩTA\ 112 Cbú

/recovery=yes ΩwºeALkΩwC

ziHⁿwG

Yes (w])ϕz SQL ΩwAµOϕñßA

O SQL Ωw@Cq SQL °A¿ °

*¿ºC

No ϕz SQL ΩwAµúOϕñßC

úFß@ⁿOA∩ restore ⁿOoX /recovery=noC

NG

v @2ú /recovery=yes ßAzNLkN⌠≤tºΘx≈ΩwFC

v zLk∩ fileB group set ≈½≤@ⁿw /recoveryCData

Protection for SQL jεo⌡µ /recovery=noC

v Yⁿw /groups /files full AúDz]ⁿw /partialAhLkⁿw /recoveryCb( /partial ípUA Data Protection for SQL

jεo⌡µ /recovery=noC

v Y*ⁿw∩Ah °Ωw*¿ºC

v ϕzⁿw yes BnPΩwh½≤AΩwß½≤ recovery=yesFΣª½≤h recovery=noCoi²zⁿwΘxMµAúnbOⁿOñⁿwΘxC

UCdípG

ⁿw

πΩw no

tºΩw no

ºΘx≈½≤ no


ⁿw

ºΘx≈½≤ yes

:

1. Data Protection for SQL #ΩwW½≤A#ΩwW

≈íWOAq¡í±íCquery TSM ⁿO]iπoC

2. Y½≤óAhbµ@ⁿOñAΩwß≥½≤Q

ñLCL /recovery /standby ]w≤AúpC

/RELocate=logicalfilename,... /TO=physicalfilename,...Y@A /relocate /to o@∩iⁿw SQL ΩwsmC

∩≤z*Σl≈Bπ⌠WC@ SQL ΩwAz

C

logicalfilename iⁿwzn½sw SQL Ωwº ΦWC

physicalfilename iⁿwzn½sw SQL ΩwbsΩΘ Windows

WC

: Y SQL Server 2000A≈¼+\oCY SQL Server

7.0A+\≈¼A²ú]AΘx≈½≤C

NG

v ⁿw /relocate AzúαNhΩwWⁿwⁿOC

v /relocate /to iU oMµBi½ⁿwCúLA] /relocate /to O@∩AHPABo#Xt∩CpA

/relocate=a,b,c /to=a¹,b¹,c¹

AUCL

/relocate=a,b,c /to=b¹,a¹

v Data Protection for SQL GUI úΣ /relocate M /to Cϕ⌡µnoí≈AzⁿOµC

v ziHft query ⁿOM /fileinfo AHPw≈½≤ñ ΦWΩΘWC

v Y logicalfilename physicalfilename Σñº@]tµAhH'

AϕªC

v Y physicalfilenameA]AsπWB⌠≈C

v sΩΘW≈⌠sbAYúsbA SQL Server

ªC&AYwsbAziαn /replace C

v b /relocate /to ñú+\Ur (*)C

pdA\ 74 C

/REPlaceY@A /replace ⁿwn g SQL Ahú gC

bUCΩñAzG

6 ⁿOµ 109

1. zn⌡µπΩwABUCΣñ@ΩG

v zn /into A² SQL °AWw /into ΩwCv SQL °AWwΩwABUCΣñ@τΩG

– Ωwñ SQL úP≤πΩw≈½≤ñ SQL

C

– Ωwñ@h SQL WúO πΩw≈½≤ñ⌠≤

SQL WC

2. zn⌡µBsA²@h SQL wsbC

/SQLAUTHentication=INTegrated | SQLuseridⁿwnJ SQL °AvíC

integrated ⁿw Windows τCznJ Windows ID Pz

NnJ SQL °A ID O@CoOw]C

sqluserid ⁿw SQL Server ID vC/sqluserid ⁿw ID OzNnJ SQL °A IDC SQL ID

SQL Server SYSADMIN Tw°AñΓC


/sqlbuffers iⁿw SQL Server b SQL Server M Data Protection for SQL

ºíAeΩΩw C

numsqlbuffers ϕΩw qCrd≥ 0 999C

l 0Cϕ /sqlbuffers ] 0 A SQL Pwh(w C

NG

v w] Data Protection for SQL tmñ SQL w itm∩ⁿw

Cl 0C

v Yⁿw /sqlbuffersAhªAD Data Protection for SQL tm

ñxsCⁿwú≤tmñC

v Yⁿw /sqlbuffers ²*ⁿw numsqlbuffersAhw] 0C


/sqlbuffersize ⁿwC@w jp (" /sqlbuffers ⁿw)ASQL

Server ªNΩe Data Protection for SQLC

sqlbuffersizeinkb Ωw jp (KB)Crd≥ 64

4096Cw] 1024C

NG

v w] Data Protection for SQL tmñ SQL w itm∩ⁿw

C@l 1024C

v pGzⁿw /sqlbuffersizeAhªN Data Protection for SQL

tmñxsCⁿwú≤tmñC

v pGzⁿw /sqlbuffersize *ⁿw sqlbuffersizeinkbAhw] 1024C


iⁿw Data Protection for SQL nJ≈½≤bº SQL

°A SQL KXC

NG


v ϕzn SQL Server τC≤KX SQL ID

SQL Server w∩ SQL Server τtmC

: SQL Server ú SQL Server τe≤²eF Microsoft

Windows τCYnoⁿwA\ 110 C

v Y*ⁿw /sqlpasswordAw]µ (″ ″)C

v Yⁿw /sqlpassword ²*ⁿw sqlpasswordnameAw]]Oµ (″ ″)C

: Yft /sqlauth=integratedAhQñC


/sqlserver iⁿw Data Protection for SQL nJ SQL °AC

Y@Aⁿ≈½≤Σñ SQL °ACúLAY≈½≤q

t@ SQL °AWAz /fromsqlserver C

∩ query SQL M backup ⁿO /sqlserverA²O∩ query TSM M

inactivate ⁿO /fromsqlserverC

NG

v w] Data Protection for SQL tmñ SQL °Aitm∩ⁿw

ClqúWC

v Yⁿw /sqlserverA²*ⁿw sqlservernameAhqúWC

v UCΓ°qúWG. (local) oOyIAr localC

v Y SQL °AOO¿ATivoli Storage Manager ∩ñ

CLUSTERNODE ∩ YES C

v Y SQL °AúOw]ΩªOO¿AzⁿwWC

v sqlservername µí°Ω¼OwOwG

µí Ω? O H nWH

local-

computernamew]

local-

computername\

instancename

ⁿW O

virtualservername w] O O

virtualservername\

instancenameⁿW O O

localcomputername

SQL °A Data Protection for SQL bqúº⌠⌠qúWC

TCP/IP D≈Wú@wúPC

instancename

ⁿwΩwíⁿw SQL Server ⁿWΩWC

virtualservername

ⁿwOA]wíⁿwO SQL Server WCoúOO

IWC

6 ⁿOµ 111

: ⁿWΩA SQL Server 2000 ≤sA²ϕⁿWΩASQL

Server 7.0 °AiHOw]ΩCw]ΩúnⁿWΩC

/SQLUSer=sqlusername

/sqluser iⁿw Data Protection for SQL nJ SQL °AWC

NG

v ϕzn SQL Server τC≤KX SQL ID

SQL Server w∩ SQL Server τtmC

: SQL Server ú SQL Server τe≤²eF Microsoft

Windows τCYnoⁿwA\ 110 C

v SQL ID SQL °A SYSADMIN Tw°AñΓC

v Y*ⁿw /sqluserAw] saC

v Yⁿw /sqluserA²*ⁿw sqlusernameAw]]O saC

: Yft /sqlauth=integratedAhQñC

/STANDby=undofilename

Y@A/standby iⁿw∩≈ SQL °AiµAⁿw

WC

NG

v zLkNhΩwWⁿwⁿOC

v bºíA≈ SQL °AiB≤¬íñABiⁿ∩ΣΩw

ΣªC

v ziH∩P@ΩwCPA²úα∩hΩw

µ@C

v undofilename i]Aπ⌠C

v Y undofilename ]tµAhH'AϕªC

v YⁿwúsbASQL °AªCYsb²*≤P

SQL ΩwAh SQL Server gªC

v YJ*ⁿw /recovery ]Sⁿw /standbyAw] /recovery=yesC

/STOPAT=datetime

Y@A /stopat iⁿwzN SQL ΩwíICíI

egºΘxM SQL ΩwC

datetime iⁿwHµjΘíC SQL Server ⁿ⌠≤

ΘíµíCpdA\ 70 C

NG

v MºΘxAºΘxM≥wOπ

ΩwCzLkBsYíIC

v z]Lk∩ /stopat ⁿw /recovery=no /standbyC

v ] datetime ]tµAHzH'AϕªC

v Y /stopat @SbºΘx (πÑ≤j≤ⁿ

wíIíWO) ñoºAYz]ⁿw /recovery=yesA SQL Ω

w6B≤*"¼AñC


pdA\ 70 C

/STOPATMark=markname [/AFTER=datetime]

: OA SQL Server 2000 °AC

/stopatmark iⁿwΩwⁿWíICYⁿw /after ∩AhibⁿwíIºßCⁿWºε (]tⁿWºb)AgºΘ

xO²M SQL ΩwAziHbⁿwíIºßΣⁿWºC

markname iⁿw SQL ºWCSQL ºiHOºíº

CYOíºWAhC SQL ΩwºΘxñⁿWO[J

íºñC

: markname OºWAúOb SQL BEGIN TRANSACTION BEGIN

DISTRIBUTED TRANSACTION »zíñ MARK ÷ΣrßíC


ΘíµíC

NG

v MºΘxCºΘxM≥wOπΩ

wCzLkBsOC

v ziH∩ SQL ºPⁿWOC

v Y*ⁿw /afterAhboⁿwW@OWεC

v Yⁿw /afterAhbⁿwΘíºßoⁿwW@OWεC

v Y markname ]tµAhH'AϕªC

v zúαP Data Protection for SQLrestore ⁿOP /stopatmarkABSⁿw /recovery=no /standby Σñº@C

v Y /stopatmark @bºΘxñSoºnεºBAhYz]ⁿw /recovery=yesA SQL Ωw6B≤*"¼A

ñC

pdA\ 71 C

/STOPBEFOREMark=markname [/AFTER=datetime]

: OA SQL Server 2000 °AC

ⁿwΩwnYⁿWíICYⁿw /after ∩AhibⁿwíIºßCbⁿWº (iαbⁿwíIíIºßΣ)

ºe (²ú]AⁿWº) gJºΘxO²M SQL ΩwC

markname ⁿw SQL ºWCSQL ºiHOºíº

CYOíºWAhC SQL ΩwºΘxñⁿWO[J

íºñC

: markname OºWAúOb SQL BEGIN TRANSACTION BEGIN

DISTRIBUTED TRANSACTION »zíñ MARK ÷ΣrßíC

6 ⁿOµ 113


ΘíµíC

NG

v MºΘxCºΘxM≥wOπΩ

wCzúαBsMOC

v ziH∩ SQL ºPⁿWOC

v pGz*ⁿw /afterAhbo@ⁿWOºeεC

v pGzⁿw /afterAhbo@ⁿWOºeAbⁿwΘíºßεC

v Y markname ]tµAhH'AϕªC

v zúαP Data Protection for SQL restore ⁿOM /stopbeforemarkBⁿw /recovery=no /standbyC

v pG /stopbeforemark @bwºΘxñ*oibºeεºAh SQL ΩwB≤*"¼AAYz]ⁿw

/recovery=yes τMC

/STRIPes=numstripes

/stripes iⁿwb≈@ñΩÑqC

numstripes d≥iq 1 32 (A≤ SQL Server 7.0)AYO SQL Server

2000Ahq 1 64C

NG

v Y*ⁿw /stripesAw] Data Protection for SQL tmñⁿwC

l 1CYAhP≈@PC

: btmñAziHq 1 64 ]wÑqCúLAYO SQL

Server 7.0A Data Protection for SQL NWL 32 Ñqⁿw

jε 32 C

v Yⁿw /stripes ²*ⁿw numstripesAhxsC

v Y SQL Server 7.0 ≈½≤AzΩÑqP

≈½≤ΩÑqPC

v Y SQL Server 2000 Azhi≈CziH

Data Protection for SQL ⁿOPw≈½≤ΩÑq

qG

query tsm dbname backup_object

v zb Tivoli Storage Manager REGISTER NODE UPDATE NODE ⁿ

OW MAXNUMMP Aα²IhÑq@biúC

ΘWxsΩ (onz∩ItmhⁿI)CMAXNUMMP Ñ≤

p≤zQnjÑqC

v ΩÑqAz Tivoli Storage Manager Server í

tmAbt@xsWOsC@ÑqC

v zijΩÑqOp≤ dsmserv.opt ñ Tivoli Storage

Manager Server TXNGROUPMAX ∩qCSQL °Ahiⁿ 32

ΩÑqA SQL Server 2000 h 64 C


/TRUNCate=Yes|No/truncate iⁿwORú SQL ΩwºΘxñúAnC

ziHⁿwG

Yes SQL Server IºΘxA@z≈ΘxºßΘx@ñí≈

εCoOjí≈ºΘx≈@Bw]C

No SQL Server úbz≈ºΘxßNªICDn≤Ωwla

Lkß≈ºΘxC

NG

v b SQL Server 7.0 ñAΩwDnsiBLlaAα≈

ºΘxC

v b SQL Server 2000 ñAYΩlaLkAz6i

≈ºΘxC

v Y*ⁿw /truncateAw] yesC

v Yⁿw /truncateA²J*ⁿw yes ]Sⁿw noAhw] yesC


/tsmnode iⁿw Data Protection for SQL nJ Tivoli Storage Manager

Server Tivoli Storage Manager IWCoiOnDA Tivoli Storage

Manager ßCz]iHb∩ñxsIWCⁿOµim½∩

ñC

NG

v Y Tivoli Storage Manager ∩ñⁿwF PASSWORDACCESS

GENERATEAhzLk /tsmnode Czⁿw∩ñnodenameChAiN PASSWORDACCESS ≤ PROMPTA

/tsmnode Cp Tivoli Storage Manager ∩ΩTA\

ΓU IBM Tivoli Storage Manager for Windows ≈OsßwP

ΓUC

v Y*ⁿw /tsmnodeAw] Tivoli Storage Manager ∩ñ nodename

∩ⁿwCⁿwú≤∩ñC


/tsmoptfile iⁿw Tivoli Storage Manager ∩Coⁿb GUI

°AMµñ∩ Tivoli Storage Manager ServerCTivoli Storage Manager ∩

]t Tivoli Storage Manager API tmCp Tivoli Storage Manager

∩ΩTA\ΓU IBM Tivoli Storage Manager for Windows

≈OsßwPΓUC

NG

v tsmoptfilename i]Aπ⌠CYzS]A⌠Ah Data

Protection for SQL w²C

v Y tsmoptfilename ñ]tµAhH'AϕªC

v Y*ⁿw /tsmoptfileAw] dsm.optC

v Yⁿw /tsmoptfileA²*ⁿw tsmoptfilenameAw]]O dsm.optC

6 ⁿOµ 115

/TSMPassword=tsmpasswordname

/tsmpassword iⁿw Data Protection for SQL nJ Tivoli Storage

Manager Server Tivoli Storage Manager KXC

M Tivoli Storage Manager ∩ñ PASSWORDACCESS ∩HU

CΦí¼G

/tsmpassword

PASSWORDTivoli Storage

Manager ∩ñ

ACCESS

KXwxs≤n²ñH G

wⁿw generate O ñ /tsmpassword

wⁿw generate xs

/tsmpassword

wⁿw prompt -- /tsmpassword

*ⁿw prompt -- ú


² A. Tivoli Storage Manager

úp≤ Tivoli Storage Manager Data Protection for SQL

SQL Server ΩwuW≈dCdíp≤ Tivoli Storage Manager

SQL Ωwπ≈C

: TOdiAz owsuTivoli Storage Manager ≈Os

ßvC

@2 Data Protection for SQL n² Tivoli Storage Manager Server wb SQL Server

WAh"UCBJ¿G

1. b Tivoli Storage Manager Server WG

a. wq@⌡µ Windows ⁿOCbn²F Data Protection for SQL

h⌠ñwqC

b. N Data Protection for SQL IswqC

2. bw SQL Server Data Protection for SQL ≈WG

a. N Tivoli Storage Manager ßw Data Protection for SQL

Windows ACY@δ Tivoli Storage Manager ≈ßwA

Data Protection for SQL wt@C

b. wqt Data Protection for SQL ⁿOⁿO⌡µQn≈C

: p Windows ⁿOΩTA\ Windows íσ≤C

c. YObO°A⌠ñ⌡µAbΓOIWAN Tivoli Storage Manager

ßw Windows AC

d. YObO°A⌠ñ⌡µA@Nϕ Tivoli Storage Manager

sOΩCτOΩOwC

e. BJ 2a (bY HTML s²ñOⁿBJ 2.1) ñwC

d

d]UC⌠G

v Data Protection for SQL wn² Tivoli Storage Manager ServerG

– IW mynodeC

– KX mypasswordC

– h⌠ mydomainC

v nw≤G

– SQL ΩwCΘπ≈C

– bU9 9:00 M 9:15 ºíl≈C

ΦkπuA]ziH∩⌠≤ⁿOwqⁿOCo]i²z∩

Windows WΣL Data Protection for Microsoft SQL Server íP Tivoli

Storage Manager C


b Tivoli Storage Manager Server WG⌡µºeAzbwu≈Os

ßv≈W]wAC

1. @W c:\sqlfull.cmd ⁿOCb Data Protection for SQL w²U

ú@dⁿO (sqlfull.smp)Cd]t∩ Tivoli Storage Manager xsΘ

⌡µ SQL Server Ωwwwπ≈ºⁿOCzbⁿOñ∩

WDtⁿOⁿw COMPLETE PATHNAMESC

: Yn∩O⌠U⌡µ SQL Server ]wA⌡µUC@G

v zⁿO≤ SQL Server File Share WCzb Tivoli Storage Manager

Server wqXⁿOCbBJ 1 2 ñAⁿO

c:\sqlfull.cmd iHO x:\sqlfull.cmdAΣñ x Nϕ SQL Server File ShareC

v zⁿOñⁿw tsmoptfile logfile ∩2M SQL Server File Share

W∩ΘxmC

2. ΘJUCⁿOwqCziHb°AD xWqzßΘJⁿOC

zßúnbP Tivoli Storage Manager Server PtW⌡µC

def sched mydomain my_schedule desc="SQL Daily FullBackup" action=command objects="c:\sqlfull.cmd" priority=2starttime= 21:00 duration=15 duru=minutes period=1 perunits=daydayofweek=any

Tivoli Storage Manager πTºG

ANR2500I Schedule MY_SCHEDULE defined in policy domain MYDOMAIN.

3. oXUCⁿON Data Protection for SQL soG

define association mydomain my_schedule mynode

Tivoli Storage Manager πTºG

ANR2510I Node MYNODE associated with schedule MY_SCHEDULEin policy domain MYDOMAIN.

Tivoli Storage Manager Server Wwwq@AªπUCG

v ª⌡µ@W c:\sqlfull.cmd ⁿOC

v ªbU9 9:00 lC

v ªCΘ⌡µBib⌠≤u@ΘC

ziH Tivoli Storage Manager zⁿO query schedule query associationATP÷p]wOTC

b SQL Server WGoí≈]UC⌠G

v uTivoli Storage Manager ≈Osßvww SQL Server d:\Program

Files\Tivoli\TSM\baclient ²UC

v D a t a P r o t e c t i o n f o r S Q L ww S Q L S e r v e r d : \ P r o g r a m

Files\Tivoli\TSM\TDPSql ²UC

v o²U dsm.opt ∩ñqH∩ⁿV SQL Ωwn≈Σñ Tivoli

Storage Manager ServerC

ϕτIKXA∩ Data Protection for SQL wq∩Cϕ

p Tivoli Storage Manager Server oΩTA]o∩C

YTºpUπG

A communications error occurred connecting to the Tivoli Storage Manager Server


– Tw dsm.opt ñqH∩ⁿVT Tivoli Storage Manager ServerC

– Tw Tivoli Storage Manager Server ⌡µñC

1. πzv¡ Windows bßnJC

2. Windows ⁿOú°íC

3. b°íñAΘJUCⁿOG

cd d:\"Program Files"\Tivoli\TSM\baclient

Yzn⌠ñµAziH'Ntµ⌠Wí≈Aϕ

(d:\"Program Files"\Tivoli\ TSM\baclient)C]iHuí⌠WA

ΦkOb⌠ñe 6 rß±mi÷ (~) @ IDC

HUOuí⌠dG

d:\Progra~1\Tivoli\TSM\baclient

: Yz≈Www Tivoli Storage Manager (≤ Windows t

≈)AzNwt@ (π@W) ⌡µ Data Protection

for SQL wqCTivoli Storage Manager IWúiP

uTivoli Storage Manager ≈OsßvPC

4. b°íñAΘJUCⁿOG

dsmcutil inst /name:"Data Protection for SQL Scheduler"/node:mynode /password:mypassword /autostart:yes/clientdir:"d:\Program Files\Tivoli\TSM\baclient"/optfile:"d:\Program Files\Tivoli\TSM\TDPSql\dsm.opt"/startnow:no

A Windows ID iαnzboⁿOñAⁿwß

dsmcutil ∩ ntdomainBntaccount ntpasswordC

: Yn∩O⌠U⌡µ SQL Server ]wA⌡µUC@G

a. N /autostart ∩≤ noCpG

/autostart:no

b. N SQL Ω°AOnIWAHAíCTw

OnIπ SQL Ω°AvC

c. ODnI]t@"WAíⁿO

C

d. N∩ (ⁿBJ 4 dñ dsm.opt) sPΩ°A÷@"

≈CpG

/optfile:"x:\dsm.opt"

Tivoli Storage Manager πΘXG

TSM Windows NT Client Service Configuration UtilityCommand Line Interface - Version 5, Release 1, Level 5.0 c4(C) Copyright IBM Corporation, 1990, 2002, All Rights Reserved.Last Updated May 29 2002TSM Api Verison 5.1.5

ⁿOGInstall TSM Client Service≈G TDPSQ1(Local Machine)

w TSM ßAG

≈GMYNODE

² A. Tivoli Storage Manager 119

|

AW: Data Protection for SQL Scheduler

ß²GD:\Program Files\Tivoli\TSM\baclient

Gyes

nJbßGLocalSystem

AwQwC

n²≈X ...

≤sn² ’ImagePath’ .≤sn² ’EventMessageFile’ .≤sn² ’TypesSupported’ .≤sn² ’Data Protection for SQL Scheduler’ .≤sn² ’ADSMClientKey’ .≤sn² ’OptionsFile’ .≤sn² ’EventLogging’ .≤sn² ’ClientNodeName’.

ún²KX ...bτA≤I MYNODE Tivoli Storage Manager KX ....

zLß∩sbs Tivoli Storage Manager’d:\Program Files\Tivoli\TSM\TDPSql\dsm.opt’ ...

KXτwQ¿C

MYNODE n²KXwg≤sC

: YbwAíßniµ≤G

a. oXUCⁿOúAíG

dsmcutil remove /name:"Data Protection for SQL Scheduler"

b. ½sbBJ 4 oXⁿOwsAíC

: Yn∩O⌠U⌡µ SQL Server ]wAíA∩On

I½⌡µBJ 1 4C½nIbBJ 4 ñ dsmc util ⁿOAíWPOAíπPnJv¡C

5. bwwn Tivoli Storage Manager A²*CYnbuDO⌠v

UAb Windows ⁿOú°íñoXUCⁿOG

net start "Data Protection for SQL Scheduler"

eWπUCΘXG

Data Protection for SQL AíbCData Protection for SQL AíwQC

NG]wⁿw /autostart:yesAH Tivoli Storage Manager bC

½s Windows tC

: ½nI

v YnbDO⌠ñAíAqBJ 13 lC

v YnbO⌠ñAíA⌡µBJ 6 13C

sAíPOsXb@Coi² Tivoli Storage

Manager bIºíTaA]izKX≤C


6. uOzvC

7. ∩ uSQL Server OsvA@Nϕ Data Protection for SQL

suΩv (uv->usWv->uΩv)CTwwⁿwUCG

Resource TypeⁿwPAC

Group ⁿw SQL Ω°AC

Possible OwnersTwΓI≈wCXCY*CXAsWªC

Resource DependenciesTw∩b@"≈M SQL Ω°AwCXC

Generic Service->Service NameⁿwAíT%WC

8. ∩ sΩ ∩ΣeCb Registry Replication->Root Registry Key ºUAsWCX Data Protection for SQL IWPΣCpG

SOFTWARE\IBM\ADSM\CurrentVersion\BackupClient\NODES\<nodename>

N <nodename> N¿z Data Protection for SQL IWCpG

SOFTWARE\IBM\ADSM\CurrentVersion\BackupClient\NODES\MYNODE

9. b Windows ⁿOú°íñA%½ Data Protection for SQL w²C

cd /d d:\"Program Files"\Tivoli\TSM\TDPSql

10. τ dsm.opt ñ clusternode ∩O] yesCτºßAΘJP Tivoli

Storage Manager Server ÷pⁿOCⁿw /tsmpassword=yourpassword A

HTwn²ñxsKXTCoi²Aϕas Tivoli Storage

Manager ServerC

tdpsqlc query tsm /tsmpassword=mypassword

11. quOzv∩ sΩAºsu (uv->usuv)C

12. sΩsuºßANusvqOnIDnICτDnIW

Data Protection for SQL AíOwC

13. ΘJUCⁿOAbwu≈Osßv≈WßG

dsmc sched

UπΘXdG

Tivoli Storage ManagerCommand Line Backup/Archive Client Interface - Version 5, Release 1, Level 5.0(C) Copyright IBM Corporation 1990, 2002 All Rights Reserved.

bV°AdU@ww≤CIWGMYNODE°A TYPP_CLINT: Win 2000 Ñq@

Server Version 5, Release 1, Level 3.0

°AΘ / íG06/24/2002 17:55:37 esG06/24/2002 17:43:51

U@Bww@G------------------------------------------------------------WGDATA PROTECTION FOR SQL SCHEDULER@GCommand½≤GC:\sqlfull.cmd∩G


°A°íG13:40:30 on 06/25/2002------------------------------------------------------------b 1 p½sπzC

⌡µIεlíG00:59:58

bztiHl⌡µ SQL ΩwCΘπ≈FC

N

wq Tivoli Storage Manager AqUCΦG

v pGzn Tivoli Storage Manager Server úíAzTw Data

Protection for SQL ∩wⁿw tcpclientaddress M tcpclientport ∩CYn⌡µhAíAP tcpclientaddressC²OAúFúPIWH&Ab tcpclientport ñ]úPCϕzP Data

Protection for SQL @δ Windows ≈ßAN⌡µhAíC

ub TCP/IP qTΣ°AúCw]AData Protection for

SQL ßⁿíC

v Yb Data Protection for SQL ∩ñFvT⌠≤≤A½s

α≤!CpAz≤F Tivoli Storage Manager Server B

íAOß TCP ≡CoXUCⁿO½sG

net stop "Data Protection for SQL Scheduler"net start "Data Protection for SQL Scheduler"

: ½nIYnbO⌠ñ⌡µAíAuOzvε½sAíCuúnv net stop net start ⁿOC

v w] Tivoli Storage Manager Θx (dsmsched.log) ]t Tivoli Storage Manager

¼AΩTCbdñA≤UC⌠ñG

d:\Program Files\Tivoli\TSM\TDPSql\dsmsched.log

ziHb Data Protection for SQL ∩ñⁿw schedlogname ∩m½oWC

v ϕb tdpsqlc ⁿOíⁿwF /logfile AData Protection for SQL v

ΘxAΣñ÷≤≈Ωw½≤pCbd (sqlfull.smp) ñAΘx

sqlsch.logCP Tivoli Storage Manager ΘxúPAB]P

tdpsqlc ⁿOΘX½sVúPCbWzdñA sqlfull.logC

: wwⁿOΘXeΘx (dsmsched.log)C⌡µwwu@ºßA

dΘxHTwQ¿u@C

ϕBzwwⁿOAΘx]tUCn²G

Scheduled event eventname completed successfully

oΘⁿX Tivoli Storage Manager QoXP eventname ÷wwⁿOC

ªúPwⁿO¿\PCz⌠ΘxñwwⁿOñ

" XAwⁿO¿\PCⁿO" XΘxeUC

σrG

¿ⁿOCXG


v pG dsm.opt ñ*ⁿw passwordaccess generateAhb tdpsqlc ⁿOWⁿw Tivoli Storage Manager KXCYnⁿwKXAbn⌡µⁿO

(sqlfull.cmd) ñ /tsmpassword Cz]ib Data Protection for SQL ⁿO

µⁿwKXCpG

tdpsqlc query tsm /tsmnode=mynode /tsmpassword=newpassword


² B. Lnw

ziLnww Data Protection for SQLCLnwOW⌡µA

ún⌠≤JAHzún °w@ú∩ΘJCΦk∩≤

b@πPwΘúPqúWw Data Protection for SQL SOUC

pA@aqiα 25 SQL Server O≤ 25 úPxWCTOtmW

@PKú² 25 úPHΘJ Data Protection for SQL Azi∩ú!

@≈KJwAzLsΦ 25 i CD eXNKJwM≤±m°A

WΦíA 25 xC

ziHUCΣñ@Φk±LnwG

]wí

setup ⁿOPⁿOµIsAA[WSwLnw∩C

Microsoft Installer (MSI)YzO⌡µ Windows 2000 (≤s)AO msiexec.exe wwbzWindows NT tWAhiñL setup.exe ΦkAw MSI M≤C

UCOiHftoΓLnwΦk∩G

ϕ 13. Lnw∩

∩ í

/i ⁿwíNwúC

/l*v ⁿwOⁿC

/qn ⌡µw²ú⌡µ&íCC

/s ⁿw]wíC

/v ⁿwu]wívNrΩ∩ MSI i⌡µ

(msiexec.exe) IsCIs /v ∩ANUCykDG

v b≤'⌠≤' (" ") eA[W2

u (\)C

v únb /v ⁿOµ∩PΣ'ºí]AµCv H /v ⁿOµ∩ΘJhHµjCv ziHbⁿOⁿw²MWAΘxC

b⌡µLnwA²wgsbC

/x ⁿwíNúúwC

addlocal ⁿwnw\αC

allusers ⁿwiHwM≤C

installdir ⁿw Data Protection for SQL w²C

reboot ⁿwOúbLnwß½s≈C

v Force ϕúbLnwß½s≈C

v Suppress ϕεLnwß½s≈úC

v ReallySuppress ϕε½s≈Lnwß½

s≈úC


||

ϕ 13. Lnw∩ (≥)

∩ í

rebootyesno ⁿwObLnwß½s≈CYⁿwOAh

bLnwß½s≈CYⁿwAhúbLn

wß½s≈C

transforms ⁿwnwyÑC

UCObñ\αAªjpgG

ϕ 14. Lnw\α (¡≥ß)

\α í

ß Data Protection for SQL íX

σ≤ Data Protection for SQL Readme MΓU (HTML M

PDF µí)

License_Paid v (bwuIOv Data Protection for SQL

)

License_TryBuy v (bwuv Data Protection for SQL

)

ϕ 15. Lnw\α (¡yÑM≤)

\α í

LanguageFiles yÑS

UCα½G

ϕ 16. Lnwα½

α½ yÑ

1028.mst CHT ñσ (cΘ)

1031.mst DEU wσ

1033.mst ENG σ

1034.mst ESP ΦZ0σ

1036.mst FRA kσ

1040.mst ITA qjQσ

1041.mst JPN Θσ

1042.mst KOR σ

1046.mst PTB σ0σ

2052.mst CHS ñσ (Θ)


|

||

||

||

|||

|||

||||

||

||

||

]wí (setup.exe) iµw

: π Data Protection for SQL LnwdCϕwσH&yÑ

Az½Aϕ\αC\ 126 ϕ 15C

⌡µUCⁿOLnw Data Protection for SQL w]w²G

setup /s /v/qn

dN Data Protection for SQL LnBww]w²H&²ñA

[J@q\αG

setup /s /v"INSTALLDIR=\"c:\program files\tivoli\tsm\"ADDLOCAL=\"Client,License_Paid,Docs\"TRANSFORMS=1033.mst /qn /l*v \"e:\log.txt\""

:

1. zb@&í' (″) C@'e[W2u (\)C

2. zbUCΓ[W' (″)G

v ]tµ²⌠C

v ⁿwFh½\α'C÷Mbπ'Γ'A²zOnbC@

í'e[W2uC

3. qwñCX\αb addlocal ∩ßCXC

σ

ziHσ[JQnlLnwC

v c:\setup.bat -- dwd scriptC

@echo offrem ===================================rem sample silent install scriptremsetup /s /v"INSTALLDIR=\"X:\Desired Install Path\" /qn"rem ====================================rem code could be added after therem installation completes torem customize the dsm.opt filesrem if desiredrem ====================================

MSI (msiexec.exe) iµw

: π Data Protection for SQL LnwdCϕwσH&yÑ

Az½Aϕ .msi M≤WMuyÑM≤v\αC\ 126 ϕ

15C

dN Data Protection for SQL LnBww]w²H&²ñA

[J@q\αG

msiexec /i"IBM Tivoli Storage Manager for Databases - MS SQL.msi"RebootYesNo="No" Reboot="Suppress" ALLUSERS=1INSTALLDIR=\"c:\program files\tivoli\tsm"ADDLOCAL=\"Client,License_Paid,Docs"TRANSFORMS=1033.mst /qn /l*v "e:\log.txt"

² B. Lnw 127

|

|

|||

|

|

|

||||||

:

1. zb@&í' (″) C@'e[W2u (\)C

2. zbUCΓ[W' (″)G

v ]tµ²⌠C

v ⁿwFh½\α'C÷Mbπ'Γ'A²zOnbC@

í'e[W2uC

3. qwñCX\αb addlocal ∩ßⁿwC

wDGwΘx

bwó≤ñAO²Uówxⁿ⌠ΩTAMßúΩTß

ΣñCUC⌠ΩTiαUG

v @th

v AíM≤

v wΘí

v wM≤ (CD-ROM qlUⁿ) h

v Pów÷⌠≤ Windows ≤Θx

v w@ñΣL Windows Aí (p rnΘ)

bpΣñºeAziHiµUCdG

v zwnJ≈D x (úOzL≈°A)C

v zOHz¡≈nJAúOH⌠z¡≈nJC Tivoli úΣ≤⌠w

C

Y@%LANówΘxJ¿ setup.log CkOApU⌡µ

]wíG

setup /v"/l*v setup.log"

b CD °AWM≤

zi∩úPΦíM≤iA]AN² CD NM≤±m°AW@

²ñC@δÑAM≤]t Data Protection for SQL íXte≤Ln

wσC

LnwM≤

²AznM≤∩@mCYnN² CDA m²±AXCYnNM≤

±m°AWAi m²b°AWmM≤CUCd

c:\tdpdpkg @ m²C m²(n 14 MB iíCi⌡µUC

ⁿOM≤C

mkdir c:\tdpdpkg - ≤LnwM≤ m²cd /d c:\tdpdpkg - ⌡ m²xcopy g:\*.* . /s - N Data Protection for SQL CD tes m

²ñ

copy c:\setup.bat - N setup.bat N¿e@BJñ

LnwC¿ßAM≤Ki±m CD Wq@² oC


±Lnw

@2M≤iHb CD @²ñAKiHbt@í≈W± (⌡µ) ªCú

¼≈í¿LnwCw¿AL⌠≤úqzAúLziH

bσñ[Jo∩C

v q CD WLnwM≤G

YwAunN CD íJ1≈ñAKl±LnwCY*

Ahiq CD ²⌡µ setup.bat lLnwC

cd /d g:\setup.bat

v qt²G

YM≤w±m≤ \\machine1\d$ W tdpdpkg @²ñAht@íqúi⌡

µ net use x \\machine1\d$ ⁿON≈"≈ xCMßAioXUC

ⁿOG

cd /d x:\tdpdpkgsetup.bat

LO@ípAúlLnwC

]wwTº

Y setup.exe íLkAhú!TºCjí≈ípUAϕo!Y½

AKXoTºC@δ(oTºCϕXTºAªX

bTºñCC@TºúsCoOtTºAHbz script ñ

LkϕεªC

pGJAziHe I n s t a l l S h i e l d Σ⌠AΣ U R L G

http://support.installshield.com/default.aspAMßQujMv≈α o

÷ΩTC

² B. Lnw 129

http://support.installshield.com/default.asp

² C. iÑ

d include/exclude »zí

B εMAziH]wC@≈ΩhA"UC Data Protection

for SQL ∩ INCLUDE/EXCLUDE »zí[Hí (÷≤@δykA\ 19

y]wz)G

BackupType ½≤X ⁿwe

½≤ \...\*

b a c k u p T y p e ½≤

(fullBdiffBlogBgroupBfileBset)\...\full*

\...\diff*

ÑÑ

s½≤W (g1, f1) \...\g1\group*

\...\f1\file*

H g f Y group file ½≤W \...\g*\group*

\...\f*\file*

P \...\group* \...\file* P \...\*\group*

\...\*\file*

tΩwX BackupType ½≤ ⁿwe

tΩwW Db1 ½≤ \...\Db1\...\*

tΩwW Db1 H Db Y½≤ \...\Db*\...\*

ú½≤ \...\*\...\*

tΩwW Db1 full diff ½≤ \...\Db1\full*

\...\Db1\diff*

tΩwW Db1 logBgroupBfile

set ½≤\...\Db1\...\log*

\...\Db1\...\group*

ÑÑ

tΩwW Db1 s½≤W

(g1, f1)\...\Db1\g1\group*

\...\Db1\f1\file*

H g f YtΩwW Db1

group file ½≤W\...\Db1\g*\group*

\...\Db1\f*\file*

P \...\Db1\...\group* file* P \...\Db1\*\group*

\...\Db1\*\file*

P \...\Db1\full* P \...\Db1\...\full*


tΩwX BackupType ½≤ ⁿwe

P \...\full* P \...\*\full*

P \...\group* P \...\*\*\group*

P \...\g1\group* P \...\*\g1\group*

ú½≤ \...\*\...\log*

````

L (( typeInfo) \...\Db1\set*

Meta & Ω½≤X ⁿwe

meta Ω½≤ \...\meta\...\*

\...\data\...\*

meta Ω fullBlog group ½≤ \...\meta\...\full*

ÑÑ

meta Ωs½≤W (g1) \...\meta\...\g1\group*

ÑÑ

H g Y meta Ωs½≤W \...\meta\...\g*\group*

ÑÑ

P \...\meta|data\...\group* P \...\meta\...\*\group*

ÑÑ

L ((¡w) \...\meta\*

\...\data\*

tΩwX Meta & Ω½≤ ⁿwe

tΩwW Db1 meta Ω½≤ \...\meta\...\Db1\...\*

\...\data\...\Db1\...\*

tΩwW Db1 meta Ω full

½≤\...\meta\...\Db1\full*

ÑÑ

tΩwW Db1 meta Ω log

group ½≤\...\meta\...\Db1\...\log*

ÑÑ

tΩwW Db1 meta Ωs

½≤W (g1)\...\meta\...\Db1\g1\group*

ÑÑ

H g YtΩwW Db1 meta

Ω group ½≤W\...\meta\...\Db1\g*\group*

ÑÑ


tΩwX Meta & Ω½≤ ⁿwe

P \...\meta|data\...\Db1\...\group* P \...\meta\...\Db1\*\group*

ÑÑ

P \...\meta|data\...\full* P \...\meta\...\*\full*

ÑÑ

P \...\meta|data\...\group* P \...\meta\...\*\*\group*

ÑÑ

P \...\meta|data\...\g1\group* P \...\meta\...\*\g1\group*

ÑÑ

ú½≤ \...\meta\...\*\...\log*

\...\data\...\*\...\log*

°AX ⁿwe

H SQL Y°Añ½≤ SQL*\...\*

°A SQL70 ñ½≤ SQL70\...\*

°A SQL70 ñtΩwW Db1

½≤SQL70\...\Db1\...\*

°A SQL70 ñtΩwW Db1

π½≤SQL70\...\Db1\full*

°A SQL70 ñ meta Ω½≤ SQL70\meta\...\*

SQL70\data\...\*

tD≈ SQL2000 °AΩñ

½≤SQL2000\...\*

°A SQL2000\INST1 ñ½≤ SQL2000\INST1\...\*

H SQL2000\INST Y°Añ½

≤SQL2000\INST*\...\*

P SQL2000\...\* P SQL2000\*\...\*

°A SQL2000\INST1 ñ meta Ω

½≤SQL2000\INST1\meta\...\*

SQL2000\INST1\data\...\*

tD≈ SQL2000 ⁿW°AΩñ

meta Ω½≤SQL2000\*\meta\...\*

ÑÑ

tD≈ SQL2000 °AΩñ

meta Ω½≤SQL2000\...\meta\...\*

ÑÑ

°Aw]Ωñ½≤ (pGSΩW

X ??ta )SQL2000\??ta\meta\...\*

SQL2000\??ta\data\...\*

² C. iÑ 133

DnΩw

ⁿlDnΩwP SQL Server LkAΣL@¼po!C

nSϕαDnΩwCNAb½smDnΩwBz

íASQL Server ]wíε½ msdb ΩwA]ªHDnΩw@C

pⁿA\ SQL Server uWíσ≤C

@δÑAnUCBJC

1. ⌡µ SQL Server ]wíH½smDnΩwC½smzPN

ºDnΩw≈PrC

2. Hµ@í SQL ServerCoibⁿOúU¿AOϕ¿ NT AC

t\y]wízUu 1vC

3. Data Protection for SQL DnΩwC

: ϕDnΩww¿ASQL Server N÷¼CGú!TºAⁿ

XwóhP SQL Server suCoGOiwC

4. HΦí½s SQL Server (bhíñ)C

5. bz⌡µ@ºΩw≈Θºß∩DnΩw≤AHΓ

Φí½sMC

6. Data Protection for SQL msdb ΩwC

OdzDnΩwºs≈Q½nA]DnΩw]ttsCts

]t÷≤ SQL Server tm½nΩTCTwb≤stϕµ⌠≤≤ºßA

≈DnΩwCpAbUC⌠≤»zíºßA≈DnΩwG

v ALTER DATABASE

v CREATE DATABASE

v DISK INIT

v DISK RESIZE

v DISK MIRROR

v DISK UNMIRROR

v DISK REMIRROR

v U DBCC ∩Ap SHRINKDB

v txsApGsp_dropremoteloginB sp_addumpdeviceBsp_dropdeviceB

sp_addloginBsp_droploginBsp_addserverBsp_dropserverBsp_addremotelogin

]wí

bí]wíOnCzLkeb SQL ΩwC

n SQL ΩwB≤µ@íAzNiHKoCpGzn

DnΩwAz SQL °AB≤µ@íCp SQL ⁿOΣLΩ

TUAp MicrosoftC

b SQL Server 7.0 ]wíG


SP_DBOPTION ’DBNAME’, ’SINGLE USER’, ’TRUE’ SQL xs]wΩwµ@íC

SP_DBOPTION ’DBNAME’, ’SINGLE USER’, ’FALSE’Ωw"híC

b SQL Server 2000 ]wíG

ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK AFTER NSECONDS

TRANSACT-SQL ⁿOjε÷¼ΩwAªB≤µ@

íC

ALTER DATABASE DBNAME SET MULTI_USER TRANSACT-SQL ⁿOΩw"híC

:

1. b½s SQL °AAziH -m SQL SERVER ∩AN SQL °

A]wµ@íC

2. ziH SQL xs SP_WHO PwbΩwC

3. nAziHb SQL Server 7.0 ñ KILL SPID εΩwBz

C

² C. iÑ 135

² D. DRU

pGb Data Protection for SQL ≤ío!¼pAziH°ΩTA

H≤UPwDbG

v Data Protection for SQL Oⁿ backupBrestore delete ⁿOΩT Tivoli Event

ConsoleC

v w]AData Protection for SQL OⁿΩTww Data Protection for SQL

²ñ tdpsql.log CⁿX≈ΘíB≈ΩAH⌠≤

Tº¿XCD½nACΘ °C

v w]ATivoli Storage Manager API Oⁿ API ΩTww Data

Protection for SQL ²ñ dsierror.log CΘxúOd≈pC dsierror.log

Lk¬C

v SQL Server OⁿΩT SQL Server ΘxCi Enterprise Manager °

SQL Server ΘxΩTAΦkO∩ Server->Management->SQL Server

Logs->Current Archive #nC

v Tivoli Storage Manager OⁿΩT dsmsched.log M dsmerror.log C

w]Ao≤w Tivoli Storage Manager ≈Osß²ñC

: wwⁿOΘXeΘx (dsmsched.log)C⌡µwwu

@ºßAdΘxHTwQ¿u@C

BzwwⁿOºßAΘxiα]UCTºG

wQ¿w≤ eventname

oΘⁿX Tivoli Storage Manager QoXP eventname ÷wwⁿOC

ªúPwⁿO¿\PCz⌠ΘxñwwⁿOñ

" XAwⁿO¿\PCⁿO" XΘxeUC

σrG

¿ⁿOCXG

v Windows ≤ΘxC


² E. Data Protection for SQL Tº

ACO0003S oFíBzC

í: o!FíBzC

t@: w⌠BzC

: A@CpGo≥o!Ap

ßANϕC

ACO0004E úC

í: o!FíBzAª²¬" XTºú!C

t@: ≥BzC

: A@CpGo≥o!Ap

ßANϕC

ACO0005E OΘú¼CεΣLBzAMß½@

C

í: ≈OΘwC

t@: ≥BzC

: ÷¼únBzAMß½@C

ACO0053E Lkv (licensefile)Cí: qv¬ óC

t@: w⌠BzC

: ½swúCoiTOwTv

C

ACO0054E Lk¬v (licensefile)Cí: wqv¬ ΩCowóC

t@: w⌠BzC

: ½swúCoNTwwFT

vC

ACO0055E Lkbv (licensefile) ñgJΩC

í: gJvóC

t@: w⌠BzC

: Twu@sb¼≈íAHgJv

CYsb¼≈íA½s⌡µⁿOC

ACO0056E v (licensefile) ñΩúπ

µíC

í: qv¬ ΩTóC

t@: w⌠BzC

: ½swúC

ACO0057E v (licensefile) ñMdúX

vrΩσrC

í: wqv¬ ΩTCMdúOA

HϕvúbThC

t@: w⌠BzC

: ½swúC

ACO0058E uvvwLC

í: uvvwLC

t@: w⌠BzC

: úα≈AúCb⌡µúeA²

ovC

ACO0100E úπⁿOG

í: TºπwΘJºúπⁿOC

t@: w⌠BzC

: ½sΘJπⁿOC

ACO0101E LG

í: TºπwΘJⁿOA]AwLⁿ

O∩'C

t@: w⌠BzC

: ½sΘJⁿOAPⁿw'ⁿO

∩C

ACO0102E LⁿOG

í: TºπwΘJLⁿOC

t@: w⌠BzC

: ½sΘJⁿOC

ACO0103E ⁿwºⁿOL∩G

í: TºπwΘJⁿOA]AwúA≤

ⁿO∩C

t@: w⌠BzC

: ½sΘJⁿOAPⁿw∩C

ACO0104E L∩G

í: TºπwΘJⁿOA]AwL∩

C

t@: w⌠BzC



ACO0105E ≥G

í: TºπwΘJⁿOA]A≥n'ⁿ

O∩C

t@: w⌠BzC

: ½sΘJⁿOAPⁿw'ⁿO

∩C

ACO0132W LklCN≥BzC

í: o!DLkqYlC

t@: NQΘJⁿO≥BzC

: \PTº@πΣLTºAHP

D]C

ACO0133W Σúw²Cb≥...í: w¬ n²AHP Tivoli Data Protection

íßwmCowóC

t@: NQΘJⁿO≥BzC

: ΣLTº±HoTºC\

ΣLTºAHPD]CpGLkPD

]Aiαn½swíßíXCoNTO

T]wn²C

ACO0134W ΣúΘx²CN≥Bz...í: w¬ n²AHP Tivoli Data Protection

íßΘxmCowóC

t@: NQΘJⁿO≥BzC

: ΣLTº±HoTºC\

ΣLTºAHPD]CpGLkPD

]Aiαn½swíßíXCoNTO

T]wn²C

ACO0150I w°@C

í: w"ΘJ ctrl-C nD⌠ Data Protection

for Microsoft SQL Server íßC

t@: w⌠BzC

: L

ACO0151E BznDoC

í: bBzΘJnDA²o!FC

t@: w⌠BzC

: q°ΘxPCMß

≤D½s⌡µⁿOC

ACO0152I αpGwßO seconds ϕb apicall

API Is

í: ⁿ∩ⁿXtú! API IswßOϕC

t@: ≥BzC

: L

ACO0153I αpGwßO seconds ϕb function

í: ⁿ∩RW\αwßOϕC

t@: ≥BzC

: L

ACO0154E Data Protection for Microsoft SQLServer íßLkww

Tivoli Storage Manager API C

w version.release.level ≤s

C

í: ewbtW Tivoli Storage Manager API

m Data Protection for Microsoft SQL Server

íßnC

t@: w⌠BzC

: wPs≤ⁿXºh Tivoli

Storage Manager API C@wH Data Protection

for Microsoft SQL Server íß@teC

ACO0155E Data Protection for Microsoft SQLServer íßLkww

Tivoli Storage Manager API C

w version.release.level ≤s

C

í: ewbtW Tivoli Storage Manager API

m Data Protection for Microsoft SQL Server

íßnC

t@: w⌠BzC

: wPs≤ⁿXºh Tivoli

Storage Manager API C@wH Data Protection

for Microsoft SQL Server íß@teC

ACO0156E LkⁿJ Tivoli Storage ManagerAPIC

í: LkⁿJ Tivoli Storage Manager APIC

t@: w⌠BzC

: TwwTawF Tivoli Storage

M a n a g e r A P ICMß / T R A C E F L A G S = A P I

/TRACEFILE=filename ∩⌡µ Data Protection for

Microsoft SQL Server íßA°lP

LkⁿJ]Ct@iα]KO TSMAPI.DLL

úsb≤t²CYOoípA½sw Tivoli

Storage Manager APIC

ACO0160E zxs Tivoli Storage Manager K

XoFτC

í: zLknJ Tivoli Storage Manager °AA]

o!FτC

t@: wεBzC

: xs Tivoli Storage Manager KXiαw

l Cpz Tivoli Storage Manager °AzC


ACO0161E τCΘJKXLCznJ

Tivoli Storage Manager °AC

í: ΘJKXúTC

t@: wεBzC

: ΘJT Tivoli Storage Manager KX

½C

ACO0162E ΘJKXúC½sΘJªC

í: ΘJKXúTC

t@: wεBzC

: ½sΘJKXC

ACO0163E nπ²⌠C

í: *π⌠ⁿw /intopath ∩C

t@: wεBzC

: ½sΘJⁿOAA≤ /intopath ∩ñⁿw

π⌠C

ACO0167E πW°C

í: w:°πWCowóC

t@: w⌠BzC

: L

ACO0200E Lk (filename) Hiµ¬C

í: wiµ¬ CowóC

t@: w⌠BzC

: L

ACO0201E Lk (filename) HiµgJC

í: wiµgJCowóC

t@: w⌠BzC

: L

ACO0202E Lk¬ (filename)Cí: wq¬ ΩCowóC

t@: w⌠BzC

: L

ACO0203E LkgJ (filename)Cí: wNΩgJCowóC

t@: w⌠BzC

: L

ACO0204E Lk÷¼ (filename)Cí: w÷¼CowóC

t@: w⌠BzC

: L

ACO0205E Lko (filename) pC

í: w opCowóC

t@: w⌠BzC

: L

ACO0206E Lk² (directory)Cí: w²CowóC

t@: w⌠BzC

: L

ACO0207E ²⌠ (directorypath) °C

í: w:°²⌠CowóC

t@: w⌠BzC

: L

ACO0208E S¼≈í@C

í: @ní±ií

nhCowóC

t@: w⌠BzC

: L

ACO0209E LkN (filename1) ≤W

(filename2)Cí: w≤WCowóC

t@: w⌠BzC

: L

ACO0210E Tivoli Storage Manager ¬h¡w

°C

í: w:° Tivoli Storage Manager ¬h

¡wCowóC

t@: w⌠BzC

: L

ACO0211E Tivoli Storage Manager Ch¡w

°C

í: w:° Tivoli Storage Manager Ch

¡wCowóC

t@: w⌠BzC

: L

ACO0212E Tivoli Storage Manager íW

°C

í: w:° Tivoli Storage Manager

íWCowóC

t@: w⌠BzC

: L


ACO0213E C@ Tivoli Storage Manager ºe\

j½≤pC

í: Fα≈@≈ΩπAh≈½≤N

eµ@º Tivoli Storage Manager °AñC

Tivoli Storage Manager °AwⁿXC@ºe\j

½≤p≤ Data Protection for Microsoft SQL Server

íßnpC

t@: w⌠BzC

: Wj Tivoli Storage Manager °AWC

@ºe\j½≤AMß½@C

ACO0214E ≈½≤zO≈súsbC

í: Tivoli Storage Manager °AwⁿX≈½≤

zO≈súsbC

t@: w⌠BzC

: pz Tivoli Storage Manager °A

zC

ACO0215E ≈½≤úSPzO≈

aC

í: Fα≈@≈ΩπAh≈½≤N

eµ@º Tivoli Storage Manager °AñCµ@

º≈½≤únπPzO≈

aC

t@: w⌠BzC

: pz Tivoli Storage Manager °A

zC

ACO0216E Lko (volumename) íΩ

TC

í: w oíΩTCowóC

t@: w⌠BzC

: L

ACO0217E Tivoli Storage Manager íWL

C

í: í²jLC

t@: w⌠BzC

: TíW°Br²j

C

ACO0218E Tivoli Storage Manager ¬h¡wL

C

í: ¬h¡wW²¡wLC

t@: w⌠BzC

: T¬h¡wW°Br²

jC

ACO0219E Tivoli Storage Manager Ch¡wL

C

í: Ch¡wW²¡wLC

t@: w⌠BzC

: TCh¡wW°Br²

jC

ACO0256E z Tivoli Storage Manager ∩ñ

KXwLCu≤KXvⁿO

≤ Tivoli Storage Manager °AK

XAMß≤ú∩ñKXC

í: z Tivoli Storage Manager KXwCzn

≤KXC

t@: w⌠BzC

: ≤KXⁿOAOnDz Tivoli

Storage Manager z≤zKXA oz Tivoli

Storage Manager °AIsKXC

ACO0257E zKXwLC

í: z Tivoli Storage Manager KXwCzn

osKXC

t@: w⌠BzC

: ≤KXⁿOAOnDz Tivoli

Storage Manager z≤zKXA oz Tivoli

Storage Manager IsKXC

ACO0258E zΘJKXCw ⌠BzC

í: ΘJKXúOKXC

t@: w⌠BzC

: ½sΘJⁿOAPⁿwKXC

ACO0259E zΘJτKXPΘJsKXúC

zKXNú≤C

í: zΘJτKXPΘJsKXúXC

t@: w⌠BzC

: A≤zKXATwsKX

τKXΘJFPKXC

ACO0260I wQ≤KXC

í: wQ¿≤KXⁿO

t@: w⌠BzC

: L

ACO0261I S°A servername ≈C

í: Tivoli Storage Manager °AWSⁿw°A

W≈C

t@: w⌠BzC

: L


ACO0263E Lk Web s²AX

returncodeC

í: w Web s²° TSM HTML Γ

UCowóC

t@: w⌠BzC

: HΓΦíz Web s²AMß

NªⁿVNz htm ²ñ bookfrm.htmC

ACO0264I Σúwqw]s²CN

Microsoft Internet ExplorerCí: w¬ n²APw]s²CMAiα

*wqw]s²CNP Microsoft Internet Explorer

wmC

t@: ≥BzC

: iα*∩twqw]s²CoúO

DCN Microsoft Internet ExplorerC

ACO0265E Σú Internet ExplorerCí: w¬ n²AHP Microsoft Internet

Explorer wmCowóC

t@: w⌠BzC

: Tww∩ Internet Explorer ]wFT

n²C

ACO0266E Σú Tivoli Storage Manager HTMLΓUC

í: w¬ n²AHP Tivoli Storage Manager Γ

UwmCowóC

t@: w⌠BzC

: iαn½swíßíXC

oNTOT]wn²C

ACO0267E ΘJτKXúXΘJsKXC

í: τKXúXsKXC

t@: w⌠BzC

: HτKX½ⁿOC

ACO0300E L¼C

í: nD¼LC

t@: w⌠BzC

: ½sΘJⁿOAPⁿw

¼C

ACO0301E L≈¼C

í: nD≈¼LC

t@: w⌠BzC

: ½sΘJⁿOAPⁿw≈

¼C

ACO351E Ll÷Σr - ’keyword’í: tmñⁿOµW TRACEFLAG ∩

úTC

t@: ßí*l]wAOb applet ñ*

lC

: ≤C

ACO357E LklΘX file-nameC

í: tmñⁿOµW TRACEFILE ∩w

FzLvgJ²⌠ file-name XC

t@: ßí*l]wC

: ≤ TRACEFILE AΣ¿zgJ

vmC

ACO366E Lk÷¼lΘX file-nameC

í: ÷¼lΘX file-name ío! (pA

íú¼)C

t@: ≥BzC

: d options.doc AH oiα

]íAótzC

ACO367E LkgJl tracefileCwlC

í: gJⁿw tracefile

t@: wlC≥BzC

: Twmis tracefileAB¼≈í

lC½ⁿOC

ACO368E LlW (W°)Cí: n]wñ TRACEFILE ∩F:°

WC

t@: ßí*l]wC

: ≤@ TRACEFILE WAª°

Ñ≤(≤ 255 rC

ACO383E Nl ’link’ ⁿw¿ Oúe\

C

í: l ’linkname’ úαOC

t@: ’linkname’ wRúAlw½A

BBzεC

: butracefilev∩ñⁿwlmC

ACO384E wQRú ’target’

’linkname’Cí: Θx ’linkname’ úαOC

t@: ’linkname’ wRúAΘxw½AB

BzεC

: dsmCYnⁿwΘx

mA\ΓU ’errorlogname’ ∩B’schedlogname’

∩ ’DSM_LOG’ ⌠C


ACO385E LkRú ’link’Cí: Θx ’linkname’ úαOC

t@: wεBzC

: Rú ’linkname’C

ACO476E program-nameGLk file-specG

errorC

í: TDP LkC

t@: TDP Lk¿nD@C

: A@CYD≥o!Aóz

tzC

ACO3000I Data Protection for SQLGq°A

server name lΩw database name

backup type ≈C

í: oO≈AgJ Tivoli Storage Manager

Server íΘxTºC

t@: L

: LñOⁿ

ACO3001I Data Protection for SQLGwgq°A

server name Q¿Ωw database

name backup type ≈C

í: oOQ≈ΩwAgJ Tivoli Storage

Manager Server íΘxTºC

t@: L

: LñOⁿ

ACO3002E Data Protection for SQLGLkq°A

server name ⌡µΩw database name

backup type ≈Arc = return codeC

í: oOΩwóAgJ Tivoli Storage


t@: L

: LñOⁿ

ACO3003I Data Protection for SQLGbl

restore type AN≈½≤ object

name °A server name WΩ

w database nameC

í: oOAgJ Tivoli Storage Manager

Server íΘxTºC

t@: L

: LñOⁿ

ACO3004I Data Protection for SQLGwQ¿



w database nameC

í: oObQ¿ΩwAgJ Tivoli Storage


t@: L

: LñOⁿ

ACO3005E Data Protection for SQLGLk⌡µ



w database nameC

í: oOΩwóAgJ Tivoli Storage


t@: L

: LñOⁿ

ACO3006I Data Protection for SQLG°A

server name ≈C

í: oOgJ Tivoli Storage Manager Server íΘxA

ⁿX≈lTºC

t@: L

: LñOⁿ

ACO3007I Data Protection for SQLG¿°A

servername ≈C∩ SQL ≈

G number selected SQL ≈

G number attempted ¿ SQL ≈

G number completed ú SQL

≈G number excluded úvG rate

Kb/ϕeG bytes gB

zíG time ϕ


ⁿX≈nD⌠TºC

t@: L

: LñOⁿ

ACO3008I Data Protection for SQLG¿°A

servername ≈C∩ SQL ≈

G number selected SQL ≈

G number attempted ¿ SQL ≈

G number completed ú SQL

≈G number excluded SQL≈G number inactivated úvG

rate Kb/ϕeG bytes g

BzíG time ϕ


ⁿX≈nD⌠TºC

t@: L


: LñOⁿ

ACO3009I Data Protection for SQLGw°

q°A server name ⌡µΩw

database name backup type ≈C


ⁿXwg °≈nDTºC

t@: L

: LñOⁿ

ACO3010I Data Protection for SQLG°A

servername C


ⁿXlTºC

t@: L

: LñOⁿ

ACO3011I Data Protection for SQLG¿q°A

server name °A server name

CwdΩw≈G number

inspected nDΩw≈G

number requested wΩw≈

G number restored ñLΩwG

number skipped úvG rate Kb/ϕe

G bytes gBzíG

time ϕ


ⁿX⌠TºC

t@: L

: LñOⁿ

ACO3012I Data Protection for SQLGw°

q°A server name ⌡µ restore type

AN≈½≤ object name Ω

w database nameC


ⁿXwg °≈nDTºC

t@: L

: LñOⁿ

ACO3013I Data Protection for SQLGq°A

servername

í: oObBzlAgJ Tivoli Storage


t@: L

: LñOⁿ

ACO3014I Data Protection for SQLG¿Bz

wdΩw≈G number

inspected nDΩw≈G

number requested wΩw≈

G number inactivated ñLΩw

G number skipped gBzíG

time ϕ


ⁿXⁿO⌠TºC

t@: L

: L

ACO3015I Data Protection for SQLG backup

type ≈ backup objectC

í: oOb≈½≤AgJ Tivoli Storage


t@: L

: LñOⁿ

ACO5050I wstmC

í: /configfile ñⁿwúsbCws

C

t@: ≥BzC

: LC

ACO5051I ΣútmANw]C

í: Σú /configfile ñⁿwC

t@: ≥BzC

: TwⁿwWOTC

ACO5052E ]wnDtm∩AoC

í: gJtmAo!C

t@: w⌠BzC

: °ΣLπ⌠≤TºC\Tº⌡µ

@ºßA½s⌡µⁿOC

ACO5053E option ∩LC\ TDPSQLCHelp Set ΘXuΓUvAHo

Set ⁿOC

í: ]wtm∩LC

t@: w⌠BzC

: ⌡µuTDPSQLC Help SetvuΓ

vAH o Set ⁿOC

ACO5054I wQ]wtm∩C

í: wQ]w Set ⁿOWⁿwtm∩C

t@: w⌠BzC

: L


ACO5056I LkR∩ logfile ΘxCN≥BzC

í: R∩ΘxóC

t@: ≥BzC

: iαOΘxúsbCYΘxsbA

°ΘxñiαDⁿC

ACO5057I wQR∩ logfile ΘxC

í: QR∩úΘxC

t@: ≥BzC

: LC

ACO5058W ΘxW°WXjCBzNb

µ²ñΘxW logfile ≥C

í: ΘJΘxWúπCϕπΘx

WAWXFΘxiα°C

t@: µ²ñΘxH≥Bz

C

: ziHπ⌠A≤sΘxW

C

ACO5059W Lk logfile Θx@gJO²º

CLkO²≤C

í: LkúΘxAHLk[⌠≤O²C

]Aú⌡µ⌠≤OⁿC

t@: BzbúO²¼pU≥⌡µC

: PwLkΘx]CΘxiα

úsb≈AwNΘx

¬C

ACO5060E o Tivoli Storage Manager API

C

í: o! Tivoli Storage Manager API C

t@: w⌠BzC

: A@CpG#o!Aó

ßANϕC

ACO5061E o Microsoft SQL API C

í: o! Microsoft SQL API C

t@: w⌠BzC

: A@CpG#o!Aó

ßANϕC

ACO5063I únR∩ logfile_name ΘxC

í: únR∩ⁿwΘxC

t@: ≥BzC

: ΘßR∩ΘxCYeΘx:

jAYεΘxOd#C

ACO5064W Lk logfile_name Θx@gJO

²ºCR∩ΘxAHNúO²

≤C

í: LkúΘxAHLk[⌠≤O²C

]Aú⌡µ⌠≤OⁿR∩C

t@: BzbúO²MúR∩¼AU≥⌡

µC

: PwLkΘx]CΘxiα

úsb≈AwNΘx

¬C

ACO5065E /SQLUSer ∩ⁿwAPn²

úC

í: oX BackupBRestore Query SQL ⁿOAⁿ

wF /SQLAUTHentication=SQLUserid /SQLUSer ∩C

qn²ñ o sqlpassword A²On²ñ

ID P /sqluser ∩ⁿw ID úC

t@: w⌠BzC

: oXⁿOAbⁿOWⁿwXn²

/sqluser APⁿw /sqluser /sqlpassword ∩

C

ACO5091E PASSWORDACCESS GenerateCi

αOxsKXúTOSxsKXC

YzTΩSxsKXA

-TSMPassword=xxx ∩]wxsz

KXC

í: ß∩ñ PASSWORDACCESS ∩]w

generateCMASxsKXCz²xs@

lKXC

t@: w⌠BzC

: -TSMPassword ∩A½sIsⁿ

OCb⌠≤ß≥ⁿOúⁿwKXYi¿C

ACO5400E u@δ½≤¼vn²uΩm

vC

í: *@δ½≤¼n²ΩmAHLk

ΩmCiαO*Tw SQL ServerC

t@: w⌠BzC

: τwTw SQL ServerAMß½@

CY6XApzßANϕC

ACO5401E LkuΩmvC

í: LkΩmC SQL Server Ωm

Θx Windows NT ≤ΘxñAiαΩTC

t@: w⌠BzC

: Y SQL Server Tº*MDA½

@CY6XApzßANϕC


ACO5402E LkuΩmvC

í: LkΩmC SQL Server Ωm

Θx Windows NT ≤ΘxñAiαΩTC

t@: w⌠BzC


@CY6XApzßANϕC

ACO5403E LkouΩmvtmC

í: Lk oΩmtmC SQL Server Ω

mΘxBSQL Server íΘxBSQL Server Θx

Windows NT ≤ΘxñAiαΩTC

t@: w⌠BzC

: Y SQL Server Tº*≤UMDA

½@CpG#o!AóßANϕC

ACO5404E uΩmvLkΩmC

í: ΩmLkΩmC SQL Server Ω

mΘxBSQL Server íΘxBSQL Server Θ

x Windows NT ≤ΘxñAiαΩTC

t@: w⌠BzC


@CY6XApzßANϕC

ACO5405E úΩmC

í: Ωm"ú" XC\n″ SQL Server Ω

mΘxBSQL Server íΘxBSQL Server Θx

Windows NT ≤ΘxñAiαΩTC

t@: w⌠BzC


@CY6XApzßANϕC

ACO5406E SQL Server L¡÷¼ΩmC

í: SQL Server wñε∩ΩwW@C SQL

Server ΩmΘxBSQL Server íΘxBSQL

Server Θx Windows NT ≤ΘxñAiα

ΩTC

t@: w⌠BzC


@CY6XApzßANϕC

ACO5407E SQL Server wñε@C

í: SQL Server wñε∩ΩwW@C SQL

Server ΩmΘxBSQL Server íΘxBSQL

Server Θx Windows NT ≤ΘxñAiα

ΩTC

t@: w⌠BzC


@CY6XApzßANϕC

ACO5420Eí: o! SQL API C

t@: @Bz⌠C


@CY6XApzßANϕC

ACO5421E q MS COM ≤¼UCTºG SQL

message

í: o! SQL C

t@: @Bz⌠C


@CY6XApzßANϕC

ACO5422E q MS SQL Server ≤¼UCT

ºG SQL message

í: o! SQL C

t@: @Bz⌠C


@CY6XApzßANϕC

ACO5423E UCrΩ°Gstring

í: o! SQL C

t@: @Bz⌠C


@CY6XApzßANϕC

ACO5424E Lks SQL ServerFSQL ServerG SQL message

í: o! SQL C

t@: @Bz⌠C


@CY6XApzßANϕC

ACO5425E SQL Server ⌡µGSQL message

í: o! SQL C

t@: @Bz⌠C

: SQL Server ½@C

ACO5426E SQL nJúπtz (Sysadmin) ñ

ΓGSQL message

í: nJ SQL ServerA²ⁿwnJWúπt

z (sysadmin) ñΓC

t@: @Bz⌠C

: ½@ⁿwπtz (Sysadmin)

ñΓnJWA≤ⁿwnJWAΣπt

z (Sysadmin) ñΓC


ACO5427E SQL Server p≤ 7.0GSQL

message

í: H± SQL Server 7.0 ≤¡

Data Protection for SQL Server V2CoOúµC

t@: @Bz⌠C

: H± SQL Server 7.0 h≤¡

Data Protection for SQL V1 ßAH SQL

Server 7.0 s½@C

ACO5428E SQL Server úb≈WGSQL

message

í: íßⁿw SQL ServerA²ª

úb≈WC

t@: @Bz⌠C

: b SQL Server b≈W½@C

ACO5429E Lkq SQL Server o≤GSQL

message

í: o! SQL C

t@: @Bz⌠C


@CY6XApzßANϕC

ACO5430E SQL Server W NULLCí: d SQL Server WA²t" WC

n SQL Server WAα≥@C

t@: µ@Bz⌠C

: quSQL dRívuselect

@@servernamevⁿOAd SQL Server WCY"

NULLAhusp_addservervxsAN SQL Server

W]wTC]w SQL Server WßA½@

CY6XApzßANϕC

ACO5431E úe\h dbnameCí: oX RESTORE ⁿOLC

/STANDBYB/RELOCATE /INTO ∩Aúαb

<dbname> MµñⁿwhΩwWC

t@: w⌠BzC

: bm∩WA½sΘJπ

ⁿOC

ACO5432E ⁿw /RELOCATE /TO ∩Aq

ÑC

í: RESTORE ⁿOWⁿw /RELOCATE /TO ∩

qúPC

t@: w⌠BzC

: ⁿwPq /RELOCATE /TO ∩A

½sΘJⁿOC

ACO5433E úe\Ur@UC/∩@í

≈G

í: Tºπ*Tⁿwm/∩C

t@: w⌠BzC

: ½sΘJⁿOAPⁿwT/

∩C

ACO5434E LkPⁿwUC∩G

í: TºπwΘJ ≡ⁿO∩C

t@: w⌠BzC


ACO5435E ⁿOnUCΣñ@∩G

í: TºπΘJºⁿO≥∩C

t@: w⌠BzC

: ½sΘJⁿOAPⁿwⁿOnΣ

ñ@ⁿO∩C

ACO5436E bs (stripe number) ÑqWo

óArc = return code

í: bsÑqWo!FóC

t@: w⌠BzC

: ΣLTº±HoTºC\

ΣLTºAHPD]C

ACO5450E ⁿwÑqq (number of stripes)LCBzNÑqqj

(maximum number of stripes)A≥⌡

µC

í: ⁿwÑqqLC

t@: Bze\ÑqjA≥⌡

µC

: L

ACO5451E Ωm (vdev name) óAX =return code

í: ⁿWΩmóC

t@: w⌠BzC

: úFTºº&AπΣLTºC

\ΣLTºAHPD]C

ACO5452E LkRús½≤G(filespace name) (high

level qualifier) (low level qualifier)í: ϕ≈óATDP Nzq TSM °AR

ú s≈Ω½≤CTºⁿXLkq TSM °A

Rúzⁿw s≈Ω½≤Co!AqO

]yó TSM °AÑq@C

t@: ≥BzC

: LC Ωw≈ s≈Ω½


≤ABq TSM °AñRúªC

ACO5453E TSM Ñq@ (number of TSM

sessions) ∩≤ⁿwÑq (number

of stripes) LCBzN≥H TSMÑq@ (number of TSM sessions)@ÑqC

í: zⁿwÑqq TSM Ñq@

qLCTºOíy¿C

t@: Bz TSM Ñq@qAϕ¿Ñq

qA≥⌡µC

: A@@CY6XA

pzßANϕC

ACO5454E C@ TSM ºe\½≤qj

(number of objects allowed per TSM

transaction)AúA≤ⁿwÑqq

(number of stripes)CBzN (new

number of stripes) ÑqA≥⌡

µC

í: C@ TSM ºe\½≤qjA(ú

A≤@ TSM Ñq@ⁿwÑqqC

TSM Ñq@∩C@ TSM ºe\½≤qA(

n±Ñqqh@C

t@: BzsÑqqA≥⌡µC

: ε(ÑqqCz]i≤s TSM °

AAW[ßbµ@ºñiHe°Aº Φ

qj (TxnGrpMax)C

ACO5455E ≈wlALkC

í: n≈w lA]ΣΩ½≤½≤

P meta Ωú∩C

t@: w⌠BzC

: A@@CY6XA

pzßANϕC

ACO5456W ≈wlALkCBzN

≥C

í: n≈w lA]ΣΩ½≤½≤

P meta Ωú∩Cí≈iHA°ⁿO

≈¼wC

t@: ≥BzC

: A@@CY6XA

pzßANϕC

ACO5457E oú SQL API C

í: o! SQL API A²Σú÷TºC

SQL Server ΩmΘxBSQL Server íΘxB

SQL Server Θx Windows NT/2000 ≤ΘxñA

iαΩTC

t@: w⌠BzC


@CY6XApzßANϕC

ACO5458W TSM Server I (TSM server

NODENAME) ’backup delete’ ]w

]w NOC@UA]w

YESCN≥BzC

í: zⁿw NODENAME ºe\ TSM ßRú

≈ TSM Server ]wA]w NOCYnQ⌡

µMú@A]w YESCNO ϕLk

lΩAiαxsb TSM Server WC

t@: ≥BzC

: Tw T S M S e r v e r Wzⁿw

NODENAME ’backup delete’ ]wA]w YESCz

TSM Server zAiH≤ NODENAME ]

wC]wib TSM Server Wiµ≤C

ACO5500E MultiByteToWideChar() τóC

í: oOⁿXxsΘl íC

t@: ΩwBz⌠C

: A@@CY6XA

pzßANϕC

ACO5501E u@δ½≤¼v(COM) íwLkl

]wC

í : Is

CoInitializeEx(NULL,COINIT_MULTITHREADED) ú¿\C

iαO≥óBl OLE32.dll t@ COM dll

PC

t@: ΩwBz⌠C

: τz Windows NT ( 4 s) w

OπA½@CY6XApz

ßANϕC

ACO5550I SX directorypathfilename M°AW

servername ≈C

í: Tivoli Storage Manager °AWSzⁿw°A

WΩw≈C

t@: w⌠BzC

: L

ACO5551I S≈X°AW servername ⁿw

hC

í: Tivoli Storage Manager °AWSΩw≈

Xzⁿw°AWdhC

t@: w⌠BzC

: oXdAⁿwd≥sjM

hC


ACO5552I ΣúPⁿwhC

í: wb SQL Server ñjMXⁿwhΩwC

t@: w⌠BzC

: dzⁿwjMh (ΩwWBsW

B ΦW)C½sΘJⁿOC

ACO5715E N option_name n]wgJtmo

C

í: LkNⁿwn]wgJtmC

t@: w⌠n]wBzC

: TwztmAMß½≤sn

]wC

ACO5716W bl]w Tivoli Storage ManagerAPI oArc = returncodeC

d dsierror.log Ho÷ΩTAPw

TSM API OwTC

í: ]w Tivoli Storage Manager API íAo!

C

t@: ≥BzC

: d dsierror.log eHΣXDo

!]CYúsbAiαOSAϕaw TSM

APICY*Aϕaw TSM APIA½sw TSM API

½s⌡µⁿOC

ACO5717E LknJ SQL ServerCí: nJ SQL Server Ao!C

t@: YqⁿOµ⌡µßAhß⌠C

Yq GUI ⌡µßAhúzΘJ SQL ID

KXAOúz∩ Windows τC

: Twb⌡µ SQL ServerC

ACO5718I ½sπz°eA≥ó∩wd

≥ABeHπAi

s≡¼ cCzn≥H

í: w∩ ½sπzuπC÷sU\αϕC

t@: ≥BzC

: ∩ uOv½sπz°eA∩

uvHOdµ°e*≤¼AC

ACO5719I e TSM WS≈C

í: wbuvñ÷U SQL Server Wi÷

sC

t@: wεBzC

: iαOS≈ TSM ServerAOw

@ñ≈C

ACO5720I ∩n≈ΩwC

í: w÷U GUI Wu≈v÷sA²Sq≡¼c

Mµñ∩ ΩwC

t@: wεBzC

: ∩ Ωw½s÷Uu≈v÷sC

ACO5721I ∩n≈C

í: w÷U GUI Wuv÷sA²Sq≡¼c

Mµñ∩ ≈½≤C

t@: wεBzC

: ∩ ≈½≤A½s÷Uuv÷sC

ACO5722I ∩n≈C

í: w÷U GUI Wuv÷sA²Sq≡¼c

Mµñ∩ ≈½≤C

t@: wεBzC

: ∩ ≈½≤A½s÷Uuv÷sC

ACO5723E ⁿwⁿWOC

í: w∩u≤OBεvubOeεv∩

A²oSⁿwⁿWOC

t@: wεBzC

: ΘJⁿWOA∩uε≤v∩C

ACO5784E ∩ΘxαíIC

í: ]wíIºeA²∩ ΘxC

t@: wεBzC

: ⁿwíIºeA(n∩@Θ

xC

ACO5804I LkoΩTCΩYO≈aA

∩uÑⁿaHoΩTv ∩

C

í: wεBzC

t@: L

: 3∩TºñⁿwΦC

ACO5805W z SQL ServerAúP≤z

enJ SQL ServerCzn≥H

í: ≥BzC

t@: L

: zYnqúP SQL Server A÷U

uTwvFhA÷Uu °vAnJΣL SQL

ServerC


N

ΩTOw∩ IBM bⁿΩúºúPAoXC

bΣLΩañAIBM úúoúñúUúBAB\αCnDb

zbºOioúPAAVϕa IBM NϕdCbú

IBM úBíAAúϕquα IBM úBíAC

un*I; IBM z]úvA⌠≤\αϕúBíAúiH N IBM

úBíACúLAΣLD IBM úBíBAbB@WPτA

Σd⌠≤C

boσ≤ñiα]t IBM ºMQMQ<Cú"

ezMQº⌠≤vCziHΦídvAτHG

IBM Director of LicensingIBM CorporationNorth Castle DriveArmonk, NY 10504-1785U.S.A.

UCq¿YPΩºk°ΦAY°úAG IBM H¼úAúú

⌠≤qºO (]A²ú¡≤*AIvBiΓXSwO)CY

abYµ÷Wú+\úWzOAhúLC

ΩTñiαNWLΩWC]AIBM w qFN qß

eJsñCPAIBM oH∩i () ñúú ()

íC

ΩTñ⌠≤∩D IBM ⌠zAIBM ∩⌠úúOC Web

WΩAD IBM úΩ@íA] Web y¿ºlA"

QßµtdC

IBM oHUAϕΦí¼" Qßú⌠≤ΩTAL∩ztdC

íº≥vYµ o÷ΩAHKUCΩTió IBMCΣUCΩT

ⁿOG (1) WíPΣLí (]Aí) ºí≤½ΩTΦí (2) ¼

wµ½ºΩTΦk Y⌠≤DpG

IBM CorporationInformation Enabling RequestsDept. M135600 Cottle RoadSan Jose CA 95193-0001U.S.A.

WzΩº oΣSϕn≤AbYípUIOΦoC

IBM ≥≤ΦºuIBM ßX vBuΩívX v⌠≤PÑX º°A

úσ≤ñzºvíPΣAvΩC


úºD IBM úΩTAY@"úAΣXnΣL

D oCIBM *LoúA]LkToD IBM ú⌡µαBe

B⌠≤∩úΣLDiOLCpGz∩D IBM úα⌠≤

AwVúdC

ΩT@WCbzºúW½ºeABΩTiαH≤C

YzO°ΩTqlAh;MmΓiαúXC

UCWⁿO IBM® Corporation bⁿΩ () ΣLΩaG

IBM

Tivoli

Microsoft®BWindows®BWindows NT® Windows xO Microsoft Corporation b

ⁿΩ () ΣªΩaC

ActionMediaBLANDeskBMMXBPentium H ProShare O Intel Corporation bⁿΩ

() ΣªΩaC

ΣªqBúAWAiαOΣªqAxC


Wⁿ

WⁿñⁿJYMw∩ Tivoli Storage Manager íwwqCYzΣú

nΣⁿJAiUC URL \ IBM Dictionary of ComputingG

www.ibm.com/networking/nsg/nsgmain.htm

Wⁿ]AⁿJMwqiα≤G

v American National Standard Dictionary for Information Systems, ANSI X3.172-1990,

copyright (ANSI)CiV American National Standards Institute RAaG

11 West 42nd Street, New York, New York 10036C

v Information Technology VocabularyA" International Organization for Standardization

pe (Joint Technical Committee 1) International Electrotechnical Commission

(ISO/IEC JTC2/SC1) oC

ñí (central scheduler). i²zwß@MzⁿO@\αCiw@wo!AbYTΘiµC

¡

Dq[c (client/server). @hí (ß) Vt@í (°A) nDpΓΩA@t[cC

ß∩ (client options file). ßisΦ@A]t@w]Bz∩Aα≈O°ABqTΦkB

≈MOs∩Bíz∩H∩C

"

Θx (recovery log). YNgΩw≤sΘxCQΘxiqtMCΘóñ"C

C

π≈ (full backup). @sπΩw Tivoli Storage Manager \αCπ≈l@sΩw≈t

CC

E

¼ínO (closed registration). @n²BzAzV°AnOu@@ßIC

ⁿOµ (command line interface). @¼ABⁿOObⁿOµWⁿwC∩í(graphical user interface)C

Q

h (policy set). @ Tivoli Storage Manager h½≤AⁿwsizOCisb@HWh

CMA@uα@@ñhC


|

|

|

http://www.ibm.com/networking/nsg/nsgmain.htm

h⌠ (policy domain). @ Tivoli Storage Manager h½≤Ai² Tivoli Storage Manager ÷ΣtΣh

H÷zhzANßICh⌠]t@hhC

Q@

qH≤w (communication protocol). i²qúqT@wwqC

QG

≈Osß (backup-archive client). @bu@°AW⌡µíAªiú@i²≈BOsBM ≈εC∩zß (administrative client)C

≈s (backup copy group). ]t ε≈ú!BaM¡Ñh½≤C≈s≤

zOC

QT

ΘεqH≤w/⌠⌠⌠qH≤w (Transmission Control Protocol/Internet ProtocolATCP/IP). ΣMs⌠⌠º∩Ñís\α@qH≤wC

Q

í (graphical user interface, GUI). @¼AªQ¬R °uIA]AXB½≤@íⁿmB\αϕCB½°íMC∩ⁿOµ (command line interface)C

zß (administrative client). b°ABu@j¼qúW⌡µíAªi²zzLzⁿO εM °°AC∩≈Osß (backup-archive client)C

z (administrator). wV°AnOCziQvUCΣñ@hzMvOG

systemBpolicyBstorageBoperator analystCzizßΘJPΣMv@P°AⁿOMdC

zO (management class). @ Tivoli Storage Manager h½≤Aª≈BOsMízSwhPß

÷pCzOiP]t≈MOssB]ts]tOsCzO]i]AÑh

íxsΘz (HSM) ízhC

Q¡

Wq≈ (incremental backup). (1) i²≈seWq≈ºß≤²@\αCB

\αAiHß⌠≈ include-exclude MµñwúBXWvBíMCD²Ap

wⁿwzO≈sñwqC (2) @ Tivoli Storage Manager \αAªusΩws

eπWq≈ºß≤ºΘxC∩π≈ (full backup)C

Tw (commit). bΩwñiµ3[≤Cw≤nÑTwºßΓ3[≤C

s (copy group). @ Tivoli Storage Manager h½≤AªMw Tivoli Storage Manager p≤≈OsC

s≤zOCΓsG

v ≈s--Mw Tivoli Storage Manager p≤≈OsC

v Oss--Mw Tivoli Storage Manager p≤OsC

QC

úY (compression). xsΘíBzAΣΦíORúµúnΩHε(°Cb Tivoli Storage

Manager ñAϕ≈Os°AxsΘºeAibu@iµúYCbY¼a≈WAiwΘúYC


í]p (application program interface, API). @τAbß¡xW⌡µíiHIsªxsBd Tivoli Storage Manager xsΘñ½≤C

G

GUI. í (Graphical user interface)C

T

TCP/IP. Θ εqH≤w/⌠⌠⌠qH≤w (Transmission Control Protocol/Internet Protocol)C

Sϕr

Data Protection for SQL. @ Tivoli Storage Manager íAªi²z⌡µuW≈ Microsoft SQL Ωw Tivoli

Storage Manager xsΘC

Tivoli Storage Manager. @Dq[cíAúßbhqú⌠UxsΘzC

Wⁿ 155

'HñσrAσrAS

ϕºCC

e@f@Pdí 10

eGfGi 102

eTfuπCAGUI 27

ww≈ 6, 13, 117

efñíAí

18

í\αϕAGUI 25, 26

h 102

ΣAData Protection for SQL

nΘ 13

qT≤w 14

wΘ 13

Θx≈

GUI 30

22

ªñ 8, 10

º[ 3

Θxw⌠

CLI 104

GUI 30

ΘxIªñ 10

Θx

≤DR 137

Θx

GUI 33

º[ 4

ΘxAI

CLI 115

GUI 30

e¡fDnΩwA 134

\αϕCAGUI 25

iúCΘ 10, 17, 19

iúCΘ (≥)

22

u¡≈OΘxs

d@ 22

Tivoli Storage Manager Server n²

17

e"fWⁿ 153

"¼

d 92

"∩AGUI 34

bdIIΘx∩ 10, 31

ªñ 10

hí 134

h SQL Servers

ªñ 10

hⁿI 10

rX ID

d 92, 94

s ΩwA¡ε 103

w 6

w Data Protection for SQL

bh°AW (]w) 125

(]w) 125

wData Protection for SQL 14

@tD 13

íD 13

nΘD 13

wΘD 13

≈ 6, 13, 117

hA]w 19

eCfm

÷ⁿOCX 41

º[ 39

í 87

⌠pAΘx

CLI 104

GUI 30

⌠pAtº

CLI 103

GUI 30

°AW

∩ 18

°AASQL

d 92

°AATivoli Storage Manager

h 19

d 93

tm 17

@ñ/D@ñ¼A

GUI 34

inactivate ⁿO 75

ⁿπ≈vT 89

d 101

ΘXd 77

@ 107

@tD 13

@⌠ 14

πΘx≈ªñ 8

πBttºΘx≈ªñ 9

π≈

GUI 30

ªñ 8

º[ 3

π

GUI 33

º[ 4

≤sIⁿO 10

a"pe 10, 13

eKfm 17

mA

Yα 10

íA]w 134

h 21

hA]w 19

N∩AGUI 34

eAData Protection for SQL 1,

62

ε 21

εh 21

íD 13

íAxs

ªñ 8

ϕµM'

≈ 9

Oss 21

eEf'@ 88, 90

Tivoli Storage Manager h 21

≈°A∩AGUIC 37


ⁿOµ

(&) 87

º[ 39

ⁿOAData Protection for SQL

º[ 39

yk 46

í 46

tdpsqlc backup 46

tdpsqlc changetsmpassword 85, 99

tdpsqlc help 79

tdpsqlc inactivate 75

tdpsqlc query 52, 92

tdpsqlc restore 62

tdpsqlc set 83, 95

ⁿWO

º[ 5

ⁿWOA

iúCΘ 23

Ñq 23

d TSM ∩ 54, 94

d@

m 87, 92

@ñ/D@ñ¼A 34, 101

εCΘⁿ 22

CLI 52

d Tivoli Storage Manager Server 6

º[ 40

º[ 5

yk 52

í 52

dΘX 55

∩ 42

query SQL 6, 92

query TDP 93

query TSM 93

d≈½≤ 36, 93

eh

d 93

½swm∩

GUI 37

º[ 5

½sVΘX 52

½sπz GUI ≡¼c 26

¡εΩws 103

eQfh 21

tº⌠p

GUI 30

tº≈

GUI 30

º[ 3

tº≈ªñ∩Θx≈ªñ 8

tº

GUI 33

tº (≥)

º[ 4

α 7, 18

/diffestimate 103

/logestimate 104

αD 88

íIⁿWO

CLI 113

GUI 35

íI

º[ 5

íI∩AGUI 35

íAxs

ªñ 8, 9

'Mϕµ

≈ 9

OΘxs

meta ½≤ 22

tmMí

d 92, 93, 95

tmΩTACX 102

tmAData Protection for SQL

]wACLI 83, 95, 102

]wAGUI 25

query TDP 93

tmAData Protection for SQL

l 18

tmA

Ñq 9

eQ@fε (íI) ∩AGUI 35

@

m 87

CLI 75

GUI 37

εh 22

º[ 6

yk 75

í 75

dΘX 77

∩ 42

ACLI

Φ 44

÷ⁿOCX 41, 42

º[ 39

Aí

m 87

tº 89

≈½≤¼ 87, 94

A≤ changetsmpassword ⁿO

99

A≤ query ⁿO 92

A≤ set ⁿO 95

dbname 87

Aí (≥)

m (≥)

file 88

full 88

group 89

log 90

set 91

∩ 100

/active 101

/all 101

/buffers 101

/buffersize 102

/compatibilityinfo 102

/configfile 102

/dboonly 103

/diffestimate 103

/fileinfo 103

/files 103

/fromsqlserver 104

/groups 104

/into 104

/logestimate 104

/logfile 105

/logprune 105

/mountwait 106

/object 107

/olderthan 107

/partial 107

/quiet 108

/recovery 108

/relocate 109

/replace 109

/sqlauthentication 110

/sqlbuffers 110

/sqlbuffersize 110

/sqlpassword 110

/sqlserver 111

/sqluser 112

/standby 112

/stopat 112

/stopatmark 113

/stopbeforemark 113

/stripes 114

/truncate 115

/tsmnode 115

/tsmoptfile 115

/tsmpassword 116

/to 109

DR 102, 137

KXs v¡ú!A]w 18

KXA TDP

≤

CLI 85

KXATivoli Storage Manager

dsmcutil z 18


KXATivoli Storage Manager (≥)

≤

CLI 99

GUI 26

\αϕAGUI 37, 38

víA]w

CLI 98, 110, 112

GUI 26

ID

d 92, 94

≈ 11

≈ 117

d 117

ú!KXA]w

∩ 18

úαAWi 101, 102

ºΘx

d 92

]wtm

GUI 25

nΘD 13

qT≤w

Σ 14

∩ 18

qT≤wAqT

Σ 14

í≈∩

GUI 35

º[ 5

eQGf≈ªñ 8

≈@

117

m 87

CLI 46

GUI 30

≈s/ 31

≈Ωw 30

≈≡¼c ε 31, 32

≈∩ 30

ªñN 8

º[ 3

yk 46

í 46

dΘX 48

∩ 42

≈½≤

d 93

P°Ae 102

≈½≤¼ 3, 40

GUI 28

tº 89

º[ 40

≈½≤¼ (≥)

yk 46, 52, 63, 75, 79

í 87

A≤d Data Protection for

SQL 94

file 88

full 88

group 89

log 90

set 91

µ@í 134

≤ 62

CΘα 19

CΘⁿ 17

d ε 22

tm 17

N 10

nJ°A

ID 7

nJ]w

CLI 98, 110

GUI 26

n²IⁿO 10

wΘD 13

Ñaⁿ∩A GUI 34

ÑqAGUI 34

ÑqAΩ

CLI 98, 114

GUI 30, 31

aⁿ 17

MaCΘ 9

ªñ 9

]w 23

ft /sqlbuffers 98, 110, 114

Data Protection for SQL α 7

Tivoli Storage Managertm 17

≈

GUI 30

22

ªñ 10

º[ 4, 5

eQTfíN 88, 89

íN 8, 88, 89

sWMí

/fileinfo query 95

s≈

GUI 30

ªñ 9

º[ 4, 5

s

GUI 33

Ω½≤

b½≤RWΦ 131

Ωw

GUI ≈ 30

d 92, 93

∩ 92

Dn 134

n GUI 33

ΩwΩT

GUI 28

Ωw ∩AGUI 34

ΩÑq

CLI 98, 114

GUI 30, 31

ⁿWO 23

aⁿ 17

9

d 93

]w 23

ft /sqlbuffers 98, 110, 114

w 95, 101, 102


ΩúY

ªñ 9

∩ 18

eQfí (GUI)

@δ∩ Wh 28

uπC 27

\αϕC 25

SQL Ωw 37

\αϕ

p 37

A≤ 38

≈ SQL Ωw 30

≈Mµ ε 32

≈s/ 31

≈Ωw 30

≈≡¼c ε 31

≈∩ 30

º[ 25

SQL Ωw 33

Mµ ε 36

s/ 33

Ωw 33

≡¼°e 35

∩ Wh 33, 34

∩ 34, 35

ΩΘW

/fileinfo query 95

IΘx

GUI 30

ªñ 10

aCΘ

MÑq 9

ó 9

' 159

ⁿ 19

zO

p meta M Ω½≤ 22

½≤RW 19

18, 21

include »zí 131

meta MΩ½≤ 131

yk

d 52

≈ 46

changetsmpassword 85

help 79

inactivate 75

restore 63

set 83

yk, CLI

Φ 44

º[ 39

í\αϕAGUI 27

íAuW 11

eQ¡fdΘX

dⁿO 55

≈ⁿO 48

changetsmpassword ⁿO 85

help ⁿO 79

inactivate ⁿO 77

restore ⁿO 68

set ⁿO 83

sΦ\αϕAGUI 25

uWí 11

w jp

A≤ SQL °A 98, 110

A≤ TDP 95, 102

w Ω

ftÑq 98, 110

A≤ Data Protection for SQL 95,

101

A≤ SQL °A 98, 110

A≤ TDP 102


w q

ftÑq 98, 110

A≤ Data Protection for SQL 95,

101

A≤ SQL °A 98, 110

s 22

eQ"fπX ID í 98, 110

∩

÷ⁿOCX 42

∩ (≥)

í 100

∩ WhAGUI

p 33, 34

A≤≈ 28

∩AData Protection for SQL

]w 18

O 11

include/exclude »zí 131

Θx 137

eQCfúYΩ 9

∩ 18

dsm.opt 118

sqlfull.log 122

sqlsched.log 122

≈

GUI 30

ªñ 9

º[ 4

GUI 33

º[ 4

°e\αϕAGUI 25

°∩AGUI 34

@

DnΩw 134

m 87

CLI 63

GUI 33

"∩ 34

N∩ 34

≈°A∩ 37

½swm∩ 37

íI∩ 35

í≈∩ 35

Ñaⁿ∩ 34

Ñq∩ 34

Ωw ∩ 34

ε 33

∩ Wh 33, 34

∩ 37

Mµ 36

≡¼c 35

∩ 34

π@ñMD@ñ∩ 34

ⁿWO 23

úP SQL Server 10

D@ñ½≤ 107

ⁿWO 35, 113

ªñ 9

íI 35, 112, 113

µ@í 62

@ (≥)

º[ 4

yk 63

í 62

dΘX 68

A≤αm 10

∩ 42

TDP 1 D 62, 75

GUI 33

eQKfO 11

Σ 13

w 15

ªñ 9

O°A

bΣW⌡µ Data Protection for

SQL 11

O¼A

d 92, 93

µ"¼ 10

eGQTf≤ Tivoli Storage Manager KX

GUI 26

ΦW

/fileinfo query 95

π@ñMD@ñ∩AGUI 34

Aactive 101

all 101

API, Tivoli Storage Manager 14, 93

Bbackdelete 17

buffers 95, 101

buffersize 102

Cchangetsmpassword ⁿO

m 99

yk 85

í 85

dΘX 85

∩ 42

clusternode

∩ 19


compatibilityinfo

Data Protection for SQL d 93

SQL d 92

compatibilityinfo 102

configfile 102

DData Protection for SQL

wΣnΘ 13

He 1, 14

\αº[

d 5

≈ 3

inactivate 6

restore 4

b MS Cluster Server W⌡µ 11

w 6

w 13, 14

d 93

α 1, 62

ⁿO 39

α 7

S 2

sW 1

tm 17

tmd 93

tmA]w

CLI 83, 102

GUI 25

≈¼ 3

Lnw 125

n² 17

wΘΣ 13

uWí 11

w q 95, 101

∩

h 19

tm 18

clusternode 11

buffersize 95, 102

Data Protection for SQL S

º[ 2

Data Protection for SQL Lnw

125

data M meta ½≤ 22

dateformat 95

dbcc 3∩∩ 10

dbname

í 87

dboonly 103

differential

yk 46, 52, 63, 75, 79

í 89, 94

diffestimate 96, 103

dsmcutil.exe í

18

dsm.opt

18, 45

h 19

Tivoli Storage Manager 118

Eenablelanfree

∩ 19

Ffile

yk 46, 52, 63, 75, 79

í 88, 94

fileinfo 103

πΩT 95

files 103

fromsqlserver 96, 104

query M inactivate d 77

full

yk 46, 52, 63, 75, 79

í 88, 94

Ggroup

yk 46, 52, 63, 75, 79

í 89, 94

groups 104

Hhelp ⁿO

yk 79

í 79

Iinclude/exclude

yk 19

d»zí 131

into 104

LLAN free


log

yk 46, 52, 63, 75, 79

í 90, 94

logestimate 104

logfile 96, 105

logprune 97, 105

Mmaxnummp 10, 17

pCΘtm 17

meta M data ½≤ 22

meta ½≤

b½≤RWΦ 131

xs≤OΘxs 22

meta Ωh, ]w 131

mountwait 106

mountwaitfordata 97

MSCS ⌠

Σ 11

α½¿ 11, 15

msdb Ωw

meta ½≤ΩT 23

msiexec.exe

≤Lnw 127

Nnodename

∩ 18

numberformat 97

Oobject 107

olderthan 107

ΘXd 77

Ppartial 107

Qquiet 108

Rrecovery 108

relocate...to 109

replace 109

Sset ⁿO

m 95

yk 83

í 83

' 161

set ⁿO (≥)

dΘX 83

∩ 42

set

yk 46, 52, 63, 75, 79

í 91, 94

setup.exe

≤Lnw 127

SQL Server

bO⌠ñ⌡µ 15

ID 26, 98, 110

w jp 98, 110

w q 98, 110

τí 26

SQL Server 2000

h 102

Σ 13

ⁿ¡í 103

d 92

ⁿWO 5

tºªñ 9

íI 35

í≈ 5, 35

≈ªñ 9

O 9

µ"¼ 10

SQL Server 7.0

h 102

Σ 13

d 92

¡ dbo í 103

tº≈ªñ∩Θx≈ªñ 8

≈ªñ 9

ΩÑqªñ 9

úP°A 10

Data Protection for SQL d 93

VDI 8

SQL °A

bO⌠ñ⌡µ 11

SQL A 11

sqlauthentication 98, 110

sqlbuffers 110

sqlbuffersize 98, 110

sqlfull.log 122

sqlpassword 110

sqlsched.log 122

sqlserver 98, 111

sqluser 98, 110, 112

SQL-DMOA 14

standby 112

stopat 112

stopatmark 113

stopbeforemark 113

stripes 98, 114

sysadmin Tw°AñΓ 62, 98, 110

Ttdpsqlc ⁿO 46

tdpsqlc.exe 39

tdpsql.cfgA]w

CLI 25, 83, 102

tempdb 10

timeformat 99

Tivoli Storage Manager API 14, 93

Tivoli Storage Manager Server

Σ 14

d 93

tm 17

txngroupmax A≤Ñq 9

Tivoli Storage Manager hD 21

Tivoli Storage Manager 11, 13

Tivoli Storage Manager ≈Osß

Σ 13

a" 10

transact-SQL ⁿO 135

truncate 115

tsmnode 115

tsmoptfile 115

tsmpassword 116

txngroupmax ∩ 9, 17

types

yk 54

í 94

UUnicode ΩT

d 92, 94

WWindows NT/2000 Server

wΣ 13

Windows τíA]w

CLI 98, 110

GUI 26


íX: 5698-APD

SC40-1151-01

Data Protection for Microsoft SQL Server w P...

Documents

Transcript of Data Protection for Microsoft SQL Server w P...