Monitoring Databases  «Prev 

SQL-Server sqlmaint.exe Syntax

? generates a listing of the parameter
? generates a listing of the parameter
S<Server Name> is the SQL Server to connect to
U<Login ID> is the SQL Server login to use when connecting to the SQL Server
P <Password> indicates the password for the login

Database is the database to maintain
-D <Database Name>
[-Rpt <Output File>] [-To <Operator Name>]
D<Database Name> is the database to maintain
Rpt <Output File> is the full path of the report file
To <Operator Name> is the account to email a report to

CkDB | - CkDBNoldx will run dbcc checked or dbcc checkdb with the no index option
CkDB | - CkDBNoldx will run dbcc checked or dbcc checkdb with the no index option

UpdSts will udpate the statistics
UpdSts will udpate the statistics on every table, index and statistic group in the database.

BkUpDB Path will back up the database
BkUpDB <Backup Path> backs up the database.
BkUpLog <Backup Path> backs up the transaction log.

UpdOptiStats </% of Database to Sample>
UpdOptiStats <% of Database to Sample> allows you to specify how much of the database to sample when generating statistics.

PlanId < GUID
PlanId < GUID identifying the maintenance plan ... allows you to specify an existing database maintenance plan. The only thing from the plan that will be used is the list of database.

CrBkSubdir creates a directory
CrBkSubdir creates a sub-directory for storing the backup files.

? generates a list of the parameter
? generates a list of the parameter.
S <Server Name> is the SQL Server to connect to.