Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: SQL
Expertise: Advanced
Nov 9, 2004



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Generate HTML Reports from Scheduled SQL Server Maintenance Activities

A gem in the arsenal of command-line utilities that comes with SQL Server is the SQLMAINT application. With it, you can run a variety of maintenance activities, including DBCC checks, backup and restore, statistics updates, and more.

But here's the best part. By passing an -HtmlRpt switch to the utility, it can automatically generate a user-friendly, Web-based report of its activities. You can use the Windows Task Scheduler to schedule a regular maintenance process, generating this report file, and you'll never have to wonder exactly what the utility did or didn't do. For instance, the following command-line would perform DBCC checks on the local Northwind database, reporting its results as Nwind_chk.html. Adjust the location of this file to suit your needs:

sqlmaint -S "(local)" -U "sa" -P "saPwd" -D Northwind -CkDB
-CkAl -CkCat -HtmlRpt C:\Nwind_chk.html
Note: Remember to ensure that the command outputs an HTML file *in a secure location." Otherwise, malicious users could use the report to gain knowledge about the structure and data in your database.

Parthasarathy Mandayam
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date