MS SQL Database and Data Warehouse Backup


Before the backup

It is recommended to stop Dispatcher Paragon services before database backup is performed.

The backup of databases shall be done at the same time to prevent inconsistency among databases.

Stop all Dispatcher Paragon services in the whole environment (Management Servers, Site Servers) except Dispatcher Paragon Bundled Etcd

MS SQL backup

All backup procedures should be consulted first with the Database Administrator/Owner.

Please note that this is just a quick guide for MS SQL Server Management Studio. Latest documentation is always available on Microsoft web pages.

  1. On the database server, run Microsoft SQL Server Management studio

  2. Click File - Connect to Object Explorer

  3. Choose a Database engine as a Server type and connect to the database server

  4. In the Object Explorer (menu on the left) click Databases

  5. Right-click the SQDB6 database and select the Tasks > Shrink > Database ... option and proceed using OK button

    images/download/attachments/284928288/MSshrink-version-1-modificationdate-1593092205037-api-v2.PNG


  6. Right-click the SQDB6 database and select the Tasks > Back up ... option

  7. Select the destination of your choice

    images/download/attachments/284928288/MSbackup-version-1-modificationdate-1593092205063-api-v2.PNG

  8. Click OK and wait until the backup is successfully finished

    images/download/attachments/284928288/MSsucess-version-1-modificationdate-1593092205080-api-v2.PNG


  9. Repeat steps 5. - 8. for SQDB6_DWH database (if it exists in the deployment scenario).

  10. Repeat steps 5. - 8. for SQDB6_IMS database

  11. Repeat steps 5. - 8. for SQDB6_YPS database (if using Payment System)

MS SQL multiple server warehouse database backup

All backup procedures should be consulted first with the Database Administrator/Owner.

If you have multiple server database deployment please follow next steps to backup warehouse database otherwise skip this section.

Please note that this is just a quick guide for MS SQL Server Management Studio. Latest documentation is always available on Microsoft web pages.

  1. On the warehouse database server, run Microsoft SQL Server Management studio

  2. Click File - Connect to Object Explorer

  3. Choose a Database engine as a Server type and connect to the database server

  4. In the Object Explorer (menu on the left) click Databases

  5. Right-click the SQDB6_DWH database and select the Tasks > Shrink > Database ... option and proceed using OK button

    images/download/attachments/284928288/MS_DWHshrink-version-1-modificationdate-1594219217957-api-v2.PNG

  6. Right-click the SQDB6_DWH database and select the Tasks > Back up ... option

  7. Select the destination of your choice

    images/download/attachments/284928288/MS_DWHbackup-version-1-modificationdate-1594219236620-api-v2.PNG

  8. Click OK and wait until the backup is successfully finished

    images/download/attachments/284928288/MS_DWHsucess-version-1-modificationdate-1594219252930-api-v2.PNG

After the backup


  1. Start Dispatcher Paragon services with Automatic startup type on Management Servers again

    Do not start Dispatcher Paragon Spooler Controller Group Service. It will be started by Dispatcher Paragon Spooler Controller service when proper configuration is ready.

    1. Start Dispatcher Paragon Management Service first

    2. Start remaining Dispatcher Paragon services in no particular order

  2. Start Dispatcher Paragon services with Automatic startup type on Site Servers again

    Do not start Dispatcher Paragon Spooler Controller Group Service. It will be started by Dispatcher Paragon Spooler Controller service when proper configuration is ready.

    1. Start Dispatcher Paragon Spooler Controller first

    2. Start remaining Dispatcher Paragon services in no particular order