Our Hosted help desk stores all your data and all the backups on our servers hosted by Amazon, with additional backups stored on Amazon S3. But we can also set up an extra backup-file that you will be able to download via FTP. You can save this backup on your own server, say, for later use with the "self-hosted" on-premise version of the helpdesk app. Or - to build complex reports, perform some analysis using SQL queries or just to feel more secure since you have an extra backup copy of all your data.
We provide you with a username & password to access our FTP-server, where you can download your backup, which we update with the new data daily or weekly. Due to maintenance costs which apply to this service we offer it as part of the "Company" plan or higher (or as a paid add-on for other pricing plans) and you should send an email to our support to enable it.
Once we receive your request our engeneers will set up an automated publishing job, that will back up the database - with all your tickets, replies, user accounts, Knowledge-base posts, tags, categories, everything - and place it on an FTP server.
The file is a standard SQL Server database backup file ("zipped" to save storage size) that you can restore on your side. To restore a database launch SQL Server Management Studio, connect to your SQL Server instance, right-click "Databases" (or optionally right-click an existing database - "all tasks"), then select "restore database" - on the "General" tab set "source" to the downloaded backup file and proceed.
Note that you may need the latest version of SQL Server 2016 (any edition) to restore our backup.
Last updated: 12/27/2018 more SaaS Help Desk whitepapers