At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios nameI found the step on msdn . thanks
http://msdn.microsoft.com/library/d...
ering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> glsD:%23a6HuVc8GHA.4572@.TK2MSFTN
GP02.phx.gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>
Showing posts with label failover. Show all posts
Showing posts with label failover. Show all posts
Monday, March 12, 2012
How to create a new failover cluster
At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios name
I found the step on msdn . thanks
http://msdn.microsoft.com/library/de...ering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> glsD:%23a6HuVc8GHA.4572@.TK2MSFTNGP02.phx .gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios name
I found the step on msdn . thanks
http://msdn.microsoft.com/library/de...ering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> glsD:%23a6HuVc8GHA.4572@.TK2MSFTNGP02.phx .gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>
How to create a new failover cluster
At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios name
.
.
.
.
Fail screen
is the steps correct ?
Regards,
WilliamI found the step on msdn . thanks
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_clustering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> ¼¶¼g©ó¶l¥ó·s»D:%23a6HuVc8GHA.4572@.TK2MSFTNGP02.phx.gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios name
.
.
.
.
Fail screen
is the steps correct ?
Regards,
WilliamI found the step on msdn . thanks
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_clustering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> ¼¶¼g©ó¶l¥ó·s»D:%23a6HuVc8GHA.4572@.TK2MSFTNGP02.phx.gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>
Friday, March 9, 2012
How to create a backup("failover") server?
Hi,
We have a database (SQL SERVER 7.0) and web server on the same NT4
machine(Everything runs off here). The databases started crashing when
being updated with a VB6 program. Now, it's crashing even after we
disable the VB6 program. This has never happen before and we are not
exactly database experts. We muddle through when we have to but now
it's harder.
We have a good number of web applications that uses the database and
it's a pain when it keeps crashing. We have a test server(Win2k) with
SQL Server 7.0 installed but without any of the databases on the Main
server. We would like to temporary use the test server as a
backup("failover") database server until we can figure out the problem
and was wonder how to do this?
Thanks in advance.This is a good start: http://www.microsoft.com/technet/pr...
/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"T.Taylor" <taylort2@.juno.com> wrote in message
news:1129730387.457839.176740@.f14g2000cwb.googlegroups.com...
> Hi,
> We have a database (SQL SERVER 7.0) and web server on the same NT4
> machine(Everything runs off here). The databases started crashing when
> being updated with a VB6 program. Now, it's crashing even after we
> disable the VB6 program. This has never happen before and we are not
> exactly database experts. We muddle through when we have to but now
> it's harder.
> We have a good number of web applications that uses the database and
> it's a pain when it keeps crashing. We have a test server(Win2k) with
> SQL Server 7.0 installed but without any of the databases on the Main
> server. We would like to temporary use the test server as a
> backup("failover") database server until we can figure out the problem
> and was wonder how to do this?
> Thanks in advance.
>
We have a database (SQL SERVER 7.0) and web server on the same NT4
machine(Everything runs off here). The databases started crashing when
being updated with a VB6 program. Now, it's crashing even after we
disable the VB6 program. This has never happen before and we are not
exactly database experts. We muddle through when we have to but now
it's harder.
We have a good number of web applications that uses the database and
it's a pain when it keeps crashing. We have a test server(Win2k) with
SQL Server 7.0 installed but without any of the databases on the Main
server. We would like to temporary use the test server as a
backup("failover") database server until we can figure out the problem
and was wonder how to do this?
Thanks in advance.This is a good start: http://www.microsoft.com/technet/pr...
/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"T.Taylor" <taylort2@.juno.com> wrote in message
news:1129730387.457839.176740@.f14g2000cwb.googlegroups.com...
> Hi,
> We have a database (SQL SERVER 7.0) and web server on the same NT4
> machine(Everything runs off here). The databases started crashing when
> being updated with a VB6 program. Now, it's crashing even after we
> disable the VB6 program. This has never happen before and we are not
> exactly database experts. We muddle through when we have to but now
> it's harder.
> We have a good number of web applications that uses the database and
> it's a pain when it keeps crashing. We have a test server(Win2k) with
> SQL Server 7.0 installed but without any of the databases on the Main
> server. We would like to temporary use the test server as a
> backup("failover") database server until we can figure out the problem
> and was wonder how to do this?
> Thanks in advance.
>
How to create a backup("failover") server?
Hi,
We have a database (SQL SERVER 7.0) and web server on the same NT4
machine(Everything runs off here). The databases started crashing when
being updated with a VB6 program. Now, it's crashing even after we
disable the VB6 program. This has never happen before and we are not
exactly database experts. We muddle through when we have to but now
it's harder.
We have a good number of web applications that uses the database and
it's a pain when it keeps crashing. We have a test server(Win2k) with
SQL Server 7.0 installed but without any of the databases on the Main
server. We would like to temporary use the test server as a
backup("failover") database server until we can figure out the problem
and was wonder how to do this?
Thanks in advance.
This is a good start: http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"T.Taylor" <taylort2@.juno.com> wrote in message
news:1129730387.457839.176740@.f14g2000cwb.googlegr oups.com...
> Hi,
> We have a database (SQL SERVER 7.0) and web server on the same NT4
> machine(Everything runs off here). The databases started crashing when
> being updated with a VB6 program. Now, it's crashing even after we
> disable the VB6 program. This has never happen before and we are not
> exactly database experts. We muddle through when we have to but now
> it's harder.
> We have a good number of web applications that uses the database and
> it's a pain when it keeps crashing. We have a test server(Win2k) with
> SQL Server 7.0 installed but without any of the databases on the Main
> server. We would like to temporary use the test server as a
> backup("failover") database server until we can figure out the problem
> and was wonder how to do this?
> Thanks in advance.
>
We have a database (SQL SERVER 7.0) and web server on the same NT4
machine(Everything runs off here). The databases started crashing when
being updated with a VB6 program. Now, it's crashing even after we
disable the VB6 program. This has never happen before and we are not
exactly database experts. We muddle through when we have to but now
it's harder.
We have a good number of web applications that uses the database and
it's a pain when it keeps crashing. We have a test server(Win2k) with
SQL Server 7.0 installed but without any of the databases on the Main
server. We would like to temporary use the test server as a
backup("failover") database server until we can figure out the problem
and was wonder how to do this?
Thanks in advance.
This is a good start: http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"T.Taylor" <taylort2@.juno.com> wrote in message
news:1129730387.457839.176740@.f14g2000cwb.googlegr oups.com...
> Hi,
> We have a database (SQL SERVER 7.0) and web server on the same NT4
> machine(Everything runs off here). The databases started crashing when
> being updated with a VB6 program. Now, it's crashing even after we
> disable the VB6 program. This has never happen before and we are not
> exactly database experts. We muddle through when we have to but now
> it's harder.
> We have a good number of web applications that uses the database and
> it's a pain when it keeps crashing. We have a test server(Win2k) with
> SQL Server 7.0 installed but without any of the databases on the Main
> server. We would like to temporary use the test server as a
> backup("failover") database server until we can figure out the problem
> and was wonder how to do this?
> Thanks in advance.
>
Wednesday, March 7, 2012
How to create a backup("failover") server?
Hi,
We have a database (SQL SERVER 7.0) and web server on the same NT4
machine(Everything runs off here). The databases started crashing when
being updated with a VB6 program. Now, it's crashing even after we
disable the VB6 program. This has never happen before and we are not
exactly database experts. We muddle through when we have to but now
it's harder.
We have a good number of web applications that uses the database and
it's a pain when it keeps crashing. We have a test server(Win2k) with
SQL Server 7.0 installed but without any of the databases on the Main
server. We would like to temporary use the test server as a
backup("failover") database server until we can figure out the problem
and was wonder how to do this?
Thanks in advance.This is a good start: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"T.Taylor" <taylort2@.juno.com> wrote in message
news:1129730387.457839.176740@.f14g2000cwb.googlegroups.com...
> Hi,
> We have a database (SQL SERVER 7.0) and web server on the same NT4
> machine(Everything runs off here). The databases started crashing when
> being updated with a VB6 program. Now, it's crashing even after we
> disable the VB6 program. This has never happen before and we are not
> exactly database experts. We muddle through when we have to but now
> it's harder.
> We have a good number of web applications that uses the database and
> it's a pain when it keeps crashing. We have a test server(Win2k) with
> SQL Server 7.0 installed but without any of the databases on the Main
> server. We would like to temporary use the test server as a
> backup("failover") database server until we can figure out the problem
> and was wonder how to do this?
> Thanks in advance.
>
We have a database (SQL SERVER 7.0) and web server on the same NT4
machine(Everything runs off here). The databases started crashing when
being updated with a VB6 program. Now, it's crashing even after we
disable the VB6 program. This has never happen before and we are not
exactly database experts. We muddle through when we have to but now
it's harder.
We have a good number of web applications that uses the database and
it's a pain when it keeps crashing. We have a test server(Win2k) with
SQL Server 7.0 installed but without any of the databases on the Main
server. We would like to temporary use the test server as a
backup("failover") database server until we can figure out the problem
and was wonder how to do this?
Thanks in advance.This is a good start: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"T.Taylor" <taylort2@.juno.com> wrote in message
news:1129730387.457839.176740@.f14g2000cwb.googlegroups.com...
> Hi,
> We have a database (SQL SERVER 7.0) and web server on the same NT4
> machine(Everything runs off here). The databases started crashing when
> being updated with a VB6 program. Now, it's crashing even after we
> disable the VB6 program. This has never happen before and we are not
> exactly database experts. We muddle through when we have to but now
> it's harder.
> We have a good number of web applications that uses the database and
> it's a pain when it keeps crashing. We have a test server(Win2k) with
> SQL Server 7.0 installed but without any of the databases on the Main
> server. We would like to temporary use the test server as a
> backup("failover") database server until we can figure out the problem
> and was wonder how to do this?
> Thanks in advance.
>
Friday, February 24, 2012
How to correct registry in renamed server
If a log shipping server must take on the name of another server during
failover, the name in the server registry will not be the same as the name of
the server. What is the best way to correct this?
--
Regards,
JamieFound it
SQL Server 2000
sp_dropserver 'old server name'
sp_addserver 'new server name', 'local'
Delete the entry in Enterprise Manager for the old server name and then
youâ're golden. You will have to stop and start the SQL Server service to
complete the process.
--
Regards,
Jamie
"thejamie" wrote:
> If a log shipping server must take on the name of another server during
> failover, the name in the server registry will not be the same as the name of
> the server. What is the best way to correct this?
> --
> Regards,
> Jamie|||And if you are on 2000, you need to handle the Agent jobs as well:
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:DFACE678-CD17-4B17-9E15-D5FDC74A0A2C@.microsoft.com...
> Found it
> SQL Server 2000
> sp_dropserver 'old server name'
> sp_addserver 'new server name', 'local'
> Delete the entry in Enterprise Manager for the old server name and then
> youâ're golden. You will have to stop and start the SQL Server service to
> complete the process.
> --
> Regards,
> Jamie
>
> "thejamie" wrote:
>> If a log shipping server must take on the name of another server during
>> failover, the name in the server registry will not be the same as the name of
>> the server. What is the best way to correct this?
>> --
>> Regards,
>> Jamie
failover, the name in the server registry will not be the same as the name of
the server. What is the best way to correct this?
--
Regards,
JamieFound it
SQL Server 2000
sp_dropserver 'old server name'
sp_addserver 'new server name', 'local'
Delete the entry in Enterprise Manager for the old server name and then
youâ're golden. You will have to stop and start the SQL Server service to
complete the process.
--
Regards,
Jamie
"thejamie" wrote:
> If a log shipping server must take on the name of another server during
> failover, the name in the server registry will not be the same as the name of
> the server. What is the best way to correct this?
> --
> Regards,
> Jamie|||And if you are on 2000, you need to handle the Agent jobs as well:
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:DFACE678-CD17-4B17-9E15-D5FDC74A0A2C@.microsoft.com...
> Found it
> SQL Server 2000
> sp_dropserver 'old server name'
> sp_addserver 'new server name', 'local'
> Delete the entry in Enterprise Manager for the old server name and then
> youâ're golden. You will have to stop and start the SQL Server service to
> complete the process.
> --
> Regards,
> Jamie
>
> "thejamie" wrote:
>> If a log shipping server must take on the name of another server during
>> failover, the name in the server registry will not be the same as the name of
>> the server. What is the best way to correct this?
>> --
>> Regards,
>> Jamie
Subscribe to:
Comments (Atom)