Backup a MyAssistant SQL database
Description
Cause
Resolution
[BCB:3:Network warning:ECB]
[BCB:5:Third-party support:ECB]

Option A: Use the Microsoft SQL Server Management Studio. 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 creation of a backup using the SQL Server Management Studio, see http://msdn.microsoft.com/en-us/library/ms187510.aspx

  1. Download and install the Microsoft SQL Server Management Studio from the Microsoft Download Center. This can currently be found at https://www.microsoft.com/en-in/download/details.aspx?id=8961.
  2. Connect to the Database Engine where the server name is [Server]\ISD.
    Note: When connecting to the Database you will need to use a logon with sufficient permissions to create a backup. Check with your system administrator if you are unable to access the database. In some cases running SQL Server Management Studio as Administrator is needed 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.

Option B: Use a Windows Command-line

  1. From your MyAssistant Server, create or verify the location where your backup will reside. For example, you might 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"
    For 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.

Option C: Use MyAssistant Server Configuration Manager
Note: This option is no longer available in version 20.3 and above.

  1. From the server, select Start, All Programs, MyAssistant, MyAssistant Configuration Manager.
  2. Select MyAssistant Database Connection.
  3. Click on Backup Database....
  4. Click Next.
  5. Select the location to store the generated backup and click the button Backup MyAssistant Database.
  6. Click Finish.
DocLink: Restore a MyAssistant SQL database.
Defect ID
Steps to duplicate
Related Articles