How to add more space in Unallocated space?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  February 2, 2010 at 4:23 am

  #98981

  sp_spaceused return values after running dbcc updateusage. here i am think space issue in database.

  database_size 289785.75 MB

  Unallocated space 14.95 MB

  reserved 296723256 KB

  data 296018168 KB

  Index_size 498632 KB

  Unused 206456 KB

  Recovery model - simple.

  I want add some more space in Unallocated space in database. Please reply me, how to add more space? HD free space 376 GB. total 653 GB.

  thanks for advance - SQLDBAs

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  February 2, 2010 at 6:05 am

  #1112215

  http://msdn.microsoft.com/en-us/library/aa197143(SQL.80).aspx