shamnad
asked on
Backup Software for SQL2012
Please recommend best backup software for SQL 2012 providing continous data protection
We use Backup Exec for this purpose. We have found over time that nightly backup suffices and that tape provides for large backups economically
Hi,
we are using Veeam, backing up on every 15min, but it has a lot of options. Shifted from DPM to it, and it works great.
Regards,
Ivan.
we are using Veeam, backing up on every 15min, but it has a lot of options. Shifted from DPM to it, and it works great.
Regards,
Ivan.
If your SQL Installation lives on a virtual machine, Veeam would be the way to go.
Can you define what you mean by 'continuous data protection'? Do you mean to have access to your SQL environment 100% of the time, regardless of hardware failure? That means thinking about redundancy / clustering rather than backups.
If you mean being able to backup the database files without taking it offline, consider creating a database maintenance plan that creates a flat file backup and truncates your transaction logs.
Can you define what you mean by 'continuous data protection'? Do you mean to have access to your SQL environment 100% of the time, regardless of hardware failure? That means thinking about redundancy / clustering rather than backups.
If you mean being able to backup the database files without taking it offline, consider creating a database maintenance plan that creates a flat file backup and truncates your transaction logs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't you like the native SQL Server backup solution?
From the Microsoft side, it exist for example 'System Center Data Protection Manager', which is compatible with most of the different SQL features (Cluster, Mirroring, Always-On, etc).