Richard Teachout - My technobabble Blog - SQL:Determine MSSQL Database + DBLog Used + Allocated Size

KeywordsPhrase

Here are the most recent postings to this blog. Use the archive calendar or search to find other entries.

SQL:Determine MSSQL Database + DBLog Used + Allocated Size

Nov18

Written by:R Teachout
11/18/2006 8:23 PM

Ever wondered what is still available & whether or not you needed to dump your log to make space?

use your_db_name;
select name, size/128 as physicalsize, maxsize/128 as maxallowed from sysfiles;
 
 
Voila.. that's it!  Easy!

Location: Blogs

Tags:

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:

Security Code Enter the code shown above in the box below
Add Comment Cancel

Never trust a computer you can't throw out a window.
-Steve Wozniak