October 30, 2007 at 8:16 am
Hi all
I have an urgent issue. I've started the shrink file with shrink action "Empty file by migrating the data to other files in the same filegroup". The datafile is a 40GB file an must be migrated to 7 different new files. Now it is running 14 hours and in every file has about 2GB of data migrated. I can't let it run anymore. I have to stop it. But is it safe, if I kill the job? Do I will have data loss?
thx
mirco
October 30, 2007 at 8:54 am
I'm assuming your running this via the UI which in turn is issuing a DBCC SHRINKFILE (file, EMPTYFILE). You can do a DBCC INPUTBUFFER on the SPID in question to confirm this. If in fact this is the case, you should be save to issue a kill on the offending SPID.
Tommy
Follow @sqlscribeOctober 30, 2007 at 9:17 am
Hi tommyB
Thank you for your reply. Yes I did it with UI.
With the DBCC INPUTBUFFER on the SPID, the task will stop or rollback? If it stops, will be the migrated datas stored in the new datafiles?
THX mirco
October 30, 2007 at 9:27 am
To the best of my knowledge it works a a series of small system transactions so there really is nothing to rollback. You will have to start over however 🙂
Tommy
Follow @sqlscribeOctober 30, 2007 at 9:46 am
Thx for your answer. I will try it.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply