I've found WinRar has an overall better compression ratio, and it
handles > 2GB files with no problems.
-----Original Message-----
From: Steven Manross
[mailto:mssqldba-ezmlmshield-x22841953.[Email address protected]
Sent: Monday, January 30, 2006 10:59 AM
To: LazyDBA Discussion
Subject: RE: backup over server
You can't use Winzip to do this..
I believe the Winzip program will only make a 2GB (max) file..
WinRar could do this..
Steven
> -----Original Message-----
> From: Jumma Salim
> [mailto:mssqldba-ezmlmshield-x32145211.[Email address protected]
> Sent: Monday, January 30, 2006 9:56 AM
> To: LazyDBA Discussion
> Subject: RE: backup over server
>
> Has anyone used winzip (9 with command line option)?
> To backup I have 30 gig it compress to 7 gig (about)
>
>
> -----Original Message-----
> From: Davis Ralph
> [mailto:mssqldba-ezmlmshield-x70913682.[Email address protected]
> Sent: Monday, January 30, 2006 11:12 AM
> To: LazyDBA Discussion
> Subject: RE: backup over server
>
> Without LITESPEED we would have issues getting our nightly
> backups completed in time because there are just so many VLDB
> databases(100gb to
> 1tb) and so little time.......
>
> Thanks,
> Ralph W. Davis
> *********************************************************
> *** CORPORATE DBA group - Houston ***
> *** 713-214-4675 (GREENWAY) 713-560-5544(CELL) ***
> *** 800-672-4363(ALPHA PGR) 800-596-1683(DIGITAL PGR) ***
> *** RALPH.[Email address protected] ***
> *********************************************************
>
> -----Original Message-----
> From: LHale
> [mailto:mssqldba-ezmlmshield-x17503853.[Email address protected]
> Sent: Monday, January 30, 2006 10:07 AM
> To: LazyDBA Discussion
> Subject: RE: backup over server
>
> I fully agree with Ralph. LiteSpeed will do the trick and
> will maintain the integrity of the backup. You would not want
> to run a native backup to NAS without this type of tool.
>
> Lisa A. Hale
> Database Administrator
>
>
>
>
> "Davis Ralph " <mssqldba-ezmlmshield-x50038914.[Email
> address protected]
> 01/30/2006 11:04 AM
>
> To
> "LazyDBA Discussion" <[Email address protected] cc
>
> Subject
> RE: backup over server
>
>
>
>
>
>
> All,
>
> This may be trivial but the SQL service
> needs to be running with a domain account in order to backup
> to a non-local drive.
>
> That being said, we backup about 8tb of data
> over the network to
> a NAS filer daily. I would NOT attempt this without using
> LITESPEED(or
> some comparable product). It backups up faster and compresses the
> backups so we are using only 75% of the disk space. Meaning
> the 8tb backup into 2tb of filer disk and across the network
> in less time than a
> standard SQL backup runs to a local drive. LITESPEED has paid for
> itself. The savings in DLT tapes alone are 3 times the
> yearly maintenance.
>
> We have had only a few sparse issues with
> backups to the filer being corrupt and we had the same issues
> with some standard backups.
> Because of the way it backs up the database into memory and
> compresses it the only issue I have found is when the process
> is interrupted by an outside source then the file would be
> corrupt. In my experience the same situation with a standard
> backup would just delete the file.
>
> You also have the option of attaching
> directly to the filer if you are worried about writing over
> the network. I'm not suggesting using the filer drives as
> database drives(our tests on that subjects didn't bode well
> for the filer) but it is excellent for writing our backups
> out and we have them SNAP-REPLICATED to a filer at our BR
> location which plugged that hole also.
>
> Thanks,
> Ralph W. Davis
> *********************************************************
> *** CORPORATE DBA group - Houston ***
> *********************************************************
>
> -----Original Message-----
> From: Jay Butler
> [mailto:mssqldba-ezmlmshield-x60977856.[Email address protected]
> Sent: Monday, January 30, 2006 9:51 AM
> To: LazyDBA Discussion
> Subject: Re: backup over server
>
> Mapped drives belong to the user session. They are not
> available to the services.
>
> Even if you could, I would avoid backing up directly to
> network devices.
>
> I have had bad experiences in the past trying to backup to a
> NAS. SQL Server would report that the backups were
> successful. The files were the
>
> correct size. But, more often than not, the files were
> corrupt. Restores
>
> would fail at some point because of this.
>
> As Christopher suggests, I would backup locally then copy the
> files across the network. You should still use the UNC path
> for the file destination.
>
>
> Jumma Salim wrote:
> > 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
>
> Confidentiality Note: The information contained in this
> message, and any attachments, may contain confidential and/or
> privileged material. It is intended solely for the person or
> entity to which it is addressed. Any review, retransmission,
> dissemination, or taking of any action in reliance upon this
> information by persons or entities other than the intended
> recipient is prohibited. If you received this in error,
> please contact the sender and
>
> delete
> the material from any computer.
>
>
>
> ---------------------------------------------------------------------
> 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
>
> Confidentiality Note: The information contained in this
> message, and any attachments, may contain confidential and/or
> privileged material. It is intended solely for the person or
> entity to which it is addressed. Any review, retransmission,
> dissemination, or taking of any action in reliance upon this
> information by persons or entities other than the intended
> recipient is prohibited. If you received this in error,
> please contact the sender and delete the material from any computer.
>
>
>
> ---------------------------------------------------------------------
> 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