Data Protection for SQL Server parameters by backup method

You can set different optional parameters for your VSS and legacy data backups.

The following table classifies the optional parameters that apply to VSS and legacy backups.

Table 1. Data Protection for SQL Server optional parameters
Optional Parameters	Legacy	VSS
/ACtive	Yes	Yes
/ADJUSTKBtsmestimate	Yes	No
/ADJUSTPERcenttsmestimate	Yes	No
/ALl	Yes	Yes
/BACKUPDESTination	Yes	Yes
/BACKUPMETHod	Yes	Yes
/BUFFers	Yes	No
/BUFFERSIze	Yes	No
/COMPATibilityinfo	Yes	Yes
/CONFIGfile	Yes	Yes
/DBOonly	Yes	No
/DIFFESTimate	Yes	No
/EXCLUDEDB	Yes	Yes
/FILEInfo	Yes	No
/FIles	Yes	No
/GRoups	Yes	No
/INSTANTRestore	No	Yes
/INTO	Yes	Yes
/LOGESTimate	Yes	No
/LOGFile	Yes	Yes
/LOGPrune	Yes	Yes
/MOUNTWait	Yes	No
/OBJect	Yes	Yes
/OFFLOAD	No	Yes
/OLDerthan	Yes	No
/PARTial	Yes	No
/Quiet	Yes	Yes
/RECOVery	Yes	Yes
/RELOCATEDir	Yes	Yes
/RELocate /TO	Yes	No
/REPlace	Yes	No
/SQLAUTHentication	Yes	Yes
/SQLBUFFers	Yes	No
/SQLBUFFERSIze	Yes	No
/SQLCHECKSum	Yes	No
/SQLPassword	Yes	Yes
/SQLSERVer	Yes	Yes
/SQLUSer	Yes	Yes
/STANDby	Yes	No
/STOPAT	Yes	No
/STOPATMark /AFTER	Yes	No
/STOPBEFOREMark /AFTER	Yes	No
/STRIPes	Yes	No
/TRUNCate	Yes	No
/TSMNODe	Yes	Yes
/TSMOPTFile	Yes	Yes
/TSMPassword	Yes	Yes

With Data Protection for SQL Server, you can back up and restore Microsoft SQL Server databases to Tivoli® Storage Manager server storage by using the command-line interface or GUI.