newbie question : negative unallocated space

What is the significance of having - (negative) unallocated space?
I have a database which has 5 database files.
db1_data.mdf space allocated = 100 MB
db1_1_data.ndf space allocated =7.5 GB
db1_2_data.ndf space allocated =7.5 GB
db1_3_data.ndf space allocated =7.5 GB
db1_4_data.ndf space allocated =7.5 GB
Transaction Log space allocated is 7.065 GB
Ent Manager shows size is 37164.45 MB and available space = 2484.77 MB
sp_spaceused result :
unallocated space = -4350.21 MB
reserved = 35277016 KB data = 18001184 KB index size = 6677840 KB unused = 10597992 KB
Thanks,I run dbcc updateusage and sp_spaceused and got the correct info.
Thanks,
"winnetka" <winnetka@.netscape.net> wrote in message
news:46Ibd.7787$jo2.5300@.twister.socal.rr.com...
> What is the significance of having - (negative) unallocated space?
> I have a database which has 5 database files.
> db1_data.mdf space allocated = 100 MB
> db1_1_data.ndf space allocated =7.5 GB
> db1_2_data.ndf space allocated =7.5 GB
> db1_3_data.ndf space allocated =7.5 GB
> db1_4_data.ndf space allocated =7.5 GB
> Transaction Log space allocated is 7.065 GB
> Ent Manager shows size is 37164.45 MB and available space = 2484.77 MB
> sp_spaceused result :
> unallocated space = -4350.21 MB
> reserved = 35277016 KB data = 18001184 KB index size = 6677840 KB unused
=> 10597992 KB
> Thanks,
>
>
>|||This is because the information about sizes are estimates which are kept up
to date periodically... Running dbcc updateusage or sp_spaceused
@.updateusage=true will force SQL to re-evaluate and update the values.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"winnetka" <winnetka@.netscape.net> wrote in message
news:46Ibd.7787$jo2.5300@.twister.socal.rr.com...
> What is the significance of having - (negative) unallocated space?
> I have a database which has 5 database files.
> db1_data.mdf space allocated = 100 MB
> db1_1_data.ndf space allocated =7.5 GB
> db1_2_data.ndf space allocated =7.5 GB
> db1_3_data.ndf space allocated =7.5 GB
> db1_4_data.ndf space allocated =7.5 GB
> Transaction Log space allocated is 7.065 GB
> Ent Manager shows size is 37164.45 MB and available space = 2484.77 MB
> sp_spaceused result :
> unallocated space = -4350.21 MB
> reserved = 35277016 KB data = 18001184 KB index size = 6677840 KB unused
=> 10597992 KB
> Thanks,
>
>
>sql