We use winrar command line to compress .bak files older than 3 days and then
use dos batch file to ftp compressed file to archive server and delete both
the original .bak and the newly created .rar file.

If we ever need to restore (knocks wood) from a .bak older than 3 days, we
have to reverse the process by downloading via ftp from the atrchive, then
decompress the file, then restore the database... all told it takes about 2
hours for a 1GB (Compressed) file.

Not the best to be certain, but it IS free. (Boss tells me that free is
sometimes better than good)

-----Original Message-----
From: Robert Davis
[mailto:mssqldba-ezmlmshield-x5045393.[Email address protected]
Sent: Tuesday, January 31, 2006 1:34 PM
To: LazyDBA Discussion
Subject: RE: backup over server

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



---------------------------------------------------------------------
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