Hi
My sql database is showing space available for one of the database is 0.
I have got SQL Server 2005 Ent. Edition(32bit). File growth for .mdf file is set to Autogrowth 10% growth Unrestricted.
I have got lots of physical space on hard drive, why then it is showing 0.00 space available for database. What do i need to do to free up space.
When i ran sp_spaceused it gave me following results
database_name database_size unallocated space
XXXX 1817.31 MB 0.00 MB
reserved data index_size unused
1860760 KB 1763496 KB 13240 KB 84024 KB
I would really appreciate if anyone could tell me what is going on over here and would this slow down the data access?
Regards
Mits
