Yes I am trying to do the same

Here is my script running on remote server Original file is drive W
(source) To be moved to drive D (destination)

How do I get the name of zip file same as the .bak file

C:\>"c:\winzip\WZZIP" "d:\Microsoft SQL Server\MSSQL\BACKUP\" -t -ee
w:\Microsoft SQL Server\MSSQL\BACKUP\*.bak"


2 question
Can you share your script?

Do you run 2 Database Maintenance plan to back up database ?

-----Original Message-----
From: Sheldon Jeff [mailto:[Email address protected]
Sent: Tuesday, January 31, 2006 3:24 PM
To: Jumma, Salim
Subject: RE: backup over server

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


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




MS Sql Server LazyDBA home page