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