Hello, I am having trouble finding the correct switch and syntax for using Robocopy to copy SQL databases from the SQL server's to a backup server. I have tried : \\sourceserver\share\directory \\targetserver\share /MIR which effectivly deleted eveything in the target directory. I am trying to use Robocopy to syncronise copies of the SQL databases to a backup server, without deleteing the orginal data from the source server. This copy command will be used daily to create backups from Monday to Friday, with the 4th oldest backup being delted on the target server. Eg backup monday, tuesday, wednesday, then when it backs up thursday it will also remove Monday's backup file and so on. Anyhelp would be greatly appreciated. Ron
Hi Ron, this newsgroup focuses on Microsoft Content Management server. Please post your question into an SQL server related newsgroup. Thanks, Stefan "Ron Bhan" <Ron Bhan@discussions.microsoft.com> wrote in message news:35910B5B-B8B2-42D3-8AE0-63EEABCD2A21@microsoft.com... > Hello, > > I am having trouble finding the correct switch and syntax for using > Robocopy > to copy SQL databases from the SQL server's to a backup server. > > I have tried : > \\sourceserver\share\directory \\targetserver\share /MIR which effectivly > deleted eveything in the target directory. > > I am trying to use Robocopy to syncronise copies of the SQL databases to a > backup server, without deleteing the orginal data from the source server. > > This copy command will be used daily to create backups from Monday to > Friday, with the 4th oldest backup being delted on the target server. Eg > backup monday, tuesday, wednesday, then when it backs up thursday it will > also remove Monday's backup file and so on. > > Anyhelp would be greatly appreciated. > > Ron
