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
- 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. - Stop the ISDAdminSenderService and ISDAdminTaskService services.
- 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
- Connect to the Database Engine where the server name is [Server]\ISD.
- Right-click Databases and select Restore Database.
- In the Destination for restore section, the To database: will be Notification.
- In the Source for restore section, specify the source and location of the backup.
- Select the backup sets to restore and click OK.
- On the Options tab check the box for Overwrite the existing database "With Replace".
- Click OK.
- Exit Microsoft SQL Server Management Studio.
- Verify the contents of your database.
- 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.
- 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. - Stop the ISDAdminSenderService and ISDAdminTaskService services.
- Go to Start, Run and type cmd.exe.
- 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". - Exit the Command prompt.
- Verify the contents of your database.
- Start the ISDAdminSenderService and ISDAdminTaskService services.