Great idea now puts the result of the query log table and the game is done. Too bad they can not know who cleaned the db yesterday.

Thank you for...

Thanks for your answers. The problem is to understand which user has launched a stored that was cleaning the db.

Thanks

Try this

http://blogs.technet.com/askcore/archive/2009/04/28/recovery-of-a-mirrored-sql-database.aspx

Hello Venu

for the second answer when you restoring the db in PROD you can change the name of the db in the combo that appear in the restore window.

For...