RE: backup over server

RE: backup over server

 

  

Completely safe. It would be of no use if it did not uncompress to a
valid backup file.

However, (insert standard legal disclaimer here) If you have some sort
of disk corruption (possibly a Hard drive going bad), the ZIP file might
not uncomprress.. Thus leaving you without a Backup file..

But.. The same would happen to the uncompressed backup file... if the
same disk corruption happenned so, it's not a problem with ZIP or RAR
files. :)

SQL Litespeed uses the same philosophy, but it compresses the backup
file as it is getting written to disk (and creating a much smaller
backup file (without the need to run an external compressing utility),
but, it's pricey for small installations. If you are willing to take
the extra time to compress your Backup files, then WinZip or other
compression utilities are a low-cost alternative to SQL Litespeed or
other similar products. Winzip/WinRar both have command-line references
and can be called from the command-line in batch or programming
languages such as VB and perl.

I compress NTBACKUP files in this same manner with WinRar
programmatically for several systems in my home (supporting a small
Windows domain).

Steven

> -----Original Message-----
> From: Jumma, Salim [mailto:[Email address protected]
> Sent: Tuesday, January 31, 2006 7:19 AM
> To: Steven Manross
> Cc: LazyDBA Discussion
> Subject: RE: backup over server
>
> Sorry I was not clear
>
> Uncompressed file will work without any loss of data?
> -----Original Message-----
> From: Steven Manross [mailto:[Email address protected]
> Sent: Tuesday, January 31, 2006 9:16 AM
> To: Jumma, Salim
> Cc: LazyDBA Discussion
> Subject: 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