As we are in the process of implementing 10, our non production environments are using report databases that should be backed up. I notice that when a report database is created, it actually creates 4 files. Do I need to back up these 4 files to successfully restore the report database for a test environment?
Well, I feel silly. In SSMS, I simply created a sql script to backup the database. I was just more curious as to why 4 files are created for reporting.