This is a multi-part message in MIME format.
------=_NextPart_000_00A9_01C45E2B.D34CB1C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I don't now if the SQL allow you recover data of SQL 6.5 to SQL2000, =
but
you can try to do a redirect restore that the netBackup allow. Se the =
topic
Redirecting a Restore to a Different Host in the NetBackup for MSQL =
Server
Administrator's guide.
=20
T+
=20
Carlos Alberto Lima dos Santos
Eng. de Computa=E7=E3o
Campinas-SP - Brasil
* carlos_listas AT yahoo.com DOT br=20
_____ =20
De: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] Em nome de Marx, Keath
Enviada em: ter=E7a-feira, 29 de junho de 2004 15:14
Para: veritas-bu AT mailman.eng.auburn DOT edu
Assunto: [Veritas-bu] SQL Data restore problem
Okay,
I need to know if this is even possible. Here is my scenario:
Master: 2000 SP4, NBU 4.5FP6
Source Client: NT4.0 SP6, NBU Client 4.5FP6, Microsoft SQL 6.5
Destination Client: Windows2000 SP4, NBU Client 4.5FP6, Microsoft =
SQL2000
I am backing up the data from SQL 6.5 via the Netbackup SQL Agent. I =
want
to restore it via the same method (basically we are migrating data from =
a
server in the northeast to a dev server here) Is this even possible?
Also, what about restoring a database to different server (same SQL
version)?
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, =
is
for the sole use of the intended recipient(s) and may contain =
confidential
and privileged information or otherwise be protected by law. Any
unauthorized review, use, disclosure or distribution is prohibited. If =
you
are not the intended recipient, please contact the sender by reply =
e-mail
and destroy all copies of the original message.=20
------=_NextPart_000_00A9_01C45E2B.D34CB1C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>SQL Data restore problem</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D579504701-30062004><FONT =
face=3DArial=20
color=3D#0000ff size=3D2> I don't now if the SQL allow =
you recover=20
data of SQL 6.5 to SQL2000, but you can try to do a redirect restore =
that the=20
netBackup allow. Se the topic Redirecting a Restore to a Different Host =
in the=20
NetBackup for MSQL Server Administrator's guide.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D579504701-30062004><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D579504701-30062004><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>T+</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D579504701-30062004><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV><!-- Converted from =
text/rtf format -->
<P><B><FONT face=3DTahoma color=3D#000040 size=3D2>Carlos Alberto Lima =
dos=20
Santos<BR></FONT></B><I></I><I><FONT face=3DTahoma color=3D#000040 =
size=3D1>Eng. de=20
Computa=E7=E3o</FONT></I><BR><I></I><I><FONT face=3DTahoma =
color=3D#000040=20
size=3D1>Campinas-SP - Brasil</FONT></I><BR><B></B><B><FONT =
face=3DWingdings=20
color=3D#000040 size=3D2>*</FONT></B><FONT face=3DWingdings =
color=3D#000040 size=3D1><FONT=20
face=3D"Courier New"></FONT></FONT> <FONT=20
face=3D"Times New Roman">carlos_listas AT yahoo.com DOT br</FONT><B></B><B></B>
=
</P><BR>
<DIV class=3DOutlookMessageHeader lang=3Dpt-br dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>De:</B> =
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B>Em nome de </B>Marx,
=
Keath<BR><B>Enviada em:</B> ter=E7a-feira, 29 de junho de 2004=20
15:14<BR><B>Para:</B> =
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Assunto:</B>=20
[Veritas-bu] SQL Data restore problem<BR></FONT><BR></DIV>
<DIV></DIV>
<P align=3Dleft><FONT face=3DArial color=3D#000080 =
size=3D2>Okay,</FONT></P>
<P align=3Dleft><FONT face=3DArial color=3D#000080 size=3D2> I =
need to know if=20
this is even possible. Here is my scenario:</FONT></P>
<P align=3Dleft><FONT face=3DArial color=3D#000080 size=3D2>Master: 2000 =
SP4, NBU=20
4.5FP6</FONT></P>
<P align=3Dleft><FONT face=3DArial color=3D#000080 size=3D2>Source =
Client: NT4.0 SP6,=20
NBU Client 4.5FP6</FONT><FONT face=3DArial color=3D#000080 size=3D2>, =
Microsoft SQL=20
6.5</FONT></P>
<P align=3Dleft><FONT face=3DArial color=3D#000080 size=3D2>Destination =
Client:=20
Windows2000 SP4, NBU Client 4.5FP6, Microsoft SQL2000</FONT></P>
<P align=3Dleft><FONT face=3DArial color=3D#000080 size=3D2>I am backing =
up the data=20
from SQL 6.5 via the Netbackup SQL Agent. I want to restore it via =
the=20
same method (basically we are migrating data from a server in the =
northeast to a=20
dev server here)</FONT><FONT face=3DArial color=3D#000080 =
size=3D2> Is this even=20
possible?</FONT></P>
<P align=3Dleft><FONT face=3DArial color=3D#000080 size=3D2>Also, what =
about</FONT><FONT=20
face=3DArial color=3D#000080 size=3D2> restoring a database to different =
server (same=20
SQL version)?</FONT></P><BR>CONFIDENTIALITY NOTICE: This e-mail message, =
including any attachments, is for the sole use of the intended =
recipient(s) and=20
may contain confidential and privileged information or otherwise be =
protected by=20
law. Any unauthorized review, use, disclosure or distribution is =
prohibited. If=20
you are not the intended recipient, please contact the sender by reply =
e-mail=20
and destroy all copies of the original message. </BODY></HTML>
------=_NextPart_000_00A9_01C45E2B.D34CB1C0--
|
