Hi,
You can switch partitions if your idea allows this or TRANSFER the partition to other. PLease follow the following url for more details.
http://msdn.microsoft.com/en-us/library/ms142159.aspx
http://msdn.microsoft.com/en-us/library/ms191160(v=sql.105).aspx
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”