database size

Dear all
I have a SQL abc database. Recently, I right click database properity,the
space avaliable is zero, but i see the database file size and transcation log
has some free space. Why the space avaliable is zero in that case and have
any impact about this database?
thanks
Verify that your database has the 'Automatic grow file' property checked in
both your data and transaction log files.
If it is not enabled, you have some choices, like expanding the size of your
files manually, or enabling automatic grow file. Perhaps you want to go with
the default of 10 percent.
Ben Nevarez, MCDBA, OCP
"123" <123@.discussions.microsoft.com> wrote in message
news:518D80E7-98FF-4729-9BB4-A6DA6ACFAD90@.microsoft.com...
> Dear all
> I have a SQL abc database. Recently, I right click database properity,the
> space avaliable is zero, but i see the database file size and transcation
> log
> has some free space. Why the space avaliable is zero in that case and have
> any impact about this database?
> thanks
>
|||Check the fragmentation of your tables. If you haven't already it may be
best to set up a database maintenance plan to reorganise your data and index
pages. The frequency you do this depends on the workload of your server.
"123" wrote:

> Dear all
> I have a SQL abc database. Recently, I right click database properity,the
> space avaliable is zero, but i see the database file size and transcation log
> has some free space. Why the space avaliable is zero in that case and have
> any impact about this database?
> thanks
>