I have a 250 GB database and not much space left on the disk drive. I want to run SQLMAINT to do optimization and integrity checks on this db. My question is : How much work space does SQLMAINT need to perform these tasks?.
Thanks in advance for your help.
I think I would resolve to get more disk space first....how much free space is left and how big is the data files and the tranny log(s)?
If I were you, I would do alot mmore reading in books online and/or grab some admin books. SQLMAINT can do a bunch of stuff.
The sqlmaint utility performs a specified set of maintenance operations on one or more databases. Use sqlmaint to run DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes. All database maintenance activities generate a report that can be sent to a designated text file, HTML file, or e-mail account.