| Backup a MyAssistant SQL database |
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
- 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.
- 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.
- Expand Databases.
- Right-click on the Notification database, select tasks, and select backup.
- Specify the name and location of the backup.
- Click OK.
Option B: Use a Windows Command-line
- From your MyAssistant Server, create or verify the location where your backup will reside. For example, you might create a folder called C:\Temp.
- Go to Start, Run and type cmd.exe.
- Enter cd c:\ to change to the C:\ drive
- 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".
- Exit the Command prompt.
Option C: Use MyAssistant Server Configuration Manager
Note: This option is no longer available in version 20.3 and above.
- From the server, select Start, All Programs, MyAssistant, MyAssistant Configuration Manager.
- Select MyAssistant Database Connection.
- Click on Backup Database....
- Click Next.
- Select the location to store the generated backup and click the button Backup MyAssistant Database.
- Click Finish.
DocLink: Restore a MyAssistant SQL database.
|
|