Skip to Content
Former Member
Jun 20, 2011 at 07:54 AM

How to re-use the free space of database


Hi Techies,

One of our BW is running on MSSQL 2005, having 1.5 TB of data splitted into 3 datafiles (In a single drive).

Appl team deleted some data from PSAs to free up the space at DB level, from DB02 its showing DB size as 1.5 T and free space available in database as 200+G.

But when we start loading the data its using harddrive space instead of free space available in database, Now I want to know the best practice to re-assign the free space to OS.

Shrink space is one option to free up the space, but not a recommended one in Production systems, also takes couple of days for such bigger systems and also may not be release space.

Data movement from object to new object is a way, and data migration from datafile to new datafile is a way I found in some of the forums and these are recommended methods supported by SAP as well as MSSQL.

Is thery any faster/online methods other than above?

Thanks in advance

Nick Loy