Post reply

Truncating Files and Monitor Space Usage

  • February 24, 2004 at 12:03 pm

    #101891

    What are some basic commands to truncate the log file and monitor the log file size? For example, is the BACKUP LOG MyNwind Truncate_Only and BACKUP LOG MyNwind NO_LOG good commands to use to truncate the transaction logs (inactive part) without backing up the logs? Do these commands do the same thing? I am trying to save space.

    Also, what are some good DBCC commands to use to truncate space or save space on the .mdf and .ldf files? What are some DBCC commands to use to monitor space usage?

    Thanks in advance,

    Kevin

  • February 24, 2004 at 12:12 pm

    #495400

    It removes the inactive part of the log without making a backup copy of it and truncates the log. NO_LOG and TRUNCATE_ONLY are synonyms.

    DBCC SQLERF(LOGSPACE) tells the log spaces being used.

    DBCC SHRINKFILE is used to shrink MDF/LDF files.

    sp_spaceused gives you database spaces usage information.

     

  • February 24, 2004 at 2:30 pm

    #495417

    http://qa.sqlservercentral.com/scripts/contributions/390.asp

     

    My favorite way to monitor my files


    "Keep Your Stick On the Ice" ..Red Green

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply