Overview
Warning
Please note that MS SQL database used with a hosted Birdview account has the latest MS SQL Server format.
This means that restoring of a Birdview database from your hosted account must be made on the latest MS SQL Server version.
Make sure you are running the latest MS SQL Server version first, and if not, please upgrade your SQL server or install at least the latest version of the free MS SQL Server Express edition.
There are two possible methods to run data from our server on your self-hosted setup:
- Method 1. You have already set up Birdview on your server to make sure it runs properly, and you need to replace the test database created during the setup with the database of your hosted account data you received from us.
- Method 2. You have not, yet, set up Birdview on your server and therefore do not have an existing Birdview database on your SQL Server.
In both cases, you will need to run the Birdview installation to make sure that you are running the latest version of Birdview and that the database you received from us is working with the latest files set up by the installation.
Method 1
The steps are below, but a quick overview is that you will delete the existing test Birdview database and restore the database sent to you. Then re-run the installation to make sure everything hooks up, ok.
Open the MS SQL Server Management Studio, and expand the Databases tree to see your database(s). Make a note of the database name created during the initial setup of Birdview, and then in order to delete an existing database, scroll down to your test Birdview database, right-click on it, and choose Delete.
In order to restore a database received from us, scroll up to the top of the Databases tree, right click on Databases, and select Restore database.
- Give a name to the database being restored (a new name or the same name as for the database you have just deleted).
- Browse for a path where the backup file of the database is located.
- Press Add to select the path.
- Expand the files tree to find your database backup file.
- Once the database file is found, press OK.
- Press OK again.
- Mark Database component and leave Transaction log unmarked.
- Press OK to proceed.
Now you can check whether your database was successfully restored.
- Run the Birdview installation in the "upgrade" mode and point it to the restored database.
- Finish the installation and check if your Birdview site loads ok.
Method 2
- Restore the Birdview database from the backup, as described above.
- Run the Birdview installation and point it to the restored database.
- Finish the installation and check if your Birdview site loads ok.