good question, caught me out!

Indeed, since it's a test box we don't tend to bother however in our live we have a robust backup strategy. Best to find out this way around than have...

genius, that's the ticket.

I'm afraid that also doesn't remove these files from view in sys.master_files - still listed as OFFLINE, I've also done a restart of the SQL service on both boxes (since...

I've annoyingly bumped into the same issue recently on a production server whereby it seems to ignore that particular setting in the ReportingServicesService.exe.config, I went to test on another non-production...

You'll need to remove it from sysadmin then as this will override any deny given on the DB, you'll need to correctly map the login and find out the requirements...

Good stuff Chris, nice question.

Learn something new every day, interesting to know since I'll be using it soon!

Good call, managed to research it and find the answer but still worth knowing!