Do you need to find out where the location of your SQL Server's database is? Here's a quick tip. Written by Arthur Fuller, Contributor March 4, 2004 at 12:45 a.m. PT ...

If this option is blank, double-check to make sure you have installed the Reporting Service on your SCOM server, not on your SQL Server. Figure 8: Choose your Reporting Service instance.

I would look into PITR (continuous archiving which allows point-in-time-recovery [i.e. restore the database as of yesterday 13:45, SQL Server surely has an equivalent]).