Thursday 7 July 2011

How to determine SQL log file space used

 

dbcc sqlperf(logspace);
exec sp_spaceused

More info here...

http://msdn.microsoft.com/en-us/library/ms189768.aspx

No comments:

Post a Comment

How to find the last interactive logons in Windows using PowerShell

Use the following powershell script to find the last users to login to a box since a given date, in this case the 21st April 2022 at 12pm un...