On Aug 26, 2008, at 12:20 PM, B. Cook wrote:

> I have a Win2k3 server with Delta Copy running on it.
>
> There is an automated task that dumps the sql db located on that
> machine to a file:
>
> rsync -avz caass::MSSql
>
> receiving file list ... done
> drwx------           0 2008/08/26 02:00:01 .
> -rwx------   519455232 2008/08/22 02:00:25 CAASS8_db_200808220200.BAK
> -rwx------   519505408 2008/08/23 02:00:22 CAASS8_db_200808230200.BAK
> -rwx------   519462400 2008/08/24 02:00:20 CAASS8_db_200808240200.BAK
> -rwx------   519505408 2008/08/25 02:00:26 CAASS8_db_200808250200.BAK
> -rwx------   519456256 2008/08/26 02:00:25 CAASS8_db_200808260200.BAK
>
> These seem to compress down to a about 135M (with bzip2)
>
> Is there someway that I could only keep the last 7 or so of these?
> Should I compress them on the server first?.. etc.
>
> afict there is something with mtime and --files-from, but they all
> look like it's running that command on the rsyncd server, which in
> this case is Win2k3.
>
> Any suggestions?
>

Found this type of answer..

C:\WINDOWS\system32\forfiles.exe /P "D:\Program Files\Microsoft SQL  
Server\MSSQL\BACKUP" /D -7 /C "CMD /C DEL @FILE"

Make an automated task on the server that will delete files older than  
7 days on the server..

So I didn't get it via rsync or backuppc.. but got it to work none the  
less..





-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/