• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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