Currently we have a reporting database that is created from a full backup of our production database and restored to a separte SQL instance. Now the business is wanting to archive data out of production but maintain the archived data in the reporting database. So I am looking for recommendations on how to perform this task.
Does anyone maintain a separate reporting database? Does CA have any tools/applications to do this?