|
[Veritas-bu] restore of clustered SQL database on virtual node to stand alone server
2006-01-18 13:04:45
|
Subject: |
[Veritas-bu] restore of clustered SQL database on virtual node to stand alone server |
|
From: |
spe08 AT co.henrico.va DOT us (Spearman, David) |
|
Date: |
Wed, 18 Jan 2006 13:04:45 -0500 |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C61C59.AA09A727
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Mark,
=20
I believe you will find the key is to give the server at the DR site the
same name as the CLUSTER name of your production system. We recently did
something like this except in the opposite direction (going from a
single machine to a cluster). We just made sure the cluster name was the
same as the old machine and it worked fine. I am sure you will want a
DBA type hanging around when you try it.
=20
David Spearman
County of henrico, Va.=20
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of
Kilpatrick, Mark
Sent: Wednesday, January 18, 2006 11:57 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] restore of clustered SQL database on
virtual node to stand alone server
=09
=09
Hi, I backup a MS SQL Enterprise 2000 Cluster using the virtual
node name to backup the databases.I backup the OS of each physical node
using the physical hostname. I would like to restore these SQL databases
at my DR site and I have one server available for the restore. Is it
possible to restore the database to a server that is not a member of a
Microsoft cluster using the following options...
(a) non clustered server with physical hostname the same as
the original
(b) non clustered server with different physical hostname
=20
Many Thanks. Mark
=20
=20
=09
=20
Due to continued expansion Sabeo Technologies have moved office
- to The Courtyard, Carmanhall Road, Sandyford, Dublin 18. Our telephone
and fax numbers remain unchanged. A location map is available on our
website www.sabeo.com.
=09
=20
=09
=20
=09
=20
=09
**********************************************************************
This email and any files transmitted with it are confidential
and
intended solely for the use of the individual or entity to whom
they
are addressed. If you have received this email in error please
notify
Sabeo Technologies.
=09
=20
This footnote also confirms that this email message has been
swept for the presence of computer viruses.
=09
**********************************************************************
=20
------_=_NextPart_001_01C61C59.AA09A727
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR>
<STYLE>@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt =
72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV><SPAN class=3D680290018-18012006><FONT face=3DArial color=3D#0000ff =
size=3D2>Mark,</FONT></SPAN></DIV>
<DIV><SPAN class=3D680290018-18012006><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D680290018-18012006><FONT face=3DArial color=3D#0000ff =
size=3D2>I=20
believe you will find the key is to give the server at the DR site =
the same=20
name as the CLUSTER name of your production system. We recently did =
something=20
like this except in the opposite direction (going from a single machine =
to a=20
cluster). We just made sure the cluster name was the same as the old =
machine and=20
it worked fine. I am sure you will want a DBA type hanging around when =
you try=20
it.</FONT></SPAN></DIV>
<DIV><SPAN class=3D680290018-18012006></SPAN> </DIV>
<DIV><SPAN class=3D680290018-18012006><FONT face=3DArial color=3D#0000ff =
size=3D2>David=20
Spearman</FONT></SPAN></DIV>
<DIV><SPAN class=3D680290018-18012006><FONT face=3DArial color=3D#0000ff =
size=3D2>County=20
of henrico, Va.</FONT> </SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B>On Behalf Of=20
</B>Kilpatrick, Mark<BR><B>Sent:</B> Wednesday, January 18, 2006 11:57 =
AM<BR><B>To:</B> veritas-bu AT mailman.eng.auburn DOT
edu<BR><B>Subject:</B>=20
[Veritas-bu] restore of clustered SQL database on virtual node to =
stand alone=20
server<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi, I backup a MS SQL =
Enterprise=20
2000 Cluster using the virtual node name to backup the databases.I =
backup the=20
OS of each physical node using the physical hostname. I would like to =
restore=20
these SQL databases at my DR site and I have one server available for =
the=20
restore. Is it possible to restore the database to a server that is =
not a=20
member of a Microsoft cluster using the following =
options…</SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt; TEXT-INDENT: =
-18pt"><FONT=20
face=3DArial size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">(a)<FONT=20
face=3D"Times New Roman" size=3D1><SPAN=20
style=3D"FONT: 7pt 'Times New Roman'"> =20
</SPAN></FONT></SPAN></FONT><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">non clustered server =
with physical=20
hostname the same as the original</SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt; TEXT-INDENT: =
-18pt"><FONT=20
face=3DArial size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">(b)<FONT=20
face=3D"Times New Roman" size=3D1><SPAN=20
style=3D"FONT: 7pt 'Times New Roman'"> =20
</SPAN></FONT></SPAN></FONT><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">non clustered server =
with=20
different physical hostname</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 5pt"><FONT face=3DArial =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Many Thanks. =
=20
Mark</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'"></SPAN> </P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'"></SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'"></SPAN> </P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">Due to =
continued=20
expansion Sabeo Technologies have moved office – to The =
Courtyard, Carmanhall=20
Road, Sandyford, Dublin 18. Our telephone and fax numbers remain =
unchanged. A=20
location map is available on our website www.sabeo.com.</SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'"></SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'"></SPAN> </P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'"></SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'"></SPAN> </P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'"></SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'"></SPAN> </P>
<P><SPAN=20
style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'">****************************************************************=
******</SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">This email and =
any files=20
transmitted with it are confidential and</SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">intended =
solely for the=20
use of the individual or entity to whom they</SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">are addressed. =
If you=20
have received this email in error please notify</SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">Sabeo=20
Technologies.</SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'"></SPAN></P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'"></SPAN> </P>
<P><SPAN style=3D"FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">This footnote =
also=20
confirms that this email message has been swept for the presence of =
computer=20
viruses.</SPAN></P>
<P><SPAN=20
style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'">****************************************************************=
******</SPAN></P>
<P><SPAN=20
style=3D"FONT-SIZE: 8pt; FONT-FAMILY: =
'Arial'"></SPAN> </P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C61C59.AA09A727--
|
|
|
