Deduplication when using SQL Server backup compression
A quick question about using NetBackup with compressed SQL Server backups. Our backups infrastructure consists of NetBackup v7.6 and NetBackup 5230 appliances. Our SQL server estate is a mixture of SQL Server versions 2005-2012 on Windows 2003-2012. We've noticed that the deduplication ratio (as reported by backup jobs in Netbackup Activity Monitor) for compressed SQL backups is 0% (we experimented with the NetBackup SQL Agent and alsostandard flat file backups). Now we weren't expecting to get much deduplication out of a compressed SQL Server backup - but it was a suprise to get nothing at all. Previous tests performed on other deduplication platforms(Exagrid and Windows native 2012 deduplication) showed that a noticeable (albeit muchlower rate compared with uncompressed backups)deduplication level of about4:1 was possible withcompressed SQL Server backups. So my question is - is this a configuration issue on our NetBackup infrastructure - or is there a technical\designreason why thededuplication of compressed SQL Server backups is not available inNetBackup? Regards TerrySolved4.5KViews0likes3Comments
interrupt when backup large SQL databases
Hi, Usually MSSQL backups are interrupted at the middle of backup, it success if try again second or third times. We tried scenerios below,(First tried with version 7.5.0.5, then 7.6.0.1 and result is same) What is the root cause of the problem do you think? Regards.Solved4.9KViews1like6Comments
Appliance and altnames
Hi We have a new netbackup appliance with version 7.5, I'm trying to work out how to do Microsoft SQL Cluster backups and restores. The part I'm getting stuck on using the sql admin guide is setting up wth altnames files on the appliance (no.restrictions, NODEA and NODEB) How do I do this on the appliance ? thanks AdrianSolved948Views0likes1Comment