Doubts about sp_spaceused

Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run sp_spaceused
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1Run:
DBCC UPDATEUSAGE (0)
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"julianohorta via SQLMonster.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run
sp_spaceused
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||Did you run DBCC UPDATEUSAGE command before running sp_spaceused?
"julianohorta via SQLMonster.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
> Hello, All!
> I'm making a maintenance in my DataBases and I have doubts about
> somethings.
> Could you help me?
> One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
> executed Shrink DataBase and my DataBases fell down to 700MB.
> But, When I execute the Stored Procedure sp_spaceused, it comes for
> unallocated space -1050MB.
> What's mean?
> What I need to do to revert it? The other information when I run
> sp_spaceused
> is:
> DataBase
> BDSeg_Bosch
> DataBase size: 700MB
> Unallocated space: -1050MB
> reserved: 1691176 KB
> data: 225336 KB
> index_size: 1442216 KB
> unused: 23624 KB
> Thanks
> Juliano Horta
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1