copy of backup files

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  January 10, 2011 at 5:40 am

  #232836

  i have two servers A & B. A is running with local account and B is running with domain account . i want to copy the backup files from A to B server where the backup files with DB _ backup_YR_month _date_LSN NOs.BAK with daily schedule , pls help on this .

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  January 10, 2011 at 5:43 am

  #1271331

  What have you tried so far? Any issues?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  January 10, 2011 at 5:51 am

  #1271336

  i created a copy job with exec cmd_shell copy with . bak but iam not coping with files as db _backup _yr_month _lsn nos .

  how to do ?