New To this site

[chris_stl]

Sorry just joined this site and i have a network/programming question.
Basically need help with batch file I created that zips a data directory - then backs up to alternate hard drive and names them as the computer date.
Not sure where I need to post the questions I need to ask.
Any help would be greatly apperciated.
Thanks

[RaisinCain]

Welcome! What type of assistance do you need (specifically)?

[chris_stl]

Thanks.
SO we have a database that i want to have a months worth of backup for.
I am in testing phase now and cannot get it to work correctly.
We have a access database on a 2003 server. there is a lot of data in the shared data directory. to save time and data going across the network my plan is to first- do a quick copy backup of the data directory - then run a pkzip cmd to zip it down - then back it up to a different HD named the days of the month. ex 1- 2- 3.
Here is what i have so far:
xcopy \\termserv\medtech\*.* /s /y E:\chris

C:\MedTech\MTPost\pkzip -r -p E:\backup E:\chris\*.*

@echo off
:: variables
set drive=E:\test
set folder=%date:~7,2%
set backupcmd=xcopy /y /s /i /f /c /EXCLUDE:C:\exclude.txt

echo ### Backing up directory...
%backupcmd% "E:\backup.zip" "%drive%\%folder%"

echo Backup Complete!
@pause

I keep getting one of two errors. either the Cannot perform a cyclic copy so then i take the /s out but then i get the Does the E:\test\13 specify a file name or directory.
Any help would be greatly appreciated.
Thank you

[Philip]

%backupcmd% "E:\backup.zip" "%drive%\%folder%"

Basically, when you translate your %...% variables, that tranlates to:
xcopy /y /s /i /f /c /EXCLUDE:C:\exclude.txt "E:\backup.zip" E:\test\[month]"

However, depending on your OS, you may have to change the "set folder=%date:~7,2" command. It means take two characters, starting from the 7th character from the "date" command.

Execute "date /t" in command prompt, and see at which character does the month and day start ? The default for US Windows 7 is the days start at the seventh character, it could be different in your case.

[chris_stl]

U tried what you suggested and it did not help. instead of 13 - it just displayed 3.
I need to tell you I manually changes my computer to the 13 th for testing purposes.

[chris_stl]

I was thinking if there was a way to add a pause for like a few seconds - then somehow have a command that typed the letter "d" so that the file or directory is taken care of?
is there a way to do that?

[Philip]

For the %folder%, you need to figure out what does "date /t" in command prompt display, exactly ?
You need this info to display the date correctly, it varies depending on the OS/locale. Just count the number of characters to decide where it should start, or post the results of the "date /t" command here and I can help.


Seems your source is a file, and youd destination is a folder, that is why you're getting the second error. Try this line instead:

%backupcmd% "E:\backup.zip" "%drive%\%folder%\backup.zip"

[chris_stl]

I tried: %backupcmd% "E:\backup.zip" "%drive%\%folder%\backup.zip"
I got the same error???
Here is what i get from date /t:
Sat 03/16/2013

[Philip]

With that date format, your original should be right: set folder=%date:~7,2%

xcopy is usually not needed for copying single files, it is intended more for copying directory structures. Why not use simple "copy" instead ?
Not sure what the "/EXCLUDE:C:\exclude.txt" is there for either.

[chris_stl]

Thanks for your help. I managed to figure it out. Here is what I wound up coming up with:
xcopy \\termserv\medtech\*.* /s /y c:\backup /EXCLUDE:C:\exclude.txt

C:\MedTech\MTPost\pkzip -r -p c:\backup c:\backup\*.*

xcopy c:\backup.zip /s /c /y e:\backup\%date:~7,2%\*.* /i
the "/i" took care of my Directory or File error.