Pulling trans logs from one server to anthother

I know this can be done using a bat file, but am having issues finding any
documentation.
I need to connect to a mapped drive and move trans log backups from on
server to another server so they can be applied.
Any help would be greatly appreciated.
Thanks in advance
SusanI recommend using VBScript and the Windoes Scripting Host.
here is some documentation:
[url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/ur
l]
It will allow you to create more robust scripts with error handling and
logging capabilities. Here are some examples:
[url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[/u
rl]
Search for the Scripting.FileSystemObject to get code samples.
I used it in the past with very good results. In fact, I have production
systems that depend on scripts I wrote and they still perform as intended.
"SBAUER" wrote:

> I know this can be done using a bat file, but am having issues finding any
> documentation.
> I need to connect to a mapped drive and move trans log backups from on
> server to another server so they can be applied.
> Any help would be greatly appreciated.
> Thanks in advance
> Susan
>|||Thanks Edgardo,
However, my knowledge of VB scripting is very limited.
I'm trying to map a drive and just copy the files over using bat.
I'm sure the way you suggested is the best, but I'm under a time crunch and
don't have time for a learning curve.
"Edgardo Valdez, MCSD, MCDBA" wrote:
> I recommend using VBScript and the Windoes Scripting Host.
> here is some documentation:
> [url]http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx?mfr=true[/
url]
> It will allow you to create more robust scripts with error handling and
> logging capabilities. Here are some examples:
> [url]http://www.microsoft.com/technet/archive/ittasks/maintain/script1.mspx?mfr=true[
/url]
> Search for the Scripting.FileSystemObject to get code samples.
> I used it in the past with very good results. In fact, I have production
> systems that depend on scripts I wrote and they still perform as intended.
> "SBAUER" wrote:
>|||In that case, you can use xcopy

>xcopy /?
Copies files and directory trees.
XCOPY source [destination] [/A | /M] [/D[:date]] [/P] [/S [/E]] [/V] [/W]
[/C] [/I] [/Q] [/F] [/L] [/G] [/H] [/R] [/T] [/U]
[/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z]
[/EXCLUDE:file1[+file2][+file3]...]
source Specifies the file(s) to copy.
destination Specifies the location and/or name of new files.
/A Copies only files with the archive attribute set,
doesn't change the attribute.
/M Copies only files with the archive attribute set,
turns off the archive attribute.
/D:m-d-y Copies files changed on or after the specified date.
If no date is given, copies only those files whose
source time is newer than the destination time.
/EXCLUDE:file1[+file2][+file3]...
Specifies a list of files containing strings. Each string
should be in a separate line in the files. When any of the
strings match any part of the absolute path of the file to be
copied, that file will be excluded from being copied. For
example, specifying a string like \obj\ or .obj will exclude
all files underneath the directory obj or all files with the
.obj extension respectively.
/P Prompts you before creating each destination file.
/S Copies directories and subdirectories except empty ones.
/E Copies directories and subdirectories, including empty ones.
Same as /S /E. May be used to modify /T.
/V Verifies each new file.
/W Prompts you to press a key before copying.
/C Continues copying even if errors occur.
/I If destination does not exist and copying more than one file,
assumes that destination must be a directory.
/Q Does not display file names while copying.
/F Displays full source and destination file names while copying.
/L Displays files that would be copied.
/G Allows the copying of encrypted files to destination that does
not support encryption.
/H Copies hidden and system files also.
/R Overwrites read-only files.
/T Creates directory structure, but does not copy files. Does not
include empty directories or subdirectories. /T /E includes
empty directories and subdirectories.
/U Copies only files that already exist in destination.
/K Copies attributes. Normal Xcopy will reset read-only
attributes.
/N Copies using the generated short names.
/O Copies file ownership and ACL information.
/X Copies file audit settings (implies /O).
/Y Suppresses prompting to confirm you want to overwrite an
existing destination file.
/-Y Causes prompting to confirm you want to overwrite an
existing destination file.
/Z Copies networked files in restartable mode.
The switch /Y may be preset in the COPYCMD environment variable.
This may be overridden with /-Y on the command line.
Example:
C:>xcopy E:\SQLData\*.trn \\remoteserver\C$\SQLBackups
"SBAUER" wrote:
> Thanks Edgardo,
> However, my knowledge of VB scripting is very limited.
> I'm trying to map a drive and just copy the files over using bat.
> I'm sure the way you suggested is the best, but I'm under a time crunch an
d
> don't have time for a learning curve.
>
> "Edgardo Valdez, MCSD, MCDBA" wrote:
>sql