RE: backup over server

RE: backup over server

 

  

You forgot fat and lazy.


Christopher Bellizzi
SQL DBA/Programmer
240 Falls Street
Seneca Falls, NY 13148
Phone: (315) 568-7886
Email: Christopher.[Email address protected]
-----Original Message-----
From: Robert Davis
[mailto:mssqldba-ezmlmshield-x2630856.[Email address protected]
Sent: Tuesday, January 31, 2006 1:42 PM
To: LazyDBA Discussion
Subject: RE: backup over server

>> Surely you can test this yourself, no?
>> It would be a lot quicker than waiting for LazyDBAs to email you
back.

That would be the not-lazy way to do it, but, of course, we're lazy.

Robert Davis


-----Original Message-----
From: John A DAVIS
[mailto:mssqldba-ezmlmshield-x84331392.[Email address protected]
Sent: Tuesday, January 31, 2006 8:08 AM
To: LazyDBA Discussion
Subject: RE: backup over server

Surely you can test this yourself, no?
It would be a lot quicker than waiting for LazyDBAs to email you back.
What other choices are there for 30 gigabytes of uncompressed data?
Run it across the network?
Sneaker net it over using an external hardrive or other storage media?
Email it to yourself? Or to your boss since he is so cheap?

Cheers! (rhymes with Beers!)

>>> "Jumma Salim "
<mssqldba-ezmlmshield-x43373700.[Email address protected] 1/31/2006 6:18
AM >>>

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


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


************************************
This e-mail and any files transmitted with it are proprietary and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Industries, Inc. The recipient should check this e-mail and any attachments for the presence of viruses. ITT Industries accepts no liability for any damage caused by any virus transmitted by this e-mail.
************************************


MS Sql Server LazyDBA home page