Copy Database Backup from One Server to Another

Question

Copy Database Backup from One Server to Another

ajay.g

Ten Centuries

Points: 1117
More actions
June 9, 2016 at 5:48 am

#308339

Hi,
On one of our servers, we run weekly Full backup (through Maintenance Plan) for all databases onto BACKUP folder. Now, I need to add a step to copy only one Database backup file from BACKUP folder (after completion of FULL backup) to another server. As the folder contains many Database backups along with Time stamp, please let us know how can I take only one backup file to be copied onto another Server.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Write a script in Powershell (or your favourite scripting language) that will take the most recent file and copy it to its destination. Alternatively, there's probably a task in SSIS that will do it for you. Or you might consider backing up directly to the destination instead.

John

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

previously I've used powershell to do this, works very well

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

"Ya can't make an omelette without breaking just a few eggs" 😉

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

Do any of the backups contain any PII or other sensitive information that probably shouldn't leave the production server?

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)