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

Before you begin

The steps below use the default SQL instance name of ISD. Work with your IT professional to confirm the name of the instance you use for MyAssistant. If you aren't using the default instance, replace "ISD" with your instance name when creating the backup.

Options to make a backup

Use the Microsoft SQL Server Management Studio

SQL Server Management Studio is a free tool for administering components of SQL Server. See detailed information about using SQL Server Management Studio for backups.

1. Download and install the Microsoft SQL Server Management Studio from the Microsoft Download Center.
2. Connect to the Database Engine where the server name is [Server]\ISD. When connecting to the Database, log on with sufficient permissions to create a backup. Check with your system administrator if you’re unable to access the database. Sometimes you need to run SQL Server Management Studio as Administrator to have sufficient permissions.
3. Expand Databases.
4. Right-click on the Notification database, select tasks, and select backup.
5. Specify the name and location of the backup.
6. Click OK.

Use a Windows Command line

1. From your MyAssistant Server, create or verify the location where your backup will reside.
   Example: Create a folder called C:\Temp.
2. Go to Start, Run, and type cmd.exe.
3. Enter cd c:\ to change to the C:\ drive.
4. Type Sqlcmd -S (local)\ISD -Q "BACKUP DATABASE Notification TO DISK = '[Location from step 1]\[desired_file_name].bak' with stats".
   Example: Sqlcmd -S (local)\ISD -Q "BACKUP DATABASE Notification TO DISK = 'C:\Temp\MyAssistant_backup_12-31-9999.bak' with stats".
5. Exit the Command prompt.

Use MyAssistant Server Configuration Manager

This option is no longer available in version 20.3 and later.

1. From the server, select Start, All Programs, MyAssistant, MyAssistant Configuration Manager.
2. Select MyAssistant Database Connection.
3. Click Backup Database....
4. Click Next.
5. Select the location to store the generated backup and click the button Backup MyAssistant Database.
6. Click Finish.

Restore a MyAssistant SQL database.