So in the near 5 years I've been at my current company, they've had a dedicated server for their accounting department and the software they use (Sage AccPac). They've been in need of an upgrade for years and they finally pulled the trigger on it a couple weeks ago, and the upgrade was completed today.
Prior to the upgrade, I built a new Server 2012 R2 server (as a VMware guest in our ESXi environment). One of the guys who built our network (prior to me coming on-board) told me to build it with four extra drives, configured as follows:
"Backups" (Disk 1 / 500GB)
"Logs" (Disk 2 / 100GB)
"Database" (Disk 3 / 100GB)
"Temp" (Disk 4 / 50GB)
Building that was all fine and dandy, but as far as installing and configuring SQL Server, and then migrating the data from the old server to the new server, I was/am completely out of my league.
Our vendor (ADSS Global) ended up doing the upgrade for us today (which included the SQL installation and configuration), but the lady who did all the work was not a SQL Admin; she is just someone who's been trained to do the basics that specifically relate to their software. She even said at one point during the upgrade "I'm not a SQL administrator, so when I run into problems, I call our SQL engineer". Needless to say, when I told her about the drives I had setup in advance for the SQL data, she said "I don't know anything about that. I'm just going to install it like we're trained to do (everything on the drive), and you'll have to pay $165/hour to talk to one of our SQL engineers if you need more info".
OK, so after that long-winded preface, here's what I'm wondering:
- At this point, should I even bother with all those other disks that my previous SQL Admin told me to build? Even if I do keep them, at this point I don't know how to properly utilize them (at least according to the original intended purpose).
- We don't have any SQL backup software at the moment, so I'm wondering how I should go about doing the backups... And a word of warning on this particular subject: My company would be more inclined to buy a dedicated application for backing up SQL (especially since we already own Altaro for all of our VM backups). They would also be thrilled if I could find an app that's "free" to accomplish the SQL backups.
I've heard legendary tales of SysAdmins who have done SQL backups all for free, but I'm still way out of my league on this topic, so I'd like some advice if possible...