Copy Backup file

hi,
I have a problem copying 12 Gb database backup files (2) for network backup
copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup files
every day night. Sometimes, the files are not copied over the network. I hav
e
full backup every day night and log backup every hour. Can any one suggest a
good solution for copying the backup files out of SAN, (cost effective
solution, without buying software. I dont have a differential backups right
now because of storage space. )
thanks
kris"kpxus" <kpxus@.discussions.microsoft.com> wrote in message
news:8EA2A0EA-61CB-446D-906D-8C9D7BCD96B9@.microsoft.com...
> hi,
> I have a problem copying 12 Gb database backup files (2) for network
backup
> copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup
files
> every day night. Sometimes, the files are not copied over the network. I
have
> full backup every day night and log backup every hour. Can any one suggest
a
> good solution for copying the backup files out of SAN, (cost effective
> solution, without buying software. I dont have a differential backups
right
> now because of storage space. )
>
> thanks
> kris
>
Kris,
Several things come to mind. You could make smaller backups by creating
filegroups and doing filegroup backups on a rotational schedule. Check them
out in the BOL. Faster backups, smaller backups, quicker recovery and
fairly straightforward to use.
You could use the Windows scheduler to copy the files around.
There are shareware/freeware .NET Windows Service apps that can copy files
from just about any location to any other location and include encryption
etc.
Rick Sawtell
MCT, MCSD, MCDBA|||Hi,
You could write a small DOS script (batch file) to copy files from one
location to other and schedule the batch file via windows schedular. For
example:
On the destination server create a batch like:
copy \\server_name\Share_Name\directory_or_fi
lenames
destination_path(E:\sqlbackups\
Test this out. It will work properly.
hth
DeeJay Puar
"kpxus" wrote:

> hi,
> I have a problem copying 12 Gb database backup files (2) for network back
up
> copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup file
s
> every day night. Sometimes, the files are not copied over the network. I h
ave
> full backup every day night and log backup every hour. Can any one suggest
a
> good solution for copying the backup files out of SAN, (cost effective
> solution, without buying software. I dont have a differential backups rig
ht
> now because of storage space. )
>
> thanks
> kris
>|||Thanks
"DeeJay Puar" <DeeJayPuar@.discussions.microsoft.com> wrote in message
news:30CD919E-39BD-408F-9A9E-239FA9F62BA7@.microsoft.com...[vbcol=seagreen]
> Hi,
> You could write a small DOS script (batch file) to copy files from one
> location to other and schedule the batch file via windows schedular. For
> example:
> On the destination server create a batch like:
> copy \\server_name\Share_Name\directory_or_fi
lenames
> destination_path(E:\sqlbackups\
> Test this out. It will work properly.
> hth
> DeeJay Puar
>
> "kpxus" wrote:
>
backup[vbcol=seagreen]
files[vbcol=seagreen]
have[vbcol=seagreen]
suggest a[vbcol=seagreen]
right[vbcol=seagreen]