Database Clustering in MS SQL SERVER.

Hi,
I want to do database clustering in ms sql server. So, Please Guide for
the same.
I am currently using ms sql server 2000 with service pack 3 installed
on it.
I already installed sql server 2000 and SP 3 on both the server where
the clustering should setup.
Thanks & Regards,
Sajid.See if this helps:
http://www.microsoft.com/technet/pr...n/failclus.mspx
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
<csajid@.gmail.com> wrote in message
news:1148976451.207722.106000@.i39g2000cwa.googlegroups.com...
Hi,
I want to do database clustering in ms sql server. So, Please Guide for
the same.
I am currently using ms sql server 2000 with service pack 3 installed
on it.
I already installed sql server 2000 and SP 3 on both the server where
the clustering should setup.
Thanks & Regards,
Sajid.|||Hello, have you read
http://msdn.microsoft.com/library/d...br />
7t9v.htm
?
J
"csajid@.gmail.com" wrote:

> Hi,
> I want to do database clustering in ms sql server. So, Please Guide for
> the same.
> I am currently using ms sql server 2000 with service pack 3 installed
> on it.
> I already installed sql server 2000 and SP 3 on both the server where
> the clustering should setup.
> Thanks & Regards,
> Sajid.
>|||Hi,
First thanks for your reply.
I already gone through the link,
http://www.microsoft.com/technet/pr...n/failclus.mspx
&
http://msdn.microsoft.com/library/d...br />
7t9v.htm
but i have some queries regarding both the articals,
1) Is it necessary to do windows clustering and network load balancing
before doing sql server
clustering. Who will do it ? SQl DBA or Win Admin. (In
Active/Passive Clustering)
2) As we want to do Active/Passive clustering so there is need to
create virtual server.
3) Is it necessary to installed ms sql server on both the servers which
are involved in clustering.
4) Please give me the simle steps to start sql server clustering.
Please reply to my queries. I am waiting for reply.
Thanks & Regards,
Sajid.
Julie wrote:[vbcol=seagreen]
> Hello, have you read
> http://msdn.microsoft.com/library/d... />
g_7t9v.htm
> ?
> J
> "csajid@.gmail.com" wrote:
>|||1) Is it necessary to do windows clustering and network load balancing
before doing sql server clustering. Who will do it ? SQl DBA or Win Admin. (
In
Active/Passive Clustering)
A: Microsoft Clustering Services (which is a Windows component) needs to be
setup and configured before installing SQL Server on the cluster.
2) As we want to do Active/Passive clustering so there is need to
create virtual server.
A: There is always a need to create a virtual server. You applications will
use the virtual server name to connect hence making it irrelevant which node
is active at the time.
3) Is it necessary to installed ms sql server on both the servers which
are involved in clustering.
A: No. SQL Server will know you are installing on a cluster (if it's setup
correctly). You will need to have some essential information prior to
installing (like virtual server name and ip address).
4) Please give me the simle steps to start sql server clustering.
Have a look at this for step-by-step instructions (for Windows 2000/SQL
Server 2000):
http://www.sqlservercentral.com/col...pclustering.asp
"csajid@.gmail.com" wrote:

> Hi,
> First thanks for your reply.
> I already gone through the link,
> http://www.microsoft.com/technet/pr... />
g_7t9v.htm
> but i have some queries regarding both the articals,
> 1) Is it necessary to do windows clustering and network load balancing
> before doing sql server
> clustering. Who will do it ? SQl DBA or Win Admin. (In
> Active/Passive Clustering)
> 2) As we want to do Active/Passive clustering so there is need to
> create virtual server.
> 3) Is it necessary to installed ms sql server on both the servers which
> are involved in clustering.
> 4) Please give me the simle steps to start sql server clustering.
> Please reply to my queries. I am waiting for reply.
> Thanks & Regards,
> Sajid.
>
> Julie wrote:
>|||1) Is it necessary to do windows clustering and network load balancing
before doing sql server clustering. Who will do it ? SQl DBA or Win Admin. (
In
Active/Passive Clustering)
A: Microsoft Clustering Services (which is a Windows component) needs to be
setup and configured before installing SQL Server on the cluster.
2) As we want to do Active/Passive clustering so there is need to
create virtual server.
A: There is always a need to create a virtual server. You applications will
use the virtual server name to connect hence making it irrelevant which node
is active at the time.
3) Is it necessary to installed ms sql server on both the servers which
are involved in clustering.
A: No. SQL Server will know you are installing on a cluster (if it's setup
correctly). You will need to have some essential information prior to
installing (like virtual server name and ip address).
4) Please give me the simle steps to start sql server clustering.
Have a look at this for step-by-step instructions (for Windows 2000/SQL
Server 2000):
http://www.sqlservercentral.com/col...pclustering.asp
"csajid@.gmail.com" wrote:

> Hi,
> First thanks for your reply.
> I already gone through the link,
> http://www.microsoft.com/technet/pr... />
g_7t9v.htm
> but i have some queries regarding both the articals,
> 1) Is it necessary to do windows clustering and network load balancing
> before doing sql server
> clustering. Who will do it ? SQl DBA or Win Admin. (In
> Active/Passive Clustering)
> 2) As we want to do Active/Passive clustering so there is need to
> create virtual server.
> 3) Is it necessary to installed ms sql server on both the servers which
> are involved in clustering.
> 4) Please give me the simle steps to start sql server clustering.
> Please reply to my queries. I am waiting for reply.
> Thanks & Regards,
> Sajid.
>
> Julie wrote:
>

Database Clustering in MS SQL SERVER.

