--=_NextPart_000_0016_01C4E1FA.FB4AE680
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
--=_NextPart_000_0016_01C4E1FA.FB4AE680
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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 WALTERSanta = Barbara, CA
--=_NextPart_000_0016_01C4E1FA.FB4AE680--Please don't post in HTML.
I think a hard drive would be far easier and cheaper.
How many days/weeks of backups do you expect to need to save?
"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|||This is a multi-part message in MIME format.
--=_NextPart_000_002D_01C4E27B.9057E270
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
--=_NextPart_000_002D_01C4E27B.9057E270
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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 MVPMariner, =Charlotte, NChttp://www.mariner-usa.com">www.mariner-usa.com(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it'scommunity of SQL Server professionals.http://www.sqlpass.org">www.sqlpass.org
"Nathan Walter"
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 WALTERSanta =Barbara, CA
--=_NextPart_000_002D_01C4E27B.9057E270--|||You can use ntbackup with http://www.firestreamer.com/fsdvd/. This will
allow you to backup with Volume Shadow Copy directly to DVD.
No comments:
Post a Comment