[BCB:3:Network warning:ECB]

Choose an option below to restore the Sage MyAssistant SQL database. You can restore through the Microsoft SQL Server Management Studio, or through a Windows Command line.

Microsoft SQL Server Management Studio Express

SQL Server Management Studio (SSMS) is a free, integrated environment for managing components of your SQL Server. See detailed information about restoring data through SSMS.

1. Stop MyAssistant Live Tile on the desktop and the MyAssistant Alert in the system tray. The processes in the Windows Task Manager will show as MyAssistantLiveTile.exe and MyAssistantAlert.exe if active.
2. Stop the ISDAdminSenderService and ISDAdminTaskService services.
3. Download and install Microsoft SQL Management Studio from the Microsoft Download Center.
4. Connect to the Database Engine where the server name is [Server]\ISD.
5. Right-click Databases and select Restore Database.
6. In the Destination for restore section, the To database: will be Notification.
7. In the Source for restore section, specify the source and location of the backup.
8. Select the backup sets to restore and click OK.
9. On the Options tab, check the box for Overwrite the existing database "With Replace".
10. Click OK.
11. Exit Microsoft SQL Server Management Studio.
12. Verify the contents of your database.
13. Launch the MyAssistant Configuration Manager.
14. Click the SQL Server Database Connection tab.
15. Click Test Settings.
16. If the test completes successfully, click OK. Closing the configuration manager restarts the ISD services.

Windows Command line on the MyAssistant Server

The method described below overwrites the existing database. Review other options when restoring through a command line.

1. Stop the MyAssistant Live Tile on the desktop and the MyAssistant Alert in the system tray. The processes in the Windows Task Manager will show as MyAssistantLiveTile.exe and MyAssistantAlert.exe if active.
2. Stop the ISDAdminSenderService and ISDAdminTaskService services.
3. Go to Start, Run and type cmd.exe.
4. Type sqlcmd -E -S .\ISD -Q "RESTORE DATABASE Notification FROM DISK = '[location]\[filename].bak' WITH REPLACE".
   For example, sqlcmd -E -S .\ISD -Q "RESTORE DATABASE Notification FROM DISK = 'C:\Temp\MyAssistant_backup_12-31-9999.bak ' WITH REPLACE".
5. Exit the Command prompt.
6. Verify the contents of your database.
7. Launch the MyAssistant Configuration Manager.
8. Click the SQL Server Database Connection tab.
9. Click Test Settings.
10. If the test completes successfully, click OK. Closing the configuration manager restarts the ISD services.

Back up a MyAssistant SQL database