XCOPY IN MS SQL SERVER

• isabel-1114008

  SSC Eights!

  Points: 919

  More actions

  August 6, 2009 at 9:02 pm

  #134572

  Is it possible to use xcopy in ms sql server? I want to backup my database locally then execute xcopy to automatically copy my backup file to remote server, then restore. How can i execute xcopy in ms sql?

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  August 6, 2009 at 10:37 pm

  #1035794

  Might I make an alternate suggestion, if you are trying for high availability or say a reporting server you might look at log shipping.

  Before I answer your question though, I'd like to understand WHAT you are trying to accomplish..

  CEWII

• Victor Alvarez-1138365

  SSC-Addicted

  Points: 494

  More actions

  August 10, 2009 at 12:07 pm

  #1036947

  Hello,

  I would like to know exactly what do you want to do...

  with the information that you share with us i can tell you the following, You can backup your database locally, then share the folder and restore your database using UNC name.

  With Regards,

  Victor Alvarez
  http://sqlpost.blogspot.com

• Sarab_SQLChamp

  Hall of Fame

  Points: 3882

  More actions

  August 15, 2009 at 5:05 am

  #1039803

  You can use this command:

  master..xp_cmdshell 'xcopy G:\SMSDTH2000_Diff_backup\SMSDTH2000_Diff_backup_latest\DIFF_Backup.sqb \\172.16.9.249\j$\SMSDTH2000_Diff_backup\SMSDTH2000_Diff_backup_latest\'

  Regards,
  Sarabpreet Singh
  Sarabpreet.com
  SQLChamp.com
  Twitter: @Sarab_SQLGeek