Restore a MyAssistant SQL database.
Description
Cause
Resolution

[BCB:3:Network warning:ECB]

 

[BCB:5:Third-party support:ECB]

 

Option 1: Use the Microsoft SQL Server Management Studio Express. It is designed to be a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.
Note: For more detailed information regarding the restoration of a backup using the SQL Server Management Studio Express, see http://msdn.microsoft.com/en-us/library/ms177429.aspx

  1. Stop MyAssistant Live Tile on the desktop and the MyAssistant Alert in the system tray.
    Note: 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. This can currently be found at https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
  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. Start the ISDAdminSenderService and ISDAdminTaskService services.


Option 2: Use a Windows Command-line on the MyAssistant Server.
Note: The method described below overwrites the existing database. For more options, review http://msdn.microsoft.com/en-us/library/ms178615.aspx.

  1. If using MyAssistant version 9.8 and later, first stop MyAssistant Live Tile on the desktop and the MyAssistant Alert in the system tray.
    Note: 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. Start the ISDAdminSenderService and ISDAdminTaskService services.

 

Steps to duplicate
Related Solutions

Backup a MyAssistant SQL database