Any SQL nerds on here? On our production SQL server we have 4 SSRS .mdf files for each Epicor database on the SQL instance. Do we need these, or can we get rid of them? If they are used, what are they used for?
What you’re seeing is the SSRS catalog.
I would not decommission these as they hold all of the report definitions, folders, data sources and subscriptions for that environment, along with a temp database used when reports are running. They are required for SSRS to function, so only remove them if the environment has been fully retired.
I’m no DBA, so others may have additional insight, but that’s my take on it.
4 Likes
Thank you for the answer.