Best backup scheme of single tape drive system

This is a multi-part message in MIME format. ------=_NextPart_000_0339_01BDA43B.0143FAE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear List, I have a question about continuous database backup for a single tape = system. I want to do continuous logical log back up, but my system has = only one tape drive. If I dedicate it to back up full log file, when I = want to do dbspace backup, I am gonna have a problem. =20 =20 This is what I plan to do, I will set a logical log backup to tape, = and when the schedule time for dbspace backup arrives, I will stop the = continuous log back up. Backup dbspace and perform automatic logical = log backup and turn on the continuous log again. Does this make sense? = Is there a way to better automate the whole thing with single tape = system? Thank you Joseph Chuanlarp Satchavarodom chuanlarp@bigfoot.com Software Developer . ------=_NextPart_000_0339_01BDA43B.0143FAE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#000000 size=3D2>Dear List,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>&nbsp;&nbsp;&nbsp; I have a question = about=20 continuous database backup for a single tape system.&nbsp; I want to do=20 continuous logical log back up, but my system has only one tape = drive.&nbsp; If=20 I dedicate it to back up full log file, when I want to do dbspace = backup, I am=20 gonna have a problem.&nbsp; </FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>&nbsp;&nbsp;&nbsp; </FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>&nbsp;&nbsp;&nbsp; This is what I = plan to do, I=20 will set a logical log backup to tape, and when the schedule time for = dbspace=20 backup arrives, I will stop the continuous log back up.&nbsp; Backup = dbspace and=20 perform automatic logical log backup and turn on the continuous log=20 again.&nbsp;&nbsp; Does this make sense?&nbsp; Is there a way to better = automate=20 the whole thing with single tape system?</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV><FONT size=3D2>Thank you</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>Joseph</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV><FONT color=3D#000000 size=3D2>Chuanlarp Satchavarodom<BR><A=20 href=3D"mailto:chuanlarp@bigfoot.com">chuanlarp@bigfoot.com</A><BR>Softwa= re=20 Developer<BR>.</FONT></DIV></BODY></HTML> ------=_NextPart_000_0339_01BDA43B.0143FAE0--