Veritas Backup Exec is a backup and disaster recovery solution. It works in virtual, physical, and multi-cloud environments and integrates with several third-party software releases and applications.
Microsoft SQL Server is a great RDBMS and meets all of our requirements. If you need a stable DB platform to support your line of a business application you'll be well served. Licensing costs are far cheaper, more portable and a lot more user friendly than Oracle. Product support and security patches from Microsoft are strong.
Backup Exec works well generally in most environments or situations. The licensing can potentially be a nightmare, but manageable if you have a decent reseller. Backing up and restoring from physical tapes which is not all that common is not as reliable as when backing up and restoring from datastores that reside on hard drives or digital media. It does a good job with large or small backup jobs. Backing up and managing SQL backups requires additional licenses and be a bit clunky. If you are very careful (which you should be anyway) and document as you build these backups you will get better at managing them. Regarding a virtual environment, I have limited experience in that arena, but have done it. Backup Exec can backup VMware environments, but honestly we moved to Unitrends to backup our VM's and are much happier with the backup process. However, restoring a VM in Unitrends can be tedious compared to Backup Exec.
Manage agent based backups - It is easy to schedule and monitor backups. Verifying backups is done for all jobs. Backup performance is excellent.
Provide a wide ranging contingent of backup options - Despite providing a dizzying array of backup options, it is easy to schedule individual or recurring jobs.
Integrates well with our Active Directory - Restoring even individual Active Directory objects is possible.
Could provide better license management from an inventory perspective. How many licenses do I have?.. etc.
When Backup Exec backs up itself it should not select iSCSI backup targets by default. The result is recursive data backup ending in the loss of storage capacity.
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
This software is a mess in my brutally honest opinion. I've spent more time babysitting this software while backing up 20 servers than I did with Veeam backing up 600+. I've had multiple jobs run fine for weeks at a time that just randomly fail out of the blue for seemingly no reason whatsoever. There's no intuitive way to chain jobs, so automation becomes somewhat more problematic if certain jobs depend on other jobs. The forever incremental feature feels tacked on since the merge operation merges all your incremental jobs into the most recent backup and doesn't have the option set a limit on how long to keep your point in time restores.
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
It can do a lot of things on paper and sounds terrific, but in practice it doesn't do any of them well. It can easily be sold to non-technical minds and C-levels, but of all the backup solutions I've used in the last 15 years of my career, Backup Exec is easily the least fault tolerant. Unless this software is a sunk cost and you're on a shoestring budget, I recommend almost anything else. Jobs fail often with obscure error codes and the KB articles in the Veritas support portal are a mess. Within 30 days of a fresh deployment I've logged more tickets with their support than I did in 3 years with Veeam.
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
In the few instances of having to contact support, our overall outcome was always good. They would have received a better score if the wait time was less, but I attribute this to the timing of support calls - it was during the previous owner's time. We have not had to open a support ticket since Veritas Backup Exec took the product back over.
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.
If your company is looking at changing solutions or currently does not have any, Veritas Backup Exec is the way to go. Do yourself a favor and try the 60 day trial, you won't be disappointed! Very simple to use and has a great GUI, much better than what the competition has to offer.
Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.
Backups by their very nature are difficult to quantify when it comes to ROI. Any monies spent should be seen more as insurance . If you never have to claim on it then that is the best outcome. Backup Exec gives you comfort that you can meet any downtime recovery targets set by your business and this is how to benchmark your solution.
Conduct regular DR tests and your this will be your ROI.