[Veritas-bu] SQL online backup query

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C4F832.6E40CBD0
Content-Type: text/plain

Hi 

 

Has anyone come across a system where two different backup tools are being
used to take FULL SQL database backups?

 

We have a system where an interim solution consisted of an online backup
tool taking full db backups alongside SQL itself taking log dumps every ten
minutes. With this in place a NetBackup system was installed and the
NetBackup online SQL agent configured to backup in full the databases only
and SQL continued to log dump every ten minutes. Both backup systems had to
run until the acceptance tests passed successfully. 

 

 A problem occurred recently where a point in time SQL db restore was
required using the NetBackup system. Using the SQL NetBackup Extension GUI I
restored the DB in non-recovered state hoping to go into SQL enterprise
manager and replay the SQL logs bringing the DB online. When trying to do
this it complained of inconsistent LSN (log serial numbers) is this problem
attributed to the fact that two backup tools are taking full backups at
different times of the day can anyone clarify this point for me

 

Kind Regards,

 

Imran 

 


------_=_NextPart_001_01C4F832.6E40CBD0
Content-Type: text/html

<html>

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">


<meta name=Generator content="Microsoft Word 10 (filtered)">

<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
p
        {margin-right:0cm;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman";}
span.EmailStyle17
        {font-family:Arial;
        color:windowtext;}
@page Section1
        {size:595.3pt 841.9pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=EN-GB link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Has anyone come across a system where two different backup
tools are being used to take FULL SQL database backups?</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>We have a system where an interim solution consisted of an 
online
backup tool taking full db backups alongside SQL itself taking log dumps every
ten minutes. With this in place a NetBackup system was installed and the 
NetBackup
online SQL agent configured to backup in full the databases only and SQL 
continued
to log dump every ten minutes. Both backup systems had to run until the 
acceptance
tests passed successfully. </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;A problem occurred recently where a point in time SQL
db restore was required using the NetBackup system. Using the SQL NetBackup 
Extension
GUI I restored the DB in non-recovered state hoping to go into SQL enterprise
manager and replay the SQL logs bringing the DB online. When trying to do this 
it
complained of inconsistent LSN (log serial numbers) is this problem attributed
to the fact that two backup tools are taking full backups at different times of
the day can anyone clarify this point for me</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Kind Regards,</span></font></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Imran </span></font></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;</span></font></p>

</div>

</body>

</html>

------_=_NextPart_001_01C4F832.6E40CBD0--