August 6, 2009 at 9:02 pm
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?
August 6, 2009 at 10:37 pm
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
August 10, 2009 at 12:07 pm
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
August 15, 2009 at 5:05 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply