Help with batch file!! File Cleanup

Hi,
I need help adding to my batch file a method of deleting any files over 7
days old. I want to run it as a scheduled task to clean up SQL express backup
files. I'm still not sure why they eliminated the maintence stuff? Thanks for
your help ahead of time.

Here is my batch file so far:



@Echo OFF
@For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
Set Month=%%A
Set Day=%%B
Set Year=%%C
Set All=%%C%%A%%B
)
@For %%a in ("*.bak") do copy %%a "E:\SQL Backups\%%~na - %%~na_%All%.bak"

"lca1630" <lca1630@discussions.microsoft.com> wrote in message
news:0C9EA8D9-0E9A-425D-B1BA-325F859A73C3@microsoft.com...
> Hi,
> I need help adding to my batch file a method of deleting any files over 7
> days old. I want to run it as a scheduled task to clean up SQL express
> backup
> files. I'm still not sure why they eliminated the maintence stuff? Thanks
> for
> your help ahead of time.
>
> Here is my batch file so far:
>
>
>
> @Echo OFF
> @For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
> Set Month=%%A
> Set Day=%%B
> Set Year=%%C
> Set All=%%C%%A%%B
> )
> @For %%a in ("*.bak") do copy %%a "E:\SQL Backups\%%~na - %%~na_%All%.bak"

You could add this line:

xxcopy /db#7 /rs /yy /s *.bak c:\

You can download xxcopy.exe from a number of sites.
By the way, you do not need any of your "@" characters
other than the one in "@echo off". They serve no useful
purpose other than confusing the code.

Thanks Pegasus,

I was having issues with this deleting the entire folder last week. Though I
would post again. You gave me this example last week.

xxcopy /db#7 /rs /yy /s "C:\Test\*.*" c:\

It deletes the entire test folder instead of the files inside which I can
not have happen. Any more help you can give would be great. - Nik

"Pegasus (MVP)" wrote:

>
> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
> news:0C9EA8D9-0E9A-425D-B1BA-325F859A73C3@microsoft.com...
> > Hi,
> > I need help adding to my batch file a method of deleting any files over 7
> > days old. I want to run it as a scheduled task to clean up SQL express
> > backup
> > files. I'm still not sure why they eliminated the maintence stuff? Thanks
> > for
> > your help ahead of time.
> >
> > Here is my batch file so far:
> >
> >
> >
> > @Echo OFF
> > @For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
> > Set Month=%%A
> > Set Day=%%B
> > Set Year=%%C
> > Set All=%%C%%A%%B
> > )
> > @For %%a in ("*.bak") do copy %%a "E:\SQL Backups\%%~na - %%~na_%All%.bak"
>
> You could add this line:
>
> xxcopy /db#7 /rs /yy /s *.bak c:\
>
> You can download xxcopy.exe from a number of sites.
> By the way, you do not need any of your "@" characters
> other than the one in "@echo off". They serve no useful
> purpose other than confusing the code.
>
>
>

The directory c:\Test is deleted if it is empty after all files older
than seven days are deleted. Adding the line

if not exist c:\Temp md c:\Temp

will restore the directory.


"lca1630" <lca1630@discussions.microsoft.com> wrote in message
news:98887FED-EE50-4BB0-A94D-C98654A63F1F@microsoft.com...
> Thanks Pegasus,
>
> I was having issues with this deleting the entire folder last week. Though
> I
> would post again. You gave me this example last week.
>
> xxcopy /db#7 /rs /yy /s "C:\Test\*.*" c:\
>
> It deletes the entire test folder instead of the files inside which I can
> not have happen. Any more help you can give would be great. - Nik
>
> "Pegasus (MVP)" wrote:
>
>>
>> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
>> news:0C9EA8D9-0E9A-425D-B1BA-325F859A73C3@microsoft.com...
>> > Hi,
>> > I need help adding to my batch file a method of deleting any files over
>> > 7
>> > days old. I want to run it as a scheduled task to clean up SQL express
>> > backup
>> > files. I'm still not sure why they eliminated the maintence stuff?
>> > Thanks
>> > for
>> > your help ahead of time.
>> >
>> > Here is my batch file so far:
>> >
>> >
>> >
>> > @Echo OFF
>> > @For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
>> > Set Month=%%A
>> > Set Day=%%B
>> > Set Year=%%C
>> > Set All=%%C%%A%%B
>> > )
>> > @For %%a in ("*.bak") do copy %%a "E:\SQL Backups\%%~na -
>> > %%~na_%All%.bak"
>>
>> You could add this line:
>>
>> xxcopy /db#7 /rs /yy /s *.bak c:\
>>
>> You can download xxcopy.exe from a number of sites.
>> By the way, you do not need any of your "@" characters
>> other than the one in "@echo off". They serve no useful
>> purpose other than confusing the code.
>>
>>
>>

Thanks again, will you give me the complete command with the new part so that
I have the correct syntax. Thansk for your help. - Nik

"Pegasus (MVP)" wrote:

> The directory c:\Test is deleted if it is empty after all files older
> than seven days are deleted. Adding the line
>
> if not exist c:\Temp md c:\Temp
>
> will restore the directory.
>
>
> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
> news:98887FED-EE50-4BB0-A94D-C98654A63F1F@microsoft.com...
> > Thanks Pegasus,
> >
> > I was having issues with this deleting the entire folder last week. Though
> > I
> > would post again. You gave me this example last week.
> >
> > xxcopy /db#7 /rs /yy /s "C:\Test\*.*" c:\
> >
> > It deletes the entire test folder instead of the files inside which I can
> > not have happen. Any more help you can give would be great. - Nik
> >
> > "Pegasus (MVP)" wrote:
> >
> >>
> >> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
> >> news:0C9EA8D9-0E9A-425D-B1BA-325F859A73C3@microsoft.com...
> >> > Hi,
> >> > I need help adding to my batch file a method of deleting any files over
> >> > 7
> >> > days old. I want to run it as a scheduled task to clean up SQL express
> >> > backup
> >> > files. I'm still not sure why they eliminated the maintence stuff?
> >> > Thanks
> >> > for
> >> > your help ahead of time.
> >> >
> >> > Here is my batch file so far:
> >> >
> >> >
> >> >
> >> > @Echo OFF
> >> > @For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
> >> > Set Month=%%A
> >> > Set Day=%%B
> >> > Set Year=%%C
> >> > Set All=%%C%%A%%B
> >> > )
> >> > @For %%a in ("*.bak") do copy %%a "E:\SQL Backups\%%~na -
> >> > %%~na_%All%.bak"
> >>
> >> You could add this line:
> >>
> >> xxcopy /db#7 /rs /yy /s *.bak c:\
> >>
> >> You can download xxcopy.exe from a number of sites.
> >> By the way, you do not need any of your "@" characters
> >> other than the one in "@echo off". They serve no useful
> >> purpose other than confusing the code.
> >>
> >>
> >>
>
>
>

@echo off
xxcopy /db#7 /rs /yy /s "C:\Test\*.*" c:\
if not exist c:\Test md c:\Test


