How to Backup The RandRevit Database

The RandRevit database is the core of everything in Clarity, including projects, tasks, and more.
There is an option in the Clarity Server Settings to automatically backup the RandRevit database weekly to the backup location specified in settings.

image-1758029726802.png

Why you might need to backup the database

  • You need to make changes to the database
  • You need to send it to development to look over
  • Disaster recovery
  • Server migration

What you will need:

  • Remote Access to the machine where the database lives (typically the same as your Clarity Host).
  • Be able to sign in with your Clarity Service account (or perhaps the user which did the original installation of the software – to ensure that you have permissions to the database).

How to Backup the Database

  • Remote Desktop into the server where the SQL Database is installed, ideally using the service account used for Clarity (or the userID that installed it).
  • On the Start Menu, look for “Microsoft SQL Server Management Studio” and run it.

    • image-1758029567240.png

  • If prompted for the server name (shown below) – try putting in (local), or (local)\SQLEXPRESS if you use the Clarity installed instance of SQL
  • If you log onto the machine as the app pool identity you should be able to use windows authentication.
  • If you can’t connect with the Windows login you can switch to SQL Server Authentication and log in with the raas credentials.
  • Expand Databases
  • Right Click on RandRevit
    • Tasks
      • Backup
    • In the Backup Database dialog verify the settings
    • Select Add to add the backup location
    • Browse to a location to save the backup and give it a name and ok out of all dialogs to save the backup with a .bak extension.
      • It is recommended that it be saved somewhere locally, but outside of the Microsoft SQL Server folders
      • You could save it into the Backups folder defined in Settings in Clarity on the Server tab, Settings page under File Locations for Backups Location.
    • Ok to backup
    • When the backup completes you will see the following dialog
It is recommended to keep an up to date backup.
Follow
Was this article helpful?
0 out of 0 found this helpful
Reply