MYOBCommunity
Partner Zone
|
|
Partner Zone

Checking the SQL Backup in AO

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
Trusted User ITWorx_NZ
38 Posts
Trusted User
New Zealand
ITWorx_NZ
Trusted User

38Posts

5Kudos

3Solutions

Solved: Go to Solution

Checking the SQL Backup in AO

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.

3 REPLIES 3
MYOB Staff Post Helen-Z
88 Posts
MYOB Staff Post
Australia
Helen-Z
MYOB Staff Post

88Posts

18Kudos

8Solutions

Accepted Solution Solved Solution

Re: Checking the SQL Backup in AO

Hello @ITWorx_NZ

 

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.


Regards,

Helen
Tax Support Specialist
MYOB Australia Pty Ltd
Trusted User ITWorx_NZ
38 Posts
Trusted User
New Zealand
ITWorx_NZ
Trusted User

38Posts

5Kudos

3Solutions

Re: Checking the SQL Backup in AO

Hi, Helen.

 

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?

Trusted User ITWorx_NZ
38 Posts
Trusted User
New Zealand
ITWorx_NZ
Trusted User

38Posts

5Kudos

3Solutions

Re: Checking the SQL Backup in AO

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. Smiley Happy

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post