Backup instructions:
Open or install SQL Server Management Suite (SSMS)
DL link for SSMS: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
Connect to your Database:
Right Click the Esha Database>Tasks>Backup
Select Add to set the Destination folder for the backup
Set the File name to (File name).bak
Click OK
The backup should be saved to the Destination folder you selected.
Restore to SQL instance that doesn't currently have the Esha Database attached
Open or install SQL Server Management Suite (SSMS)
DL link for SSMS: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
Connect to your Database:
Right Click Databases and select Restore Database
Select Device for Source select the three elipses ( the ... icon) and click Add to navigate to the location where the backup exists.
Click Ok
The Database will be successfully restored.
Restore to SQL Instance that has Esha Database already attached.
Copy or download the backup to the server/PC that needs to restore the Database.
*It is recommend to save the backup file to a folder on the C: drive
Open or install SQL Server Management Suite (SSMS)
DL link for SSMS: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
Connect to your Database:
Right Click the existing Esha Database and select Tasks>Restore> Database
Select Options select Overwrite the existing database (WITH REPLACE)
On the General tab
Select Device for Source select the three elipses ( the ... icon) and click Add to navigate to the location where the backup exists.
Click Ok
The Database will be successfully restored.
Users will likely need to be granted access to the Esha Database once the Database has been restored.
https://esha.zendesk.com/hc/en-us/articles/115002500451-Adding-Users-with-ESHA-Administrative-Tool
Comments