|
[Veritas-bu] restore of clustered SQL database on virtual node to stand alone server
2006-01-21 10:10:33
|
Subject: |
[Veritas-bu] restore of clustered SQL database on virtual node to stand alone server |
|
From: |
perf AT peppas DOT gr (Jim Peppas) |
|
Date: |
Sat, 21 Jan 2006 17:10:33 +0200 |
This is a multi-part message in MIME format.
------=_NextPart_000_00C1_01C61EAD.9B0FB070
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi.
I don't think that you need to anything weird. You can restore a MSSQL
backup to an alternate SQL Server - clustered or not.
See the MSSQL Admin Giude). Beware only of security issues (users and logons
etc).
Regards,
Jim
_____
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 6:57 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] restore of clustered SQL database on virtual node to
stand alone server
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
Many Thanks. Mark
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.
**********************************************************************
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.
This footnote also confirms that this email message has been swept for the
presence of computer viruses.
**********************************************************************
------=_NextPart_000_00C1_01C61EAD.9B0FB070
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<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 dir=3Dltr align=3Dleft><SPAN class=3D242530415-21012006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Hi.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D242530415-21012006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D242530415-21012006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>I don't think that you need to anything weird. =
You can=20
restore a MSSQL backup to an alternate SQL Server - clustered or=20
not.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D242530415-21012006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D242530415-21012006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>See the MSSQL Admin Giude). Beware only of =
security issues=20
(users and logons etc).</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D242530415-21012006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D242530415-21012006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Regards,</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D242530415-21012006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Jim</FONT></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> =
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B>On Behalf Of =
</B>Kilpatrick,=20
Mark<BR><B>Sent:</B> Wednesday, January 18, 2006 6:57 PM<BR><B>To:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> [Veritas-bu] =
restore of=20
clustered SQL database on virtual node to stand alone=20
server<BR></FONT><BR></DIV>
<DIV></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 OS=20
of each physical node using the physical hostname. I would like to =
restore these=20
SQL databases at my DR site and I have one server available for the =
restore. Is=20
it possible to restore the database to a server that is not a member of =
a=20
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 =
different=20
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 =
expansion=20
Sabeo Technologies have moved office – to The Courtyard, =
Carmanhall Road,=20
Sandyford, Dublin 18. Our telephone and fax numbers remain unchanged. A =
location=20
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 have=20
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></BODY></HTML>
------=_NextPart_000_00C1_01C61EAD.9B0FB070--
|
|
|
