Re: Log backups

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 07:56:20 -0500

I have never tried to backup directly to a DVD, but it wouldn't take but a second to find out...
If you are going to backup to a disk drive, just buy a cheap IDE drive, and put it on another server somewhere. Backup the logs to the other drive. You could uy 2 drives and swap them out weekly ( depending on how much data you will be backing up).
You could also backup to the IDE drive, THEN copy the backup files to the DVD using normal file copy and backup procedures, then remove the files from the disk drive... 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
  "Nathan Walter" <nwalter@fielding.edu> wrote in message news:eECt22j4EHA.1452@TK2MSFTNGP11.phx.gbl...
  Hello,
  Im looking for an easy, efficient, inexpensive way to backup the SQL transaction logs.  I was thinking about purchasing a DVD burner to back them up to, but I don't know a whole lot about DVD burners or SQL backup for that matter.  Will I be able to do this?  I would like to have the logs backed up to the DVD every half hour, will a DVD support this type of write/re-write access?  Of course in addition to that I plan to have full db backups done once a day to tape, but I can take care of that part.  My main concern is with the log files, does anyone know if backing up to a DVD drive like that will work?
  Thanks.
  -- 
  NATHAN WALTER
  Santa Barbara, CA

Relevant Pages

  • Re: New hard drive, need a plan...
    ... install a fresh copy of my Tiger (along with all the updates I ... don't want to switch the drives while everything is ... Generally I want a plan to also keep a backup OS X that has all ... installed using my DVD but with the updates. ...
    (comp.sys.mac.apps)
  • Re: OT-True Image Backup
    ... Make sure the USB drives file system is NTFS and not FAT32.. ... Jaymon is correct in that the disk image you create and save to the D: ... partition of your USB external HDD will have no effect on the other ... Step-by-Step Instructions for Using the Acronis True Image Program to Backup ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: New year, clean install, any advantage to having applications on D: instead of C:?
    ... to DVD as a means of backing up/archiving/transferring to another ... I am only backup up < 2GB data, ... I have had windows xp setup CDs fail mid installation due ... more reliable than hard drives.. ...
    (uk.comp.homebuilt)
  • Re: OT-True Image Backup
    ... Make sure the USB drives file system is NTFS and not FAT32.. ... Jaymon is correct in that the disk image you create and save to the D: ... partition of your USB external HDD will have no effect on the other ... Since the disk images you will be creating (at least the initial backup ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Back up data to USB?
    ... A flash drive is fine as a secondary means for storing backups of particular files, but I don't think it's suitable for storing drive images unless the amount of data is very small, nor would I rely on a USB flash drive as the only media for the backup of data. ... It also can do file backups and disk cloning. ... can take to back up the entire contents of one's day-to-day working HDD, ... With both hard drives connected, ...
    (microsoft.public.windowsxp.general)