Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

Explains how to move your Crows Nest SQL database to a new server. Topics include:

  • Backup an SQL database

  • Restore an SQL database from backup

  • Restore a separate instance of an SQL database

  • Update Crows Nest database

...

We will be using SQL Server Management Studio for this example.

...

You can also follow these instructions if you prefer to backup your Crows Nest database via SSMS.

...

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.

...