Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Hello, MYOB folks.
I just had a client have a server crash, due to the AO SQL backups filling up the C: drive. So, where can I go to inside both the new AO and/or Classic AO (they both use the same SQL database, yes?), to make sure the SQL backups are going to one of the much larger drives and this doesn't happen again? Thanks.
Solved! Go to Solution.
Thanks for your question - I hope this answer helps!
Classic AO does not use an SQL database, as it is based on flat files. However, the SQL backup can be setup to include the Classic data as well (it takes a backup of the SQL databases and the flat files for Classic). To check where the backup is being stored, within New Accountants Office, go to Maintenance > Backup > Schedule Backups.
The Schedule Backups screen will allow you to setup the Backup Location (the default is C:\MYOB\SQLBackup), how often the backup occurs, and how many of the last scheduled backups are retained. My general recommendation for those who save their backup to the C drive is to make sure there is an off-site copy of the backups.
Thanks for the info, I'll try and implement it soon.
Second question, I see the actual AO SQL database is stored on the C: drive in:
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MYOBACCT\MSSQL\DATA
Is is possible to move this off the C: drive, or is that not recommended?
Okay, the SQL backups are now happily going to the F: drive, where there are many gigabytes free. They were working when they went to the C: drive, but my theory is that the backups kept getting bigger - and bigger - that they eventually used all of the free space on C:, causing the server to crash and not boot. So, to all those system admins with AO, if you haven't already, move the backups to a non-system disk. You will likely save yourself some problems down the road.