Performing a backup of SQL LocalDB before installing updates
Before you update an existing Scout Enterprise Management Suite installation to a newer version, we recommend performing a backup of the LocalDB database.
Method 1:
- Create a copy of the two files
ScoutEnterpriseLocalDB.mdf and
ScoutEnterpriseLocalDB_log.ldf located in the directory C:\Users\<User name>\
After having installed the Scout update version, copy the database files back to the specified directory.
Method 2 (requires SQL Server Management Studio):
-
In SQL Server Management Studio, connect to
Database ScoutEnterpriseLocalDB
Instance (localdb)\.\ScoutEnterpriseManagementSuite_Shared -
Use the Backup feature to create a backup.
For further information, see the Microsoft documentation for SQL Server Management Studio such as https://technet.microsoft.com/en-us/library/ms189621.
After having installed the Scout update version, use the SQL Management Studio feature Restore to restore the database.