• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

MS SQL Log

Hello Experts,

It is to my understanding that when you archive logs that the space the it tooks is then freed to allow additional logging to the log file.  How does one verifies the percentage of available space on a log file?


As always thank you, for your time on this matter.
0
coperator
Asked:
coperator
1 Solution
 
macentrapCommented:
In query Analyser
run this command

'dbcc sqlperf(logspace)'
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
also you can run sp_HelpDb , sp_HelpFile
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now