Environment:

  • Local Server
  • SQL Database

 

Procedure:

  1. Open SQL Server Management Studio Express and connect to the SQL server.
  2. Expand Databases.
  3. Right-click on the database you want to back up, then select Tasks > Back up.
  4. On the Back Up Database window, make sure the Database field contains the name of the database you want to back up. In this case is k2
  5. Select the Backup Type. By default, it is Full - leave it set to that.
  6. Click Remove to remove the default/last backup file name.
  7. Click Add to open the Select Backup Destination window.
  8. Click [...] next to the File Name field.
  9. On the Locate Database Files window, select the folder where you want to backup file to go. By default, it is ..Microsoft SQL ServerMSSQL.1MSSQLBackup.
  10. In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 11 May 2019.
  11. Click OK to close the Locate Database Files window.
  12. Click OK to close the Select Backup Destination window.
  13. Click OK to start the backup. The progress icon displays in the lower left corner, and a ‘completed successfully’ message displays when its done.

Should you find the information from the article useful or leading you to the answer please mark as "Solution and/or Kudo", as it will assist other k2 developers with relevant information in the near future.

 

Best Regards

Elvis

 

[K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member]