SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backing up multiple SQL instance and databases using 3rd party software - Any recommendations


Backing up multiple SQL instance and databases using 3rd party software - Any recommendations

Author
Message
ffarouqi
ffarouqi
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2933 Visits: 1635
Hello,

We are looking to have a centralized software management tool for backing up SQL Server databases that can also provide us with better backup and faster restore times as compared to native SQL. Kindly, let me know if you have any recommendations. I have listed a few that comes off of my head but we are planning to purchase "Rubarik"

- Commvault
- Veeam
- Avamar
- RedGate SQL Backup
- Quest Litespeed
Steve Jones
Steve Jones
SSC Guru
SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)

Group: Administrators
Points: 329194 Visits: 20109
Biased here, but Redgate SQL Backup works really well. The speed gains are mostly from compression, which is what many of these products use.

I am wary of products that don't simulate and record their backup in msdb just like a native one. Anything that pretends to snapshot files is worrisome. For those that sit on top of native backup and offer compression, they all mostly work the same, just with different tuning options and multi-server support. I'd test a few.

Disclosure: I work for Redgate.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)

Group: General Forum Members
Points: 507152 Visits: 44274
ffarouqi - Wednesday, November 22, 2017 12:23 PM
Hello,

We are looking to have a centralized software management tool for backing up SQL Server databases that can also provide us with better backup and faster restore times as compared to native SQL. Kindly, let me know if you have any recommendations. I have listed a few that comes off of my head but we are planning to purchase "Rubarik"

- Commvault
- Veeam
- Avamar
- RedGate SQL Backup
- Quest Litespeed


You won't find better backup and faster restore times than the native methods. 3rd party backup tools just make it all a bit easier for people that need it to be easier.

As for a "centralized software management tool" that does this, let me ask.... If you're in a DR situation and trying to get back in business quickly and restores are the only hope left to do so, what are you going to do if your "centralized software management tool" was a casualty of whatever went wrong?

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33342 Visits: 9539


I've used the ones you have listed and I think I may have heard of the one you are considering - is it Rubrik?
I never used Rubrik and have heard good things. But when it comes to backups I personally wouldn't go with a start up. So many of them are written as being so wonderful and then they disappear. Or get bought and disappear.

On your list I would say RedGate SQL Backup was the most stable and easiest to use. And I don't work for them - I'd say they suck if that's what I thought.
Litespeed is better now but I had so many problems with the memory issues many years ago, I still have a bad taste for it.
The others were about the same but I also preferred not to use the agents and just have the software pickup the SQL Server backup files. That can impose some limitations on benefiting from some of the features of each one so that's something to investigate and discuss with whatever other IT groups are involved.
If you use the agents, they all don't support everything you can normally do with SQL Server backups and restores so make sure to check if it supports how you do backups now and how you may do them in the future, what impacts it could have on the restores, etc.

Sue



Steve Jones
Steve Jones
SSC Guru
SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)

Group: Administrators
Points: 329194 Visits: 20109
Jeff Moden - Wednesday, November 22, 2017 2:34 PM
You won't find better backup and faster restore times than the native methods. 3rd party backup tools just make it all a bit easier for people that need it to be easier.

As for a "centralized software management tool" that does this, let me ask.... If you're in a DR situation and trying to get back in business quickly and restores are the only hope left to do so, what are you going to do if your "centralized software management tool" was a casualty of whatever went wrong?

That's not quite true. Compressed backups and restores can be faster, depending on your CPU/IO systems.

As for central servers, SQL Backup can be easily setup and instances added back. Or a restore of the system. We also include utilities in extreme cases to convert our compressed backups to native formats.


Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Beatrix Kiddo
Beatrix Kiddo
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16324 Visits: 5669
Sue_H - Wednesday, November 22, 2017 2:45 PM


I've used the ones you have listed and I think I may have heard of the one you are considering - is it Rubrik?
I never used Rubrik and have heard good things. But when it comes to backups I personally wouldn't go with a start up. So many of them are written as being so wonderful and then they disappear. Or get bought and disappear.


If it is Rubrik, I have quite a lot of experience with it and would personally not recommend it for SQL Server at this stage in its development. I'd be happy to answer questions by PM if anybody wants further details.

(My views are my own and do not represent my employer in any way.)

Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)SSC Guru (507K reputation)

