|
[Veritas-bu] restore of clustered SQL database on virtual node to stand alone server
2006-01-18 11:57:08
|
Subject: |
[Veritas-bu] restore of clustered SQL database on virtual node to stand alone server |
|
From: |
mark.kilpatrick AT sabeo DOT com (Kilpatrick, Mark) |
|
Date: |
Wed, 18 Jan 2006 16:57:08 -0000 |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C61C50.3780B5C2
Content-Type: text/plain; charset="UTF-7"
Content-Transfer-Encoding: 7bit
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 +IBM 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_001_01C61C50.3780B5C2
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"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;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>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…</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt;text-indent:-18.0pt'><font=
size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>(a)<font si=
ze=3D1
face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New Roman"'> =
;
</span></font></span></font><font size=3D2 face=3DArial><span style=3D'font=
-size:
10.0pt;font-family:Arial'>non clustered server with physical hostname the s=
ame
as the original</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt;text-indent:-18.0pt'><font=
size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>(b)<font si=
ze=3D1
face=3D"Times New Roman"><span style=3D'font:7.0pt "Times New Roman"'> =
;
</span></font></span></font><font size=3D2 face=3DArial><span style=3D'font=
-size:
10.0pt;font-family:Arial'>non clustered server with different physical host=
name</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal style=3D'margin-bottom:5.0pt'><font size=3D2 face=3DAr=
ial><span
style=3D'font-size:10.0pt;font-family:Arial'>Many Thanks. Mark=
</span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=3D=
'font-size:
12.0pt'> </span></font></p>
</div>
<p><span style=3D"font-family:'Arial';font-size:8pt;"> </span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"></span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"> </span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">Due to continued expa=
nsion Sabeo Technologies have moved office – to The Courtyard, Carma=
nhall Road, Sandyford, Dublin 18. Our telephone and fax numbers remain unc=
hanged. A location map is available on our website www.sabeo.com.</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"></span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"> </span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"></span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"> </span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"></span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"> </span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">*********************=
*************************************************</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">This email and any fi=
les transmitted with it are confidential and</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">intended solely for t=
he use of the individual or entity to whom they</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">are addressed. If you=
have received this email in error please notify</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">Sabeo Technologies.</=
span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"></span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"> </span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">This footnote also co=
nfirms that this email message has been swept for the presence of computer =
viruses.</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;">*********************=
*************************************************</span></p>
<p><span style=3D"font-family:'Arial';font-size:8pt;"> </span></p></bo=
dy>
</html>
------_=_NextPart_001_01C61C50.3780B5C2--
|
| <Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] restore of clustered SQL database on virtual node to stand alone server,
Kilpatrick, Mark <=
|
|
|
