Hi,

It is still there in Shrink File .I use 2008 R2.

Thanks!! works in my case as i have a lot initially allocated space which was never touched.

thanks for your reply.I know it is not recommended as it will cause fragmentation of indexes but i need to free up some space.

As per http://msdn.microsoft.com/en-us//library/ms189493.aspx

the TruncateOnly clause...

IF u don't wish to connect the two databases BCP in/out will be a good solution for you.Perform a BCP out operation on the source and get the data on...