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


Copy Backup File


Copy Backup File

Author
Message
VastSQL
VastSQL
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: 33999 Visits: 5998
Jeff Moden - Tuesday, February 5, 2019 7:02 AM
VastSQL - Tuesday, February 5, 2019 12:19 AM
barsuk - Monday, February 4, 2019 11:21 PM
Was backup completed? you need to ensure that backup is completed before moving to the Robocopy step.

The copy job runs every 15 mins and some backup takes more than hour to complete and that was the issue


If you have compressed backups available, you should use those. They really do make a performance difference. You might also want to check out some of the lesser known settings for BACKUP, like the number of buffers used, etc. They can also make a pretty decent difference.

I would also consider avoiding the method of doing a backup to one spot and then using RoboCopy or anything else to copy from there to their final resting place. Consider backing up directly to the final place, especially if the drives being used for the current backups is on the same SAN/drives as the databases themselves.

Thanks Jeff for your valuable points.. Will check those

VastSQL
VastSQL
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: 33999 Visits: 5998
Eirikur Eiriksson - Tuesday, February 5, 2019 7:25 AM
Jeff Moden - Tuesday, February 5, 2019 7:02 AM
VastSQL - Tuesday, February 5, 2019 12:19 AM
barsuk - Monday, February 4, 2019 11:21 PM
Was backup completed? you need to ensure that backup is completed before moving to the Robocopy step.

The copy job runs every 15 mins and some backup takes more than hour to complete and that was the issue


If you have compressed backups available, you should use those. They really do make a performance difference. You might also want to check out some of the lesser known settings for BACKUP, like the number of buffers used, etc. They can also make a pretty decent difference.

I would also consider avoiding the method of doing a backup to one spot and then using RoboCopy or anything else to copy from there to their final resting place. Consider backing up directly to the final place, especially if the drives being used for the current backups is on the same SAN/drives as the databases themselves.

Further on Jeff's good points, consider striping the backups if you have multiple IO paths.
Cool

Thanks Erikku, Now all backup to one back drive

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

Group: General Forum Members
Points: 934633 Visits: 49053
VastSQL - Monday, February 11, 2019 5:17 AM
Eirikur Eiriksson - Tuesday, February 5, 2019 7:25 AM
Jeff Moden - Tuesday, February 5, 2019 7:02 AM
VastSQL - Tuesday, February 5, 2019 12:19 AM
barsuk - Monday, February 4, 2019 11:21 PM
Was backup completed? you need to ensure that backup is completed before moving to the Robocopy step.

The copy job runs every 15 mins and some backup takes more than hour to complete and that was the issue


If you have compressed backups available, you should use those. They really do make a performance difference. You might also want to check out some of the lesser known settings for BACKUP, like the number of buffers used, etc. They can also make a pretty decent difference.

I would also consider avoiding the method of doing a backup to one spot and then using RoboCopy or anything else to copy from there to their final resting place. Consider backing up directly to the final place, especially if the drives being used for the current backups is on the same SAN/drives as the databases themselves.

Further on Jeff's good points, consider striping the backups if you have multiple IO paths.
Cool

Thanks Erikku, Now all backup to one back drive


Hopefully that location is on a different physical box than the database files themselves.

--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

When you put the right degree of spin on it, the number 318 is also a glyph that describes the nature of a DBAs job. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
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