Home Forums SQL Server 2005 Administering How to kill Rollback process RE: How to kill Rollback process

  • September 23, 2014 at 9:53 pm

    #1747709

    Gedas (10/8/2010)

    You can kill rollback only by doing that but you must have latest backup:

    1. stop SQL engine

    2. delete db and tlog files

    3. start SQL engine

    4. delete db

    5. restore db

    Thanks. This also is handy when you are prototyping large schema or data migrations and underestimate resource requirements. Sometimes the big sledgehammer is needed and start from a fresh backup!