Enterprise manager reporting Free Space

I 'm running sql server 2k, with service pak3a, Win2k with lastest service
pak. We have a database that shows as being 9gig, with 0.00 MB free when
looking at the properties of it in Enterprise manager. The hdisk where that
database resides has 45gig free, with no disk quotes. Also, the database is
set to auto grow by 10%, both the tran log and data file. I have no idea why
it's not seeing more the 0.00mb free...any thoughts or ideas would be
greatly appreciated..
-BobThat reports the space free in the MDF file, not on the drive.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> pak. We have a database that shows as being 9gig, with 0.00 MB free when
> looking at the properties of it in Enterprise manager. The hdisk where
that
> database resides has 45gig free, with no disk quotes. Also, the database
is
> set to auto grow by 10%, both the tran log and data file. I have no idea
why
> it's not seeing more the 0.00mb free...any thoughts or ideas would be
> greatly appreciated..
> -Bob|||how can I increase that space...do i need to?
"Aaron [SQL Server MVP]" wrote:
> That reports the space free in the MDF file, not on the drive.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> > I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> > pak. We have a database that shows as being 9gig, with 0.00 MB free when
> > looking at the properties of it in Enterprise manager. The hdisk where
> that
> > database resides has 45gig free, with no disk quotes. Also, the database
> is
> > set to auto grow by 10%, both the tran log and data file. I have no idea
> why
> > it's not seeing more the 0.00mb free...any thoughts or ideas would be
> > greatly appreciated..
> >
> > -Bob
>
>|||If you have it set to autogrow, it will increase the space when it needs to.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:8C9B48B3-4737-4A2C-A21F-A7A9095154DC@.microsoft.com...
> how can I increase that space...do i need to?
> "Aaron [SQL Server MVP]" wrote:
> > That reports the space free in the MDF file, not on the drive.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> > news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> > > I 'm running sql server 2k, with service pak3a, Win2k with lastest
service
> > > pak. We have a database that shows as being 9gig, with 0.00 MB free
when
> > > looking at the properties of it in Enterprise manager. The hdisk where
> > that
> > > database resides has 45gig free, with no disk quotes. Also, the
database
> > is
> > > set to auto grow by 10%, both the tran log and data file. I have no
idea
> > why
> > > it's not seeing more the 0.00mb free...any thoughts or ideas would be
> > > greatly appreciated..
> > >
> > > -Bob
> >
> >
> >