Completed

Powershell script to copy latest db backup from a directory tree

Need a single powershell script to copy files to a another directory:

Retrieve the latest *.bak file from a directory structure and copy it to another directory

Sample source structure:

Z:\dbs\

-SQLSERVER1BACKUPS

-DB1

-FULL

[login to view URL]

[login to view URL]

[login to view URL]

-LOGS

[login to view URL]

[login to view URL]

-DB2

-FULL

[login to view URL]

[login to view URL]

[login to view URL]

-LOGS

[login to view URL]

[login to view URL]

Scan large directory tree(approx 1500 databases in this structure) and copy the newest .bak([login to view URL] and [login to view URL] from the above example from each subdirectory into to Z:\restores.

Also need to be able to modify the script or provide input to filter the list by file name(*DB1*.bak, *DB2*.bak, etc)

Skills: Powershell

See more: powershell script create active directory user accounts excel, shell script copy files directory, powershell script copy files, powershell script create files directory structure, powershell script copy files days, powershell script copy files server, powershell script add users active directory, powershell script copy files network, powershell script create home directory, powershell script create home directory user, powershell script 7zip files copy, powershell backup directory 7zip, powershell script backup directory 7zip, backup server files powershell script, php script copy files directory, powershell script backup exchange 2013, powershell script to pull active directory users, powershell script to backup files to network drive

About the Employer:
( 2 reviews ) Pensacola, United States

Project ID: #20129370

Awarded to:

dfabretti

Hey Paul, I hope everything is OK with you. Here is my offer, I hope we can work together again one more time. Have a great one and I'm looking forward for your reply! Edit: for some reason the project is not on my Pr More

$100 USD in 3 days
(7 Reviews)
3.2

16 freelancers are bidding on average $127 for this job

goodwork20k

I am good in powershell, SQL along with development and automation, please let me know if you are good to award this project to me

$150 USD in 2 days
(19 Reviews)
4.8
romainlopes92

hey I'm Romain, a French Microsoft certified guy. I can do that for you, I already wrote a lot of powershell scripts (you can have a look to my reviews) please contact me for more informations best regards Romain

$111 USD in 1 day
(13 Reviews)
4.5
AhmadSameer

Hey there, I'm a System Engineer with coding skills. I had developed tons of scripts using PowerShell. I can help. Regards.

$250 USD in 7 days
(7 Reviews)
3.8
dany3j

Hello Mr, I can help you with this powershell project, contact me by chat to get more details. Best Regards.

$70 USD in 5 days
(6 Reviews)
3.3
kostiapl

Hi. I would like to work on your project. The solution can be as following 1. script scan directory recursivelly and compare file names on this directory with destination structure and make decision about copying or More

$83 USD in 4 days
(6 Reviews)
3.0
khanicha

Hello, The steps would be like this: 1. Enumerate all database with its properties, so we will get the backup path of each databases. It uses command: Get-SqlDatabase 2. then doing the sorting of the found backup More

$111 USD in 1 day
(1 Review)
2.1
sergioeliot3

Hi there Thanks for using freelancer com. I am super experienced with PowerShell and it is one of my favorite programming, scripting languages. I have accomplished harder tasks than this one. Please ping me to get More

$127 USD in 7 days
(1 Review)
0.8
sinuousinfixy

Hi. I am a system administrator with 6 years of Experience in Windows server administration & DB administration. I am an expert in Powershell, Vb Scripts, Python & Kaseya VSA Procedures. I have written a lot of automat More

$100 USD in 2 days
(0 Reviews)
0.0
joeynorris22

I've built a few powershell scripts to do something similar. Based on your needs it'll probably take me a couple of hours to vet at most. If you'd like it done asap I would be more than happy to help you out. Thanks fo More

$150 USD in 1 day
(0 Reviews)
0.0
tapansam

Solution: The PowerShell script will scan through the input directory for the input file pattern and copy them to the destination directory. While copying files script will write to log files for future references what More

$140 USD in 4 days
(0 Reviews)
0.0
shekharsati

Hi, I have good experience in working on PowerShell extensively. Created and deployed scripts for automating complex processes that generally involve lot of manual work. Done similar activities in the past recently so More

$90 USD in 2 days
(0 Reviews)
0.0
$77 USD in 3 days
(0 Reviews)
0.0
abhijit8975

I have already done this type of project previously. So, I can do it easily in powershell script.

$140 USD in 7 days
(0 Reviews)
0.0
sunilboga05

Hi there! I've been working with PowerShell since 2 yrs! I'm currently working on creating users, adding to AD groups, Modifying user details, generated by an Application, in On-Prem AD and integrating it to Azure AD! More

$166 USD in 1 day
(0 Reviews)
0.0
motzmcm

For the bulk of the last 10+ years my work in the IT industry revolves around resolving tech task and issues with Powershell scripts. I'm highly confident that I'd be able to complete this task for you in a few hours. More

$166 USD in 1 day
(0 Reviews)
0.0