Just a note, one day I must spend a lot more time reviewing the details around transaction logging and restore for production databases. The fact that i generally work on marketing systems where the server tends to be more for experimentation means I’m usually really lax on organising the setup. With that in mind, there are always a couple of business critical elements that need to be resolved, all of which become a priority when things start to go a bit sideways.
which i stole from this thread http://www.sqlservercentral.com/Forums/Topic650142-357-1.aspx
Seems to be a good place to start. In future, setting to Simple when relying on a restore without the need to roll back transactions should also be a good idea….