2

I need to see how much space my log file has.

What permissions need to be granted to do so?

What script shall I run to see that?

Thank you

Boppity Bop
  • 752
  • 3
  • 11
  • 34

1 Answers1

4

DBCC SQLPERF(LOGSPACE);

From BOL:

To run DBCC SQLPERF(LOGSPACE) requires VIEW SERVER STATE permission on the server.

SqlACID
  • 2,176
  • 18
  • 18