Comprehensive data protection for all workloads
Post Reply
panzer
Service Provider
Posts: 20
Liked: 12 times
Joined: Feb 23, 2010 8:22 am
Full Name: Stig Hanssen
Contact:

MS SQL Server backup strategy

Post by panzer » Mar 09, 2015 8:26 am

Hi.
I am currently using Backup Exec for my MS SQL serveres: Weekly full fackup + nightly incremental + hourly transaction log.
Can this solution be replaced with Veeam B&R?

nielsengelen
Veeam Software
Posts: 3112
Liked: 633 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: MS SQL Server backup strategy

Post by nielsengelen » Mar 09, 2015 8:35 am 2 people like this post

Hi Stig,

Veeam can do all of the above and this all without the need for an agent (even the log backups are agentless). You can download our solution for a 30 day trial and create a POC.

In terms of your weekly retention plan Veeam can use forward incremental (http://helpcenter.veeam.com/backup/80/h ... ackup.html) but since v8 we also have a new method called forever forward incremental which creates 1 full backup and after that forever incrementals.

In regards to log backups and restoring SQL you can find more information about our Veeam Explorer for SQL via http://www.veeam.com/microsoft-sql-server-explorer.html
VCP-DCV
Veeam Certified Architect (VMCA)
http://foonet.be

panzer
Service Provider
Posts: 20
Liked: 12 times
Joined: Feb 23, 2010 8:22 am
Full Name: Stig Hanssen
Contact:

Re: MS SQL Server backup strategy

Post by panzer » Mar 09, 2015 8:44 am

How would you configure the backup job for hourly backups? Should the SQL Server have it's own job, or can it be part of a muliple-server job?

nielsengelen
Veeam Software
Posts: 3112
Liked: 633 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: MS SQL Server backup strategy

Post by nielsengelen » Mar 09, 2015 8:53 am 2 people like this post

When you configure a backup job and there is an SQL server in it, Veeam has an application specific tab where you can configure when to backup the logs (every day with the normal backup, every xx minutes,...) and you can also take care of log handling along.

More information can be found via http://helpcenter.veeam.com/backup/80/v ... ssing.html

And more specific:
http://helpcenter.veeam.com/backup/80/v ... p_hiw.html
http://helpcenter.veeam.com/backup/80/v ... ntion.html
http://helpcenter.veeam.com/backup/80/v ... stats.html

It can also be part of a multiple-server job as these application settings can be configured on a per VM basis.
VCP-DCV
Veeam Certified Architect (VMCA)
http://foonet.be

panzer
Service Provider
Posts: 20
Liked: 12 times
Joined: Feb 23, 2010 8:22 am
Full Name: Stig Hanssen
Contact:

Re: MS SQL Server backup strategy

Post by panzer » Mar 12, 2015 7:44 am 6 people like this post

Thank you, this is an excellent solution. Backup Exec is now uninstalled!

Post Reply

Who is online

Users browsing this forum: Cragdoo, hyvokar, Majestic-12 [Bot], StefanZ and 81 guests