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

Android mediaserver process killing battery life

If this happens to you, then do the following Force stop on Settings, Applications, All, Media Storage. Clear Cache and Clear Data, fo...