"lca1630" <lca1630@discussions.microsoft.com> wrote in message
news:92468EEF-DF2C-4EF7-81BE-9AC9D3AF0485@microsoft.com...
> Thanks again, will you give me the complete command with the new part so
> that
> I have the correct syntax. Thansk for your help. - Nik
>
> "Pegasus (MVP)" wrote:
>
>> The directory c:\Test is deleted if it is empty after all files older
>> than seven days are deleted. Adding the line
>>
>> if not exist c:\Temp md c:\Temp
>>
>> will restore the directory.
>>
>>
>> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
>> news:98887FED-EE50-4BB0-A94D-C98654A63F1F@microsoft.com...
>> > Thanks Pegasus,
>> >
>> > I was having issues with this deleting the entire folder last week.
>> > Though
>> > I
>> > would post again. You gave me this example last week.
>> >
>> > xxcopy /db#7 /rs /yy /s "C:\Test\*.*" c:\
>> >
>> > It deletes the entire test folder instead of the files inside which I
>> > can
>> > not have happen. Any more help you can give would be great. - Nik
>> >
>> > "Pegasus (MVP)" wrote:
>> >
>> >>
>> >> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
>> >> news:0C9EA8D9-0E9A-425D-B1BA-325F859A73C3@microsoft.com...
>> >> > Hi,
>> >> > I need help adding to my batch file a method of deleting any files
>> >> > over
>> >> > 7
>> >> > days old. I want to run it as a scheduled task to clean up SQL
>> >> > express
>> >> > backup
>> >> > files. I'm still not sure why they eliminated the maintence stuff?
>> >> > Thanks
>> >> > for
>> >> > your help ahead of time.
>> >> >
>> >> > Here is my batch file so far:
>> >> >
>> >> >
>> >> >
>> >> > @Echo OFF
>> >> > @For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
>> >> > Set Month=%%A
>> >> > Set Day=%%B
>> >> > Set Year=%%C
>> >> > Set All=%%C%%A%%B
>> >> > )
>> >> > @For %%a in ("*.bak") do copy %%a "E:\SQL Backups\%%~na -
>> >> > %%~na_%All%.bak"
>> >>
>> >> You could add this line:
>> >>
>> >> xxcopy /db#7 /rs /yy /s *.bak c:\
>> >>
>> >> You can download xxcopy.exe from a number of sites.
>> >> By the way, you do not need any of your "@" characters
>> >> other than the one in "@echo off". They serve no useful
>> >> purpose other than confusing the code.
>> >>
>> >>
>> >>
>>
>>
>>

Thank for your help

"Pegasus (MVP)" wrote:

> @echo off
> xxcopy /db#7 /rs /yy /s "C:\Test\*.*" c:\
> if not exist c:\Test md c:\Test
>
>
> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
> news:92468EEF-DF2C-4EF7-81BE-9AC9D3AF0485@microsoft.com...
> > Thanks again, will you give me the complete command with the new part so
> > that
> > I have the correct syntax. Thansk for your help. - Nik
> >
> > "Pegasus (MVP)" wrote:
> >
> >> The directory c:\Test is deleted if it is empty after all files older
> >> than seven days are deleted. Adding the line
> >>
> >> if not exist c:\Temp md c:\Temp
> >>
> >> will restore the directory.
> >>
> >>
> >> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
> >> news:98887FED-EE50-4BB0-A94D-C98654A63F1F@microsoft.com...
> >> > Thanks Pegasus,
> >> >
> >> > I was having issues with this deleting the entire folder last week.
> >> > Though
> >> > I
> >> > would post again. You gave me this example last week.
> >> >
> >> > xxcopy /db#7 /rs /yy /s "C:\Test\*.*" c:\
> >> >
> >> > It deletes the entire test folder instead of the files inside which I
> >> > can
> >> > not have happen. Any more help you can give would be great. - Nik
> >> >
> >> > "Pegasus (MVP)" wrote:
> >> >
> >> >>
> >> >> "lca1630" <lca1630@discussions.microsoft.com> wrote in message
> >> >> news:0C9EA8D9-0E9A-425D-B1BA-325F859A73C3@microsoft.com...
> >> >> > Hi,
> >> >> > I need help adding to my batch file a method of deleting any files
> >> >> > over
> >> >> > 7
> >> >> > days old. I want to run it as a scheduled task to clean up SQL
> >> >> > express
> >> >> > backup
> >> >> > files. I'm still not sure why they eliminated the maintence stuff?
> >> >> > Thanks
> >> >> > for
> >> >> > your help ahead of time.
> >> >> >
> >> >> > Here is my batch file so far:
> >> >> >
> >> >> >
> >> >> >
> >> >> > @Echo OFF
> >> >> > @For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
> >> >> > Set Month=%%A
> >> >> > Set Day=%%B
> >> >> > Set Year=%%C
> >> >> > Set All=%%C%%A%%B
> >> >> > )
> >> >> > @For %%a in ("*.bak") do copy %%a "E:\SQL Backups\%%~na -
> >> >> > %%~na_%All%.bak"
> >> >>
> >> >> You could add this line:
> >> >>
> >> >> xxcopy /db#7 /rs /yy /s *.bak c:\
> >> >>
> >> >> You can download xxcopy.exe from a number of sites.
> >> >> By the way, you do not need any of your "@" characters
> >> >> other than the one in "@echo off". They serve no useful
> >> >> purpose other than confusing the code.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>