When restoring from LiteSpeed, RMSP is connecting to a different Farm's SQL server
説明
Recovery Manager for SharePoint is connected to both a 2007 and 2010 Farm using LiteSpeed backups. When doing a SQL trace while attempting to add/load a 2010 LiteSpeed backup into RMSP, it seems that the Service Account is logging into the 2007 Farm's DB server.
原因
When you add a LiteSpeed backup using the "Add backups" (not autodiscovery), the backup is considered as unknown for SharePoint Farms. The SQL server used to process the backup will be the SQL server that the RMSP 'QMC_Repository' database is located on. From a view of generated logs, that is the 2007 Farm's SQL server.