I am using FSM with a SQL database and wish to produce a new Test DB from my existing PROD DB. I have tried restoring a backup of the Prod DB to the test DB and this doesn't work as it says DB not available. I have tried doing and export from the Prod DB to the Test DB but I get an error about writing to a read only table.
Does anyone have any advice?