| Info |
|---|
Explains how to move your Crows Nest SQL database to a new server |
...
. Topics include:
|
SQL Server Management Studio for this example.
If you do not have it installed or need help settings up SSMS, refer to: SQL Server 2019.
You can also follow these instructions if you prefer to backup your Crows Nest database via SSMS.(SSMS) is used in this explanation.
...
Back up an SQL database
Launch SQL Server Management Studio in Windows.
...
Now that you've migrated the database, skip down to Update Crows Nest Database.
...
Restore a separate instance of an SQL database
In the event that your backup fails to restore properly, a database is corrupted, or the database has missing data, you can attempt restore a separate instance of your SQL database and combine data.
...
You've now restored a separate instance of your database.
...
Update Crows Nest
...
database
Finally, once you've finished with the SSMS, you'll need to update the database in the Crows Nest Database Utility. Launch Crows Nest Database Utility and click Update Database. Once the update is complete, you can close the Utility.
...