We do something similar except instead of zipping them up and moving
them to another server, they get copied to a remote tape drive.


Robert Davis


-----Original Message-----
From: Sheldon Jeff
[mailto:mssqldba-ezmlmshield-x54246103.[Email address protected]
Sent: Tuesday, January 31, 2006 12:24 PM
To: LazyDBA Discussion
Subject: RE: backup over server

Jumma,

Backing up to a remote server will crap out even using UNC path. When
the size of the file reaches a certain point you will receive a message
like 'Unable to apply /837483438.TRN or .BAK' the reason is that the
destination server 'times out' when the backup is occuring. (this is
the cliff note version of it)

What we do is backup files/trans logs to the same server (different
drive) and then run a script to zip up the files. Then send the files
to the remote server. On the remote server we then unzip the files then
continue to restore a database as you would if you didn't zip.

It has worked for us for over a year.....


Jeff

-----Original Message-----
From: Jumma Salim
[mailto:mssqldba-ezmlmshield-x65614601.[Email address protected]
Sent: Monday, January 30, 2006 10:32 AM
To: LazyDBA Discussion
Subject: backup over server

Can I make a backup plan to backup to a different server by mapping a
drive to database server say T drive



Mapped drive does not show when I make Maintenance plan?





If I do through query analyzer it will not do all step that I can easily
do in maintenance plan?





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page