Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006

    Unanswered: SQL Server SQLMAINT and disk space

    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.

  2. #2
    Join Date
    Nov 2002
    Well what is it you want to do exactly?

    I think I would resolve to get more disk space 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.

    sqlmaint Utility
    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.

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts