Knowledgebase
Jakinid Support Website > Help Desk (Jakinid.com) > Knowledgebase

Search help:


How to backup a full AMS SQL database using Microsoft SQL Server Management Studio software?

Solution

Please follow the below step-by-step instructions.

 

1.Run SQL Server Management Studio software and connect to the SQL server. 

 

2.Expand Databases.

 

3.Right-click on the AMS database you would like to do the full backup, then right click to select Tasks > Back up.

 

4.On the Back Up Database window, make sure the Database field contains the name of the AMS database you want to back up.

 

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 the backup file to save into.

In the File Name field, type the name for this backup, with a .bak extension. For example,20220728AMS.bak

 

10.Click OK to close the Locate Database Files window.

 

11.Click OK to close the Select Backup Destination window.

 

12.Click OK to start the backup. The progress icon displays in the lower-left corner, and a ‘completed successfully’ message displays when it's done.

 
Was this article helpful? yes / no
Related articles May we have the steps about how to migrate the AMS from the existing AMS server to another new AMS one?
Is there any way we can change the DB name in the AMS control panel DB setup?
What are the steps for the migration from the on-premises AMS to the AMS SaaS?
Do you have any quick guide about how to install Access Manager Suite?
Is there any way that I can manually re-send the Event Logs back to AMS database?
Article details
Article ID: 216
Category: AMS Software
Views: 2618
Rating (Votes): Article rated 5.0/5.0 (1)

 
« Go back

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies