You’re offline. This is a read only version of the page.
Hello All ,
iam wondering which is the best way to take backup of AX 2009?
is it from export the .Dat file from the adminstration >export to or by backup the SQL database ? and when i need to restore the AOS files backup ?
in case one of users delete invoice or record which way i need ?
in case something wrong happened to the system ?
is there way to make the export to (.dat) be scheduled ?
Thank you in advance
*This post is locked for comments
Dear Martin , Faisal ,
Thank you for your reply and hope someone can help me in the this request also :
First of all, users shouldn't be able to delete invoice journals. If they can, you have something wrong in your system and you should fix it rather than keeping it allowed and then dealing with consequences.
If you want to restore the database to how it looked at some point in past, then use database restore. Yes, you can use SQL Server Management Studio for that. Nevertheless note that this is disaster-recovery scenario; disasters shouldn't be a norm in your process.
No, you don't need any synchronization, assuming that the application didn't changed in the meantime (and if it did, you should restore it too, to get a compatible versions of your components).
Hi Ahmed,
AX 2009 stores data into MSSQL server database which can be backed up and restored as normal routine in SQL server, have a look on this link for more details www.serverintellect.com/.../database-backup-ssmse
For your question "If someone deletes invoice....." Yes you can restore this invoice from your database if it exists in your previous backup. You may lose new data which was entered by users after the last backup was taken so you need to be very careful in that case.
On the other hand all your AX 2009 customization stores in .AOD files which can be moved across different systems and you can copy Application folder as a backup too.
Once you restore database from MSSQL all you require to sync your application from AOT.
Hello Martin
Thank you for your Quick Reply
So if one of users for ex delete invoice or something i need to restore the database from the MSSQL studio ?
and if yes is there any steps needed in the system like sync or something?
Data export is no way to backup database. Use database backup. DBMS have exceptional tools for backups and restore to help you not to lose any data in case of a failure.
You need to restore application files if you want to (re)build the application, either because the environment failed or because you want to return to a previous version of your application. It obviously has nothing to do with data in database.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (