On a SQL Server 2008 R2 instance, a misconfigured credential used as a SSIS proxy for an SSA job was dropped before I could look at the system views to figure out when it was originally misconfigured.
I restored a backup of the
master DB under an alternate user DB name to see if I can extract the data but it appears the
sys.credentials view is looking at the live
master DB instead of the restored DB even with the DB context set to the restored DB.
Is there an alternate method to retrieve the data from this and other system views from a backup without the usual DR methodology?