Copy .bak file to another Windows server using job MS SQL Server agent -
i trying copy .bak file nightly server server b. can using sql server job agent run every night? thinking of adding copy command statement within step of job. like: 'copy "g:\source\folder\" "\target\folder\"' inside step , setting type operating system(cmdexec). there way it?
is question command copy files?
if want copy entire folder use robocopy instead of copy
Comments
Post a Comment