RE: backup over server

WinZip just compresses the file for storage.

You uncompress the file when you go to restore.

Steven

> -----Original Message-----
> From: Jumma, Salim [mailto:[Email address protected]
> Sent: Tuesday, January 31, 2006 7:12 AM
> To: Steven Manross
> Cc: LazyDBA Discussion
> Subject: RE: backup over server
>
> Actually I have tested with 30 gig and winzip does it
>
> But I have never tried using a zip file to restore
>
>
> Has any one used winzip files to restore database
>
>
> Thanks for your inputs
>
>
>
> -----Original Message-----
> From: Steven Manross [mailto:[Email address protected]
> Sent: Monday, January 30, 2006 11:59 AM
> 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
>
>
> 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
> > [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
> >
> >
> >
> >
>
>
>
>

MS Sql Server LazyDBA home page