Hi,
I want to do database clustering in ms sql server. So, Please Guide for
the same.
I am currently using ms sql server 2000 with service pack 3 installed
on it.
I already installed sql server 2000 and SP 3 on both the server where
the clustering should setup.
Thanks & Regards,
Sajid.See if this helps:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
<csajid@.gmail.com> wrote in message
news:1148976451.207722.106000@.i39g2000cwa.googlegroups.com...
Hi,
I want to do database clustering in ms sql server. So, Please Guide for
the same.
I am currently using ms sql server 2000 with service pack 3 installed
on it.
I already installed sql server 2000 and SP 3 on both the server where
the clustering should setup.
Thanks & Regards,
Sajid.|||Hello, have you read
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
?
J
"csajid@.gmail.com" wrote:
> Hi,
> I want to do database clustering in ms sql server. So, Please Guide for
> the same.
> I am currently using ms sql server 2000 with service pack 3 installed
> on it.
> I already installed sql server 2000 and SP 3 on both the server where
> the clustering should setup.
> Thanks & Regards,
> Sajid.
>|||Hi,
First thanks for your reply.
I already gone through the link,
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
&
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
but i have some queries regarding both the articals,
1) Is it necessary to do windows clustering and network load balancing
before doing sql server
clustering. Who will do it ? SQl DBA or Win Admin. (In
Active/Passive Clustering)
2) As we want to do Active/Passive clustering so there is need to
create virtual server.
3) Is it necessary to installed ms sql server on both the servers which
are involved in clustering.
4) Please give me the simle steps to start sql server clustering.
Please reply to my queries. I am waiting for reply.
Thanks & Regards,
Sajid.
Julie wrote:
> Hello, have you read
> http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
> ?
> J
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > I want to do database clustering in ms sql server. So, Please Guide for
> > the same.
> >
> > I am currently using ms sql server 2000 with service pack 3 installed
> > on it.
> >
> > I already installed sql server 2000 and SP 3 on both the server where
> > the clustering should setup.
> >
> > Thanks & Regards,
> > Sajid.
> >
> >|||1) Is it necessary to do windows clustering and network load balancing
before doing sql server clustering. Who will do it ? SQl DBA or Win Admin. (In
Active/Passive Clustering)
A: Microsoft Clustering Services (which is a Windows component) needs to be
setup and configured before installing SQL Server on the cluster.
2) As we want to do Active/Passive clustering so there is need to
create virtual server.
A: There is always a need to create a virtual server. You applications will
use the virtual server name to connect hence making it irrelevant which node
is active at the time.
3) Is it necessary to installed ms sql server on both the servers which
are involved in clustering.
A: No. SQL Server will know you are installing on a cluster (if it's setup
correctly). You will need to have some essential information prior to
installing (like virtual server name and ip address).
4) Please give me the simle steps to start sql server clustering.
Have a look at this for step-by-step instructions (for Windows 2000/SQL
Server 2000):
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
"csajid@.gmail.com" wrote:
> Hi,
> First thanks for your reply.
> I already gone through the link,
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> &
> http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
> but i have some queries regarding both the articals,
> 1) Is it necessary to do windows clustering and network load balancing
> before doing sql server
> clustering. Who will do it ? SQl DBA or Win Admin. (In
> Active/Passive Clustering)
> 2) As we want to do Active/Passive clustering so there is need to
> create virtual server.
> 3) Is it necessary to installed ms sql server on both the servers which
> are involved in clustering.
> 4) Please give me the simle steps to start sql server clustering.
> Please reply to my queries. I am waiting for reply.
> Thanks & Regards,
> Sajid.
>
> Julie wrote:
> > Hello, have you read
> > http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_clustering_7t9v.htm
> >
> > ?
> > J
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > I want to do database clustering in ms sql server. So, Please Guide for
> > > the same.
> > >
> > > I am currently using ms sql server 2000 with service pack 3 installed
> > > on it.
> > >
> > > I already installed sql server 2000 and SP 3 on both the server where
> > > the clustering should setup.
> > >
> > > Thanks & Regards,
> > > Sajid.
> > >
> > >
>sql

database backups

Hi All
I creatred a service that backups all my databases to a file on the server.
My backup software will backup the files at night. I'm having problems
backing up databases who's names are all numbers (1234, 1211, .. etc). I can
backup the databases manually but my script will always fail. Do I have to
do anything special in T-sql to access a database whos name is all numbers?
Thanks
PhilTry enclosing the database name in brackets:
BACKUP DATABASE [1234]
TO DISK='\\SomeServer\SomeShare\1234.bak'
WITH INIT
BTW, you can make things easier by having database names confirm to the
rules for regular identifiers as described in the Books Online
<acdata.chm::/ac_8_con_03_6e9e.htm>.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Phillip D Edwards" <phil@.benesysinc.com> wrote in message
news:%23FuNKzseDHA.2464@.TK2MSFTNGP09.phx.gbl...
> Hi All
> I creatred a service that backups all my databases to a file on the
server.
> My backup software will backup the files at night. I'm having problems
> backing up databases who's names are all numbers (1234, 1211, .. etc).
I can
> backup the databases manually but my script will always fail. Do I
have to
> do anything special in T-sql to access a database whos name is all
numbers?
>
> Thanks
> Phil
>
>

Database acess logscan error

HI all,

I currently have an issue trying to access my database in SQLexpress2005. Whenever i try to start the service it errors out. I looked at the error in event viewer and it says says
"The log scan number passed out to log scan in database 'master' is not valid. This error my indicate data corruption or that the ldf does not match the mdf...."

How can i fix this problem seing as though i can not access studio manager to restore the db?

Bradif possible reinstall the MS sql server express edition.I fear your master db somehow got corrupted.