It is sometimes necessary for us to access a 'backup' of the Troika SQL database for investigation purposes.
Backing up the Troika SQL Database
These operations should be carried out by your database administrator (DBA). Please ensure you have up-to-date and verified backups before attempting to run any operations on your server. These notes are intended for guidance only and should not be relied on. Always seek advice from your DBA befor completing any work on SQL Server.
You can either get last night's backup , or if it's something more recent required, you may be asked to do a manual one. Do x y and z.
Anonymising the SQL Database Backup
Whilst some organisations are happy to share this with us, in line with our confidentiality clauses whatsits, some would prefer the information anonymised before sending.
Perfecly acceptable.
Once a SQL backup of the database has been taken (as outlined above) the following additional steps should now be taken:
- Restore that SQL backup as a new SQL database. Ensure it is re-named to something which clearly relates to it being temporary and/or for testing purposes.
- Run the attached Anonymise.sql SQL script against the new SQL database.
- Backup the new SQL database.
- Compress the SQL database backup file into a compressed zip file, if required.
- Send the file to support (request a Sharefile link if required, due to size limitations on email).
Any questions, please contact support.