I am inserting a record in a table ,
Updating another related table if the insertion was successful
Other wise roll back the transaction
What is the best isolation level to use? I want to have the best performance.
Concerning restoring my database If I did full backup will I loose anything.
Concerning restoring my database if i did partial backup what i should do so as not to loose anything