Release the allocated space in sql server 2000 database

• tilakat

  Grasshopper

  Points: 17

  More actions

  May 11, 2009 at 1:11 am

  #71516

  Hi,

  Can anyone help me out in releasing the unused space of the MDF file in SQL Server 2000 database.

  Database Server: Sql Server 2000

  Requirement : Need to release the unused space of the MDF file in a database.

  Please let me what actions need to be performed.

  Thanks

  Regards

  Thilak

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  May 11, 2009 at 1:22 am

  #991925

  Hi,

  Shrinking files might help you here.

  http://msdn.microsoft.com/en-us/library/ms190757.aspx

  [font="Verdana"]Renuka__[/font]