Introduction

This article will show you how to take a SQL Database backup, of which the support team may need from time to time to investigate issues within the software.


Scenario

You have logged a call with Draycir and one of the support technicians has asked you for a backup of your database.


Steps to follow

  • Launch SQL Server Management Studio
  • Connect to the SQL instance where your database is
  • Navigate Object Explorer to find the database you would like to backup
  • Right click the database and follow Tasks -> Back Up...
  • On the window that opens up, press on the Add... button
  • A smaller window will open with a path on, navigate to a location which you would like to back up to
  • Navigate through your folder structure and find the location which you want to save the back up to
  • Before you press OK, make sure to type in a file name including the .bak extension
  • Once you have done this, press OK on the smaller windows to get back to the Back Up Database window
  • Press OK, and that's your SQL database backup made!

Applies to 

All SQL Based Draycir products, this is a generic KB article.


Related Product
All SQL Based Draycir Products
Ref Number
KBA-00-00-004
Document Date
09-11-2017
Original Author
Tobias Steel
Document Version
v1.0
Last updated 
08-02-2018
Update Author 
Vincent Hodgson