Home / server / Questions / 237325
Accepted
Boppity Bop
Asked: 2011-02-19 08:09:01 +0800 CST

SQL 2008. What permissions needed to see log file free space?

  • 772

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

sql-server sql-server-2005 sql-server-2008

1 Answers

  1. Best Answer

    DBCC SQLPERF(LOGSPACE);

    From BOL:

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

    • 4