SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 database space analysis
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

79 Posts

Posted - 03/26/2013 :  10:36:13  Show Profile

Select fileid,groupid,size,maxsize,growth,name,filename
from dbo.sysfiles :-
fileid groupid size maxsize growth name filename
1 1 1966080 6236160 64000 DB_VIEWS Data.MDF
2 0 655360 1310720 131072 DB_VIEWS Log.LDF

Sp_Spaceused :-database_name database_size unallocated space
DB_NAME 20480.00 MB 1901.50 MB

reserved data index_size unused
13781504 KB 9183168 KB 4593976 KB 4360 KB

I don’t know how to correlate theses two sources of information
I just need to find out what is my total database size, how much has been occupied and how much is the free space available

Most Valuable Yak

15730 Posts

Posted - 03/26/2013 :  10:53:29  Show Profile  Visit robvolk's Homepage
Please do not cross post:

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000