-
Title
How to access Help function for SQL LiteSpeed SQL Maintenance Plans (SLSSQLMAINT) -
Description
How to access Help function for SQL LiteSpeed SQL Maintenance Plans (SLSSQLMAINT) -
Cause
New functionality in Version 4.8 -
Resolution
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>slssqlmaint -?
USAGE: [-?] | [-S <Server Name>]
[-U <Login ID> [-P <Password>]]
-D <Database Name>
[-Rpt <Output File>]
[-To <Operator Name>]
[-CkDB | -CkDBNoIdx] Checks and find problems with the data if the maintenance plan fails
[-CkAl | -CkAlNoIdx] Checks and find problems with the data if the maintenance plan fails
[-CkCat] Checks and find problems with the data if the maintenance plan fails
[-RebldIdx <% Free Space>]
[-BkUpDB <Backup Path> | -BkUpLog <Backup Path>] Log backups
[-BkUpOnlyIfClean] Specifies that the backup occurs only if any specified -Ck checks did not find problems with the data
[-BkUpMedia DISK [-DelBkUps <time period>] | TAPE]
[-UpdOptiStats <% of Database to sample>]
[-HtmlRpt <Html File>]
[-VrfyBackup] Specifies that RESTORE VERIFYONLY is run on the backup when it completes
[-RmUnusedSpace <Minimum DB in MB> <% of free space to leave>]
[-PlanID <GUID identifying the maintenance plan in 36 characterhex format>]
-PlanName <Maintenance plan name>]
[-CrBkSubDir] Create a sub-directory (for storing backup files) for the database(s).
[-UseDefDir] Use the default backup directory.
[-WriteHistory] Write history to msdb.dbo.sysdbmaintplan_history.
[-DelTxtRpt <time period>] Delete text reports older than given time period
[-DelHtmlRpt <time period>] Delete html reports older than given time period
[-MAINTDEL]
[-CKDBREPAIR] Check Data and Index Linkage with fast repairs
[-BKEXT <Backup Extension>]
[-COMMENT <A comment to add>]
[-JOB <key to encryption key in registry>]
[-ENCRYPTIONKEY <Encryption key>]
[-CRYPTLEVEL <Encryption Level>][-PRIORITY <Priority>]
[-THREADS <Number of threads>]
[-LOGGING <Logging level>]
[-THROTTLE <Throttle level>]
[-COMPRESSIONLEVEL <Compression Level>]
[-AFFINITY <Affinity Level>]
[-NOOPTOLR] Don't optimize Object Level Recovery
[-OPTOLR] Do optimize Object Level Recovery]
[-MAXTRANSFERSIZE <Maximum buffer size>]
[-BUFFERCOUNT <Buffer count>]
[-DIFFERENTIAL] Differential backupsC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\slssqlmaint.exe Process
Exit Code: 0 (Success) -
Defect ID
CR0196214