Difference between revisions of "SQL Database Backup and Restore"
From Zenitel Wiki
(Created page with "{{Cons}} The SQL database backup and restore will take all, also maps. This is useful for reuse of databases, and also when exchanging information with tech support. Please...") |
|||
| Line 9: | Line 9: | ||
The backup file is a complete backup with all settings. It is found in Program Files > Microsoft SQL Server > MSSQL14.SQLEXPRESS > MSSQL > Backup. | The backup file is a complete backup with all settings. It is found in Program Files > Microsoft SQL Server > MSSQL14.SQLEXPRESS > MSSQL > Backup. | ||
Keep it in a safe place. | Keep it in a safe place. | ||
| + | |||
| + | [[File:SQL Backup.png|thumb|left|500px]] | ||
| + | |||
| + | <br style="clear:both;" /> | ||
Method for restore depends of the situation. If backup file is visible in the database folder of SQL Server Management Tool, then it is sufficient to right-click the database name, select "Tasks" and "Restore" database. | Method for restore depends of the situation. If backup file is visible in the database folder of SQL Server Management Tool, then it is sufficient to right-click the database name, select "Tasks" and "Restore" database. | ||
| + | |||
| + | [[File:SQL Restore 1.png|thumb|left|500px]] | ||
| + | |||
| + | <br style="clear:both;" /> | ||
If the above is not the situation, then right-click the folder "Database", select "Restore Database", then select source "Device". Press the browse button on the end of same line. In the appearing window "Select backup devices" you press "Add" to browse for the location of the .bak file. | If the above is not the situation, then right-click the folder "Database", select "Restore Database", then select source "Device". Press the browse button on the end of same line. In the appearing window "Select backup devices" you press "Add" to browse for the location of the .bak file. | ||
| + | |||
| + | [[File:SQL Restore 4.png|thumb|left|500px]] | ||
| + | |||
| + | <br style="clear:both;" /> | ||
| + | |||
| + | [[File:SQL Restore 3.png|thumb|left|500px]] | ||
| + | |||
| + | <br style="clear:both;" /> | ||
| + | |||
| + | [[File:SQL Restore 3.png|thumb|left|500px]] | ||
| + | |||
| + | <br style="clear:both;" /> | ||
In Vingtor-Stentofon Operator server setup, stop the running service. Enter database name as written in SQL server and press "Check Database". | In Vingtor-Stentofon Operator server setup, stop the running service. Enter database name as written in SQL server and press "Check Database". | ||
Revision as of 11:11, 4 April 2019
|
This article is under construction! |
The SQL database backup and restore will take all, also maps. This is useful for reuse of databases, and also when exchanging information with tech support.
Please see article about XML export, import and clone of single items as icon sets, scripts sets, Filter sets, Camera templates, Button matrices and Layout definitions. Note: Maps can not be exported, imported or cloned but must be added manually in each project.
Open the SQL server instance using SQL Server Management Tool (free tool from Microsoft). Right-click the database name. Select "Tasks/Back Up" and OK. The backup file is a complete backup with all settings. It is found in Program Files > Microsoft SQL Server > MSSQL14.SQLEXPRESS > MSSQL > Backup. Keep it in a safe place.
Method for restore depends of the situation. If backup file is visible in the database folder of SQL Server Management Tool, then it is sufficient to right-click the database name, select "Tasks" and "Restore" database.
If the above is not the situation, then right-click the folder "Database", select "Restore Database", then select source "Device". Press the browse button on the end of same line. In the appearing window "Select backup devices" you press "Add" to browse for the location of the .bak file.
In Vingtor-Stentofon Operator server setup, stop the running service. Enter database name as written in SQL server and press "Check Database". Save configuration data and start service.