The image below says it all. I need to get some data out of a back-up that's two weeks old, so I restored to a new db called ETLFix. However, when I started the restore my production DB, ETL went into restore as well.
I suspect this because I restored ETLFix from a two week old .bak and an notification went off saying that the back-up chain is broken for ETL. Another way to say it is, ELT thinks it's in restore because it learned an old .bak was read.
How to I get my ETL production db out of restore, and keep this from happening in the future?