How to restore Security Expert Server (SX-SRV) database?

Search FAQs

Stop all Security Expert Services from Windows-Services.
Open SQL Server Management Studio from the Start Menu.

Note: If SQL Management Studio can't be found, it can be downloaded from Microsoft website for free.

At Connect to Server screen, choose the server name and the preferable authentication method then click Connect.

Connect to Server Micmft• SQL Server 2012 Servertype: Server name SOLEXPRESS Wit-dows Authentication user name: Password: Remember password

Expand the Databases folder.
Right-click SecurityExpert and select Tasks, then select Restore, then select Database.

$Machine generated alternative text:Object Explorer Connect • \SQLEXPRESS (SQL server 130.4001 Databases System Databases Security Security Security Server Obje Replication Management New Database... New Query Script Database as Tasks Policies Facets Start PowerSheII Reports Rename Delete Refresh Properties Detach... Take Offline Bring Online Shrink Back Up... Restore Generate Scripts.. Extract Data-tier Application... Deploy Database to SQL Azure... Export Data-tier Application... Register as Data-tier Application... Upgrade Data-tier Application... Delete Data-tier Application... Import Data... Export Data... Database... Files and Filegroups... Transaction Log...$

Select "Device:" and add your Database file, then click the [...] button.

$Machine generated alternative text:Restore Database - No backupset selected to be restored. Select a General Files Options DESKTOP-18PAGD9\SQLEXPRE [DESKTOP-18PAGD9\SESA5128 88] View connection properties Script Source • Help C) Database: @ Device: Destination Restore to: Restore plan Backup sets to restore: Restore Name Component Timeline... Type Server Database Position LSN Last LSN Checkpoint LSN Full LSN Start Dat Vgrify Beckup Media} Cancel Help$

The Select backup devices window opens.
Click Add to browse to the backup file to be restored.
Browse to the backup file. ( xxxx.bak) ,then click OK.

$Machine generated alternative text:Select backup devices Specify the backup media and its location for your restore operation Backup media type: Backup media C \SECURITYEXP bak Cont arge$

You'll see that the file has been added as a backup path. Click OK.
You should now have the backup file listed under Backup sets to restore.
Select (enable) the Restore check box beside the backup set.

$Machine generated alternative text:Restore Database - SecurityExpert Ready Select a General Files Options DESKTOP-18PAGDÆQLEXPRE [DESKTOP- 18PAGW,SESA5128 88] View connection properties Script Source Help C) Database: @ Device: Data base: Destination Restore to: Restore plan Backup sets to restore: Expert 251 Wednesday.bak SecurityExpert SecurityExpert The last backup taken (Friday, May 31, 2019 PM) Restora Database Timeline... Position Name Sec Component -Full Database Type Server WTEGLVSE197M2ZL\SQLEXPRESS Verify Backup Media Cancel Help$

Click the Options page and ensure the Restore options are set to Overwrite the existing database.

$Machine generated alternative text:Restore Database - SecurityExpert O Ready Select a General Files Options Script • Help Restore options [Z Overwrite the existing database (WITH REPLACE) C] Preserve the replication settings (WITH KEEP REPLICATION) C] Restrict access to the restored database (WITH RESTRICTED USER) Recovery state: Standby file RESTORE WITH RECOVERY SQL Leave the database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored. Tail-Log backup Take tail-log backup before restore Leave source database in the restoring state (WITH NORECOVERV) Backup file: Server connections Files\Microsoft SQL C] Close existing connections to destination database Prompt C] Prompt before restoring each backup The Full-Text Upgrade server property controls whether full-text indexes are imported, rebuilt, or reset for the restored (D database. DESKTOP-18PAGD9\SQLEXPRE [DESKTOP- 18PAGD9\SESA5128 88] View connection properties Cancel Help$

Go back to General page and click Verify Backup Media, after that Progress will show Done.
Click OK to start the restore process. Progress is shown as the database is restored.
Once the restore is complete, restart the Security Expert Services.