copy and move files using either vbscript or powershell or bat if need be

I have a workstation that runs an app connected to some mdb files.  I need to create a script to copy and paste these files from the workstation to a network share.  Windows 7 backup is already being utilized for imaging so I can't use windows backup to backup and move the files to the share.
I want to create a script that copies and moves the files to a network share on a schedule.
I would like to use powershell but my knowledge is limited
vbscript and .bat would be fine.

the data is store on the local machine in a directory that is not a shared directory.  can I grab the files using some sortof $ share designator and then drill into the folder that contains the data?  

example.  no shares on the workstation.   the data is stored in  lets say.  c:\diagram\new
can I run the script on my workstation (not the in place workstation with the data) and move the files to the network share?
jamesmetcalf74Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jamesmetcalf74Author Commented:
There are 3 computers in play
1) my workstation where I would like to run the script from
2) production workstation where the app and data are running.  -data not in a network share
3) the server in the datacenter where I want to copy the files to
0
NVITCommented:
Since source folder is not shared, you'll need admin rights to mdb folder:

copy "\\mdbhost\c$\folder\*.mdb" "\\datacenter\folder"

Open in new window


Note:
- The above will overwrite existing mdb files at "\\datacenter\folder"
- Does not consider that the mdb files may be locked (in use)
- To run it periodically, use Task Scheduler
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jamesmetcalf74Author Commented:
thanks newvillage... can I also run the script using different credentials?
The above example is just a .bat file correct?
0
NVITCommented:
Revised: Added /c argument

Yes, a .bat file. In Task Scheduler...
Actions, Program/script: cmd
Add arguments: /c batfilename.bat

For your creds:
General, Run whether user is logged on or not, Change User or Group
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.