DB Space

I have an MSDE database that has reached 1880.06 MB and the Tlog is about 1MB. It shows 0 space left on the DB. What can I do to get some more space? Would shrinking the DB accoplish the goal?
Thanks
What is 1880 MB, the MDF file? What does sp_spaceused look like?
http://www.aspfaq.com/
(Reverse address to reply.)
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:7957D013-1F3E-43D5-B28A-CF6FDBE1A455@.microsoft.com...
>I have an MSDE database that has reached 1880.06 MB and the Tlog is about
>1MB. It shows 0 space left on the DB. What can I do to get some more
>space? Would shrinking the DB accoplish the goal?
> Thanks
|||Hi,
Can you execute the below command to ghet the actual database size.
use dbname
go
sp_spaceused @.updateusage='true'
-- Execute the above command when database have very less access. Because
the above command internally
execute DBCC UPDATEUSAGE on all the tables in the database with Shared
locks.
Thanks
Hari
MCDBA
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:7957D013-1F3E-43D5-B28A-CF6FDBE1A455@.microsoft.com...
> I have an MSDE database that has reached 1880.06 MB and the Tlog is about
1MB. It shows 0 space left on the DB. What can I do to get some more
space? Would shrinking the DB accoplish the goal?
> Thanks
|||These are the results
Database_size = 1881.06 MB
Unallocated space = 0.07 MB
Reserved 1925112 KB
Data 1023400 KB
Index_size 8192 KB
Unused 893520 KB
Does the last one mean that I still have about 8 MB of free space?
Thanks for your help
"Hari Prasad" wrote:

> Hi,
> Can you execute the below command to ghet the actual database size.
> use dbname
> go
> sp_spaceused @.updateusage='true'
> -- Execute the above command when database have very less access. Because
> the above command internally
> execute DBCC UPDATEUSAGE on all the tables in the database with Shared
> locks.
>
> --
> Thanks
> Hari
> MCDBA
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:7957D013-1F3E-43D5-B28A-CF6FDBE1A455@.microsoft.com...
> 1MB. It shows 0 space left on the DB. What can I do to get some more
> space? Would shrinking the DB accoplish the goal?
>
>
|||Looks like ~900 MB to me.
Where did you see "It shows 0 space left on the DB"?
http://www.aspfaq.com/
(Reverse address to reply.)
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:98FD70CA-9DBA-4D4C-915B-C3EBAEDA731E@.microsoft.com...[vbcol=seagreen]
> These are the results
> Database_size = 1881.06 MB
> Unallocated space = 0.07 MB
> Reserved 1925112 KB
> Data 1023400 KB
> Index_size 8192 KB
> Unused 893520 KB
> Does the last one mean that I still have about 8 MB of free space?
> Thanks for your help
> "Hari Prasad" wrote:
Because[vbcol=seagreen]
about[vbcol=seagreen]
|||on the taskpad view in EM. How do I retrieve the 900 MB?
Thanks
"Aaron [SQL Server MVP]" wrote:

> Looks like ~900 MB to me.
> Where did you see "It shows 0 space left on the DB"?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:98FD70CA-9DBA-4D4C-915B-C3EBAEDA731E@.microsoft.com...
> Because
> about
>
>
|||> on the taskpad view in EM.
Stop doing that. Use sp_spaceused in Query Analyzer, then you can tell it
to update statistics as well (giving you an accurate result), which EM will
never do.

> How do I retrieve the 900 MB?
First, you need to realize why there is 900 mb of free space in the data
file. Did you have a huge table and delete it? Has this database been
around for 20 years and never been defragged or reindexed? Or is it this
large due to normal volume (maybe you have huge bulk inserts and then trim
the data down constantly)? In many cases, getting the 900 mb will not be a
good decision because (a) the database will likely need to grow again, and
(b) when it does, your application will feel the performance hit. See these
articles for some information:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
http://www.aspfaq.com/2446
http://www.aspfaq.com/2471
http://www.aspfaq.com/
(Reverse address to reply.)