Thanks for the suggestions!!

The shrink I am doing is to cleanup an application issue which made a normal size of 10GB database unexpected growth to 70GB. The app admin...

Thank you for your input!

Yes, I ran this shrink within a live database, so it is in sleeping status in most of the time - (blocked by other processes?).  I terminated this process after it ran...

Thanks!!

And continue another quesiotn:

If using shrink option of 'Shrink file to' a specified number on EM, Do I need to set a restrict acess mode (signle mode) on this database to not...

Thanks all for the inputs. I really appreciate your helps.

So SQL server does have killed/rollback type of status. I do not understand why my killed process was still showed as 'sleeping' status,...

yes, I saw the command this process was running, but my quesiton is after this process is KILLed from EM without any error, why this process is still showing on...

Thanks for the help. If the killed process is still showed in EM, I guess one possible way may be the process is doing 'rollback'.

Is there any way from SQL server...

Tom,

Another qusiton, when terminate this shrink datafile process, is there any 'rollback' time ?

Diana

Tom,

Thanks for your quick response!

Diana