• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Copy the file through script and file generation

Hi ...

OS Win 2008 R2 64bit.
I experienced some issues while settings up backup for PostgreSQL...found compatible issue. Finally decided to run script for copy the backup file with file generation.

I am good at script, request your help...

Backup.bak file store in local drive, location d:\data\back\backup.audit
I want to run the script which will copy the file everyday or weekly from the above location to D:\generation

I am looking for script which will copy the file in sequence with date and time it copy..also possible of having log file to know the file name change from source file to new file name with ddmmyyyyhhmmss.

Can you please help me....
0
Skumar_CCSA
Asked:
Skumar_CCSA
  • 12
  • 5
1 Solution
 
vikas_madhusudanaCommented:
@echo off
set datetimef=%date:~-4%_%date:~-7,2%_%date:~-10,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%
echo %datetime%
cp d:\data\back\backup.audit D:\generation\backup_%datetime%.audit

the above script creates out put in format  backup_2014_28_02_13_08_43.audit

you can then invoke the script from windows scheduler

http://windows.microsoft.com/en-in/windows/schedule-task#1TC=windows-7
0
 
Skumar_CCSAAuthor Commented:
thanks I will check and let you know soon.....
0
 
vikas_madhusudanaCommented:
Small correction it should be set datetime= instead of set datetimef= in second line
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Skumar_CCSAAuthor Commented:
getting an error

---------------------------
Windows Script Host
---------------------------
Script:      F:\bac\move.vbs
Line:      1
Char:      1
Error:      Invalid character
Code:      800A0408
Source:       Microsoft VBScript compilation error

---------------------------
OK  
---------------------------


@echo off
set datetime=%date:~-4%_%date:~-7,2%_%date:~-10,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%
echo %datetime%
cp f:\data\back\backup.audit f:\generation\backup_%datetime%.audit
0
 
vikas_madhusudanaCommented:
what i had given is batch script save it as mov.bat
0
 
Skumar_CCSAAuthor Commented:
I tried both ....    .bat and .vbs
It didn't work
0
 
vikas_madhusudanaCommented:
how are you running the script?
0
 
vikas_madhusudanaCommented:
I guess you should save the file as ANSI encoding as below (use nodepad) snapshot
0
 
Skumar_CCSAAuthor Commented:
i get below error now..


2014_03_03_17_26_54
'cp' is not recognized as an internal or external command,
operable program or batch file.
Press any key to continue . . .
0
 
Skumar_CCSAAuthor Commented:
@echo off
set datetime=%date:~-4%_%date:~-7,2%_%date:~-10,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%
echo %datetime%
copy "D:\Backup\from DB\backup.bak" "D:\Backup\to CommVault\backup_%datetime%.bak"

it worked finally....
change is required.
copy instead cp.
0
 
Skumar_CCSAAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 300 points for vikas_madhusudana's comment #a39894151
Assisted answer: 100 points for vikas_madhusudana's comment #a39894478
Assisted answer: 0 points for Skumar_CCSA's comment #a39900053

for the following reason:

All three of worked for solution.
points shared...
0
 
Skumar_CCSAAuthor Commented:
this issue is resolved....
i gave points also...
want to close it...so that it will not list in my open question.
0
 
Skumar_CCSAAuthor Commented:
wrongly clicked close button while using iphone
0
 
Skumar_CCSAAuthor Commented:
wrongly clicked close button while using iphone
0
 
Skumar_CCSAAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 450 points for vikas_madhusudana's comment #a39894151
Assisted answer: 25 points for vikas_madhusudana's comment #a39894478
Assisted answer: 0 points for Skumar_CCSA's comment #a39900053

for the following reason:

correct code.
0
 
Skumar_CCSAAuthor Commented:
correct code.....

@echo off
set datetime=%date:~-4%_%date:~-7,2%_%date:~-10,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%
echo %datetime%
copy "D:\Backup\from DB\backup.bak" "D:\Backup\to CommVault\backup_%datetime%.bak"
0
 
Skumar_CCSAAuthor Commented:
your script worked well..
you also responded fast..
thanks to help.

little correction required.

copy d:\data\back\backup.audit D:\generation\backup_%datetime%.audit
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 12
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now