Skip to main content
Answer

.BAK file

  • June 12, 2024
  • 4 replies
  • 160 views

Forum|alt.badge.img+3

Hi, All. I have .bak file that have my company Acumatica data. I need to create new env using this .bak file and need to test data in acumatica. My question is how can i use this file. Do i need to use configuration wizard or ssms? 

 

Any link or guide is appreciated. Thanks

Best answer by aaghaei

.Bak file type is a standard file extension for SQL DB backup. So considering you have created your backup using SQL Server, you will need to restore it the same way. You only can restore snapshots directly in Acumatica if you create them inside Acumatica. There are plenty of videos' and articles so you can do a google search on SQL Back/Restore.

4 replies

aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • Answer
  • June 12, 2024

.Bak file type is a standard file extension for SQL DB backup. So considering you have created your backup using SQL Server, you will need to restore it the same way. You only can restore snapshots directly in Acumatica if you create them inside Acumatica. There are plenty of videos' and articles so you can do a google search on SQL Back/Restore.


darylbowman
Captain II
Forum|alt.badge.img+15

I would assume the file is a SQL backup. You would need to set up an Acumatica instance of the correct version (or use an existing one) and then overwrite the corresponding database by restoring the backup in SSMS.


Forum|alt.badge.img+3
  • Author
  • Captain I
  • June 12, 2024

@aaghaei Does Snap shot have some limitations?

 


aaghaei
Captain II
Forum|alt.badge.img+10
  • Captain II
  • June 13, 2024

Yes, I believe you’re limited to 10 GB and must be imported into the save version of the snapshot.