February 26, 2013 at 12:09 am
Hi i heard that Database backup in multiple strips is faster than database backup in single file. Then I tested it my self to see the difference.
I wanted to know if I'm missing anything else to improve the Runtime of DB Backup
DB Size: 1325549.63 MB
DB Backup in 7 strips took 16 mins: 10 secs
DB Backup in 1 file took mins 53 mins: 24 secs
February 26, 2013 at 2:22 am
You can try different settings for MAXTRANSFERSIZE and BUFFERCOUNT
I use BUFFERCOUNT = 1024 for my backups.
Also, I'm curious as to why you went for an odd number of strips? W Did you find this to be faster than doing 6 or 8?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
February 26, 2013 at 12:16 pm
Just remember that simply adding files won't always speed things up. It's adding files with additional disks under them that really makes a major difference. But, then you have to remember that all those disks must be available to restore.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 26, 2013 at 2:15 pm
Yea that's a good point Grant.
Backup compression is also great for speeding things up.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply