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

1 Answer 1

4

DBCC SQLPERF(LOGSPACE);

From BOL:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .