After killing a process, if the database goes into transition just see the estimated rollback time by

just running the same KILL statement of that SPID. There you can see the estimated rollback time in seconds

wait till it is done. If you restart the server services,the database will automatically go into suspect mode due to rollback was abruptly stopped.

Here are the steps to bring back a database from a Suspect mode in SQL 2005

First bring the Database into Emergency Mode

then run the DBCC checkdb (if you find any error repair it else)

next alter database and set to single user mode

then set the DB to multi user