Group: General Forum Members
Points: 507152 Visits: 44274
Steve Jones - SSC Editor - Wednesday, November 22, 2017 4:36 PM
Jeff Moden - Wednesday, November 22, 2017 2:34 PM
You won't find better backup and faster restore times than the native methods. 3rd party backup tools just make it all a bit easier for people that need it to be easier.

As for a "centralized software management tool" that does this, let me ask.... If you're in a DR situation and trying to get back in business quickly and restores are the only hope left to do so, what are you going to do if your "centralized software management tool" was a casualty of whatever went wrong?

That's not quite true. Compressed backups and restores can be faster, depending on your CPU/IO systems.

As for central servers, SQL Backup can be easily setup and instances added back. Or a restore of the system. We also include utilities in extreme cases to convert our compressed backups to native formats.

SQL Server native backups (yes... I'm using 2016 Enterprise Edition and not everyone has the Enterprise Edition) does a fine job of using compressed backups and restores even to NAS if you have a good "pipe". It's part of how I've been able to backup 2TB of databases in a single threaded fashion in just a couple of minutes over an hour.

I also agree that SQL Backup is a fine product and can easily be setup and instances added back. However, as with all such centrally controlled backups, if the box that the backups are on goes down, there is a time lag between that event and the time you can get a new instance online unless you have a hot standby ready and waiting (and a lot of people don't) capable of doing an automatic flop. During that time and depending on the system resources, the databases involved, and the type of traffic the databases are exposed to, you can have several log file explosions in the time it takes to get your centralized backups working again. If no log files explode, you may certainly have to go back to many of the systems to resize the log files back to "normal" because rebuilding the log file during a restore, even in the presence of instant file initialization, is a very expensive part of doing any restore.

It would be interesting to do a head-to-head race of tuned native compressed backups with RG SQL Backup for marketing purposes. Has RedGate done such a test and published such results somewhere?


--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Steve Jones
Steve Jones
SSC Guru
SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)

Group: Administrators
Points: 329194 Visits: 20109
Jeff Moden - Friday, November 24, 2017 9:48 AM
It would be interesting to do a head-to-head race of tuned native compressed backups with RG SQL Backup for marketing purposes. Has RedGate done such a test and published such results somewhere?

Not that I know of.

The backups and restores can take place without the centralized console, which is a client side item. Backups and restores can be done with code on each individual instance, so no time needed there in emergencies.


Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Kenneth Igiri
Kenneth Igiri
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2380 Visits: 532
We use Symantec Netbackup. It is quite robust and handles SQL Server backups across about forty instances. We do get throughputs of up to 20Kbps and restore is easy. You can also configure log backups and in one go restore full backups plus associated TLog backups. You can also set it up to work across data centres by using a centralized catalog (we are still studying this so don't take my word for it).

Netbackup also offers encription. The scheduling is great and you can monitor and get an after the fact view of periodic backups. Netbackup also handles backup to tape. It is indeed complex to setup and expensive but could be worth the while. In the passed we used Commvault but I was not so versed with it but I do think Netbackup is more robust.

Br. Kenneth Igiriwww.scribblingsage.comwww.igiribooks.comAll nations come to my light, all kings to the brightness of my risingSmooooth
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (136K reputation)SSC Guru (136K reputation)SSC Guru (136K reputation)SSC Guru (136K reputation)SSC Guru (136K reputation)SSC Guru (136K reputation)SSC Guru (136K reputation)SSC Guru (136K reputation)

Group: General Forum Members
Points: 136697 Visits: 18209
Steve Jones - SSC Editor - Wednesday, November 22, 2017 4:36 PM
Jeff Moden - Wednesday, November 22, 2017 2:34 PM
You won't find better backup and faster restore times than the native methods. 3rd party backup tools just make it all a bit easier for people that need it to be easier.

As for a "centralized software management tool" that does this, let me ask.... If you're in a DR situation and trying to get back in business quickly and restores are the only hope left to do so, what are you going to do if your "centralized software management tool" was a casualty of whatever went wrong?

That's not quite true. Compressed backups and restores can be faster, depending on your CPU/IO systems.

As for central servers, SQL Backup can be easily setup and instances added back. Or a restore of the system. We also include utilities in extreme cases to convert our compressed backups to native formats.


+1
In fact, Litespeed also has disk and network resilience options so that when restoring across a network for instance, it will retry lost buffers and increase the chance of a successful operation, where native will just crap out with a rather long MS error message BigGrin

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search