<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I am extremely new to Powershell so any help would be greatly appreciated! &nbsp;<br />
<br />
Our SQL DB server is hosted. &nbsp;I need to copy the .bak files for the SQL weekly backup, differential backup and transaction log backups to another offsite location via FTP.<br />
<br />
The source folder is:<br />
<br />
\\servername\c$\database backups\daily backups\<br />
\\servername\c$\database backups\differtials\<br />
\\servername\c$\database backups\translogs\<br />
<br />
Because the full backups happen every Friday evening and are pruned every 3 weeks, I only want to copy the most recent Friday's backup. &nbsp;I'd like the backup to run Saturday morning.<br />
<br />
Because the diffs and the trn logs backups run constantly I'd like to also copy only the previous date's files. &nbsp;I'd like to run these every morning between 12am and 2am.<br />
<br />
Can someone please assist?<br />
<br />
Thank you all in advance.
</div>
</div>


Hello all,

I am extremely new to Powershell so any help would be greatly appreciated!  

Our SQL DB server is hosted.  I need to copy the .bak files for the SQL weekly backup, differential backup and transaction log backups to another offsite location via FTP.

The source folder is:

\\servername\c$\database backups\daily backups\
\\servername\c$\database backups\differtials\
\\servername\c$\database backups\translogs\

Because the full backups happen every Friday evening and are pruned every 3 weeks, I only want to copy the most recent Friday's backup.  I'd like the backup to run Saturday morning.

Because the diffs and the trn logs backups run constantly I'd like to also copy only the previous date's files.  I'd like to run these every morning between 12am and 2am.

Can someone please assist?

Thank you all in advance.

Powershell script to FTP recent files.

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.