Dynamics Community Forum Thread Details

Backup procedure

I currently have a backup scheduled just once a day a couple hours after closing. I was thinking it would be prudent to backup several times during the hours we're open too but am concerned about performance or if there are any issues to look out for if you backup at the same time your database is being accessed. Craig

I run automated backups every three hours during the day. When done to a local hard drive there is no noticeable lag at the registers on my hardware, which is nothing hot, but the server is recent stuff, not a dinosaur. I think I originally tried to backup across the network and it did cause slowdowns. So, I make local backups during the day and then copy the final backup to another PC on the network at the end of the day. I have a third layer of backup, where the network PC that gets the day's final backup writes it to a thumb drive once a day.

Another thing to consider, I finally went to a RAID 0, mirrored drive setup on the server. If the motherboard supports RAID, all it costs is a second hard drive. Hard drives are now so inexpensive that it was a no-brainer on last server upgrade. Luckily I have not had to rely on it yet, but from what I read (new ground for me), it should be a seamless transition if a drive fails.

Marc

Quick Links

Leaderboard