Still this is in same state .....KILLED/ROLLBACK status

OK Tahnk you. Will update the situation ....

DBCC CheckDB (DBName , REPAIR_ALLOW_DATA_LOSS) .......

And event type is Language Event

Last wattype is LOGMGR ...

Thank you for replay

It's stil showing same. last four hours this is in same situation......

Thank you all....

Thank you for the link. Like User DB's waht is the best practise in chosing this autogrouth value . Ex: Fo 60 Gb Db with one .mdf, .ndf, 4 .ndf's......

Actaully, this package is for updating few objectes in 'B' server from 'A ' . Here I don't understand one thing, i.e package is sitting and running from and scheduled...

Thank you very much.....It's very help full.....

Thank you for the reply. But here we are not deleteing existed records in UNMATCH table.

[For example, today we got 3 records into Unmatch obkect and tomorrow may be 6...