• try this

    dbcc opentran database

    go

    kill spid

    go

    alter database database set recovery simple

    go

    checkpoint

    go

    alter database database set recovery full

    go

    backup database pubs to disk = 'c:\database.bak' with init

    go

    dbcc shrinkfile (N'database_log' , 1)

    go