Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2013-03-26 : 10:36:13
|
| Select fileid,groupid,size,maxsize,growth,name,filenamefrom dbo.sysfiles :-fileid groupid size maxsize growth name filename1 1 1966080 6236160 64000 DB_VIEWS Data.MDF2 0 655360 1310720 131072 DB_VIEWS Log.LDFSp_Spaceused :-database_name database_size unallocated spaceDB_NAME 20480.00 MB 1901.50 MBreserved data index_size unused13781504 KB 9183168 KB 4593976 KB 4360 KBI don’t know how to correlate theses two sources of informationI just need to find out what is my total database size, how much has been occupied and how much is the free space available |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2013-03-26 : 10:53:29
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=184056 |
 |
|
|
|
|
|
database space analysis