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:
>
Showing posts with label clustering. Show all posts
Showing posts with label clustering. Show all posts
Tuesday, March 27, 2012
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
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 Clustering
Dear Guys.
Can you guys help me regarding Database Server Clustering and Database
server federation
Thanks
NOOR
Sure. What is the problem? You might want to post any clustering related
problems to .clustering group. sql-server-performance.com has clustering
related content. Books Online and KB have a lot of information on clustering
too.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Noor" <noor@.ngsol.com> wrote in message
news:OxgLR7phEHA.3148@.TK2MSFTNGP10.phx.gbl...
Dear Guys.
Can you guys help me regarding Database Server Clustering and Database
server federation
Thanks
NOOR
|||Thanks Narayana but can you give me some real world example like where we
have to use Database Server Clustering and Database server federation
Thanks
NOOR
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:ekcbvEqhEHA.712@.tk2msftngp13.phx.gbl...
> Sure. What is the problem? You might want to post any clustering related
> problems to .clustering group. sql-server-performance.com has clustering
> related content. Books Online and KB have a lot of information on
clustering
> too.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Noor" <noor@.ngsol.com> wrote in message
> news:OxgLR7phEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Dear Guys.
> Can you guys help me regarding Database Server Clustering and Database
> server federation
> Thanks
> NOOR
>
>
|||Clustering is used for ensuring high availability of SQL Server, while
fererations are meant for distributed processing, to improve performance.
See "Failover Clustering" in SQL Server 2000 Books Online. Also see
"Designing Federated Database Servers" in Books Online.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Noor" <noor@.ngsol.com> wrote in message
news:eF6Q0uqhEHA.2764@.TK2MSFTNGP11.phx.gbl...
Thanks Narayana but can you give me some real world example like where we
have to use Database Server Clustering and Database server federation
Thanks
NOOR
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:ekcbvEqhEHA.712@.tk2msftngp13.phx.gbl...
> Sure. What is the problem? You might want to post any clustering related
> problems to .clustering group. sql-server-performance.com has clustering
> related content. Books Online and KB have a lot of information on
clustering
> too.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Noor" <noor@.ngsol.com> wrote in message
> news:OxgLR7phEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Dear Guys.
> Can you guys help me regarding Database Server Clustering and Database
> server federation
> Thanks
> NOOR
>
>
Can you guys help me regarding Database Server Clustering and Database
server federation
Thanks
NOOR
Sure. What is the problem? You might want to post any clustering related
problems to .clustering group. sql-server-performance.com has clustering
related content. Books Online and KB have a lot of information on clustering
too.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Noor" <noor@.ngsol.com> wrote in message
news:OxgLR7phEHA.3148@.TK2MSFTNGP10.phx.gbl...
Dear Guys.
Can you guys help me regarding Database Server Clustering and Database
server federation
Thanks
NOOR
|||Thanks Narayana but can you give me some real world example like where we
have to use Database Server Clustering and Database server federation
Thanks
NOOR
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:ekcbvEqhEHA.712@.tk2msftngp13.phx.gbl...
> Sure. What is the problem? You might want to post any clustering related
> problems to .clustering group. sql-server-performance.com has clustering
> related content. Books Online and KB have a lot of information on
clustering
> too.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Noor" <noor@.ngsol.com> wrote in message
> news:OxgLR7phEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Dear Guys.
> Can you guys help me regarding Database Server Clustering and Database
> server federation
> Thanks
> NOOR
>
>
|||Clustering is used for ensuring high availability of SQL Server, while
fererations are meant for distributed processing, to improve performance.
See "Failover Clustering" in SQL Server 2000 Books Online. Also see
"Designing Federated Database Servers" in Books Online.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Noor" <noor@.ngsol.com> wrote in message
news:eF6Q0uqhEHA.2764@.TK2MSFTNGP11.phx.gbl...
Thanks Narayana but can you give me some real world example like where we
have to use Database Server Clustering and Database server federation
Thanks
NOOR
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:ekcbvEqhEHA.712@.tk2msftngp13.phx.gbl...
> Sure. What is the problem? You might want to post any clustering related
> problems to .clustering group. sql-server-performance.com has clustering
> related content. Books Online and KB have a lot of information on
clustering
> too.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Noor" <noor@.ngsol.com> wrote in message
> news:OxgLR7phEHA.3148@.TK2MSFTNGP10.phx.gbl...
> Dear Guys.
> Can you guys help me regarding Database Server Clustering and Database
> server federation
> Thanks
> NOOR
>
>
Thursday, March 22, 2012
Database Backup in SQL Server failover Clustering.
Hi,
I have done MS SQL Server failover clustering with SQL Server 2000
as
One Active node and one Passive Node.
I have set G: drive as a Clustered Drive where Database Files are
placed.
Now i want to take a backup of the database locally on Non-Clustered
Disk .
Is it possible to do this. If yes then please let me know How?
Please give me reply.
Thanks & Regards,
Sajid N. Chhapekar.yes it is possible like any other backup
"csajid@.gmail.com" wrote:
> Hi,
> I have done MS SQL Server failover clustering with SQL Server 2000
> as
> One Active node and one Passive Node.
> I have set G: drive as a Clustered Drive where Database Files are
> placed.
> Now i want to take a backup of the database locally on Non-Clustered
> Disk .
> Is it possible to do this. If yes then please let me know How?
> Please give me reply.
> Thanks & Regards,
> Sajid N. Chhapekar.
>|||Hi,
Thanks for your reply.
I have create a backup job which will take a full database backup
at 9:00 PM every night.
But my concern here is that, the backup will happened on local disk
of node which is online but if that node goes offline then the backup
will happened on another node which is online or not.
this is my please reply to this as it is production issue.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:
> yes it is possible like any other backup
>
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > I have done MS SQL Server failover clustering with SQL Server 2000
> > as
> > One Active node and one Passive Node.
> > I have set G: drive as a Clustered Drive where Database Files are
> > placed.
> > Now i want to take a backup of the database locally on Non-Clustered
> > Disk .
> > Is it possible to do this. If yes then please let me know How?
> >
> > Please give me reply.
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> >
> >|||I am not quite sure I understand what you are asking, but I'll try to
respond.
I assume you have your data files on your G:\ drive which is a shared drive
that is accessible to the cluster and part of a cluster group.
You want to backup your database to a local drive other than that g:\ drive.
So you want to back up to a non-shared drive such as the c:\ drive?
I would not suggest that. I would suggest that you backup your databases to
a separate shared array that is clustered and in your cluster group.
HTH
Mike Walsh
SQL Server DBA
mwalsh9815(nospam-at-)gmail
<csajid@.gmail.com> wrote in message
news:1151137838.512224.314790@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>> yes it is possible like any other backup
>>
>> "csajid@.gmail.com" wrote:
>> > Hi,
>> >
>> > I have done MS SQL Server failover clustering with SQL Server 2000
>> > as
>> > One Active node and one Passive Node.
>> > I have set G: drive as a Clustered Drive where Database Files are
>> > placed.
>> > Now i want to take a backup of the database locally on Non-Clustered
>> > Disk .
>> > Is it possible to do this. If yes then please let me know How?
>> >
>> > Please give me reply.
>> >
>> > Thanks & Regards,
>> > Sajid N. Chhapekar.
>> >
>> >
>|||do not use your backup strategy for production.
if first node go offline, your backup go offline too
create backup on cluster disk group
--
Aleksandar Grbic
"csajid@.gmail.com" wrote:
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
> > yes it is possible like any other backup
> >
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > I have done MS SQL Server failover clustering with SQL Server 2000
> > > as
> > > One Active node and one Passive Node.
> > > I have set G: drive as a Clustered Drive where Database Files are
> > > placed.
> > > Now i want to take a backup of the database locally on Non-Clustered
> > > Disk .
> > > Is it possible to do this. If yes then please let me know How?
> > >
> > > Please give me reply.
> > >
> > > Thanks & Regards,
> > > Sajid N. Chhapekar.
> > >
> > >
>|||Hi,
Thanks for your reply.
you mean to say that, if my Node goes offline then my backup will
not switch to the
node which is online.
If yes, then is there any way to take a backup on Local disk as my
seniors want to
do this.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:
> do not use your backup strategy for production.
> if first node go offline, your backup go offline too
> create backup on cluster disk group
> --
> Aleksandar Grbic
>
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > Thanks for your reply.
> >
> > I have create a backup job which will take a full database backup
> > at 9:00 PM every night.
> > But my concern here is that, the backup will happened on local disk
> > of node which is online but if that node goes offline then the backup
> > will happened on another node which is online or not.
> > this is my please reply to this as it is production issue.
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> > Aleksandar Grbic wrote:
> > > yes it is possible like any other backup
> > >
> > >
> > > "csajid@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > I have done MS SQL Server failover clustering with SQL Server 2000
> > > > as
> > > > One Active node and one Passive Node.
> > > > I have set G: drive as a Clustered Drive where Database Files are
> > > > placed.
> > > > Now i want to take a backup of the database locally on Non-Clustered
> > > > Disk .
> > > > Is it possible to do this. If yes then please let me know How?
> > > >
> > > > Please give me reply.
> > > >
> > > > Thanks & Regards,
> > > > Sajid N. Chhapekar.
> > > >
> > > >
> >
> >|||<csajid@.gmail.com> wrote in message
news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> Hi,
> Thanks for your reply.
> you mean to say that, if my Node goes offline then my backup will
> not switch to the
> node which is online.
> If yes, then is there any way to take a backup on Local disk as my
> seniors want to
> do this.
If the backup job points to say C:\backup, it should always save it to the
local C: drive of the active node.
If you always want it to a specific node, create a share and use the UNC
path: \\node2\backup.
However, I wouldn't do this OR to another disk on the cluster.
I'd backup to a disk on a separate machine. For example, we've got a Snap
4200 that we backup to a UNC on.
> Thanks & Regards,
> Sajid N. Chhapekar.
>
> Aleksandar Grbic wrote:
> > do not use your backup strategy for production.
> > if first node go offline, your backup go offline too
> >
> > create backup on cluster disk group
> > --
> > Aleksandar Grbic
> >
> >
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Thanks for your reply.
> > >
> > > I have create a backup job which will take a full database backup
> > > at 9:00 PM every night.
> > > But my concern here is that, the backup will happened on local
disk
> > > of node which is online but if that node goes offline then the backup
> > > will happened on another node which is online or not.
> > > this is my please reply to this as it is production issue.
> > >
> > > Thanks & Regards,
> > > Sajid N. Chhapekar.
> > > Aleksandar Grbic wrote:
> > > > yes it is possible like any other backup
> > > >
> > > >
> > > > "csajid@.gmail.com" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I have done MS SQL Server failover clustering with SQL Server
2000
> > > > > as
> > > > > One Active node and one Passive Node.
> > > > > I have set G: drive as a Clustered Drive where Database Files
are
> > > > > placed.
> > > > > Now i want to take a backup of the database locally on
Non-Clustered
> > > > > Disk .
> > > > > Is it possible to do this. If yes then please let me know How?
> > > > >
> > > > > Please give me reply.
> > > > >
> > > > > Thanks & Regards,
> > > > > Sajid N. Chhapekar.
> > > > >
> > > > >
> > >
> > >
>|||Hi,
Thanks for your reply.
Now, i try to make it more simple.
I have to nodes in a Active/Passive Cluster.
Where node A is Passive and Node B is Active.
I have same drive on both the nodes that is, C: D: E: Q: and G:
where G: is clustered
disk & Of course here Q: is Quorum disk.
Here i schedule daily backup on E: drive, which is same location
on both the nodes.
as my node B is active the backup is pointing to E: drive of node
B.
Now my point here is if my node B becomes Passive and node A
active then backup
will point to E: drive of Node A or it fails.
Thanks & Regards,
Sajid N.Chhapekar.
Greg D. Moore (Strider) wrote:
> <csajid@.gmail.com> wrote in message
> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> > Hi,
> >
> > Thanks for your reply.
> > you mean to say that, if my Node goes offline then my backup will
> > not switch to the
> > node which is online.
> > If yes, then is there any way to take a backup on Local disk as my
> > seniors want to
> > do this.
> If the backup job points to say C:\backup, it should always save it to the
> local C: drive of the active node.
> If you always want it to a specific node, create a share and use the UNC
> path: \\node2\backup.
> However, I wouldn't do this OR to another disk on the cluster.
> I'd backup to a disk on a separate machine. For example, we've got a Snap
> 4200 that we backup to a UNC on.
>
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> >
> >
> > Aleksandar Grbic wrote:
> > > do not use your backup strategy for production.
> > > if first node go offline, your backup go offline too
> > >
> > > create backup on cluster disk group
> > > --
> > > Aleksandar Grbic
> > >
> > >
> > >
> > > "csajid@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > Thanks for your reply.
> > > >
> > > > I have create a backup job which will take a full database backup
> > > > at 9:00 PM every night.
> > > > But my concern here is that, the backup will happened on local
> disk
> > > > of node which is online but if that node goes offline then the backup
> > > > will happened on another node which is online or not.
> > > > this is my please reply to this as it is production issue.
> > > >
> > > > Thanks & Regards,
> > > > Sajid N. Chhapekar.
> > > > Aleksandar Grbic wrote:
> > > > > yes it is possible like any other backup
> > > > >
> > > > >
> > > > > "csajid@.gmail.com" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I have done MS SQL Server failover clustering with SQL Server
> 2000
> > > > > > as
> > > > > > One Active node and one Passive Node.
> > > > > > I have set G: drive as a Clustered Drive where Database Files
> are
> > > > > > placed.
> > > > > > Now i want to take a backup of the database locally on
> Non-Clustered
> > > > > > Disk .
> > > > > > Is it possible to do this. If yes then please let me know How?
> > > > > >
> > > > > > Please give me reply.
> > > > > >
> > > > > > Thanks & Regards,
> > > > > > Sajid N. Chhapekar.
> > > > > >
> > > > > >
> > > >
> > > >
> >|||You really should have the backup on shared (clustered) disks, not local disks. Say that E: is a
local disk which exists on both node A and B. The backups will work fine, and store the backup file
on the local drive (which one depends on what node is the active node). The database engine doesn't
really know or care whether it is clustered, it just sees a number of drives.
But here's a scenario which might make you re-consider:
Node A does backup locally.
It then fails, and you also have to do a restore.
Node B is started and you cannot get to the backup file produced by node A, because that node has
failed and stored the backup locally.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1151484909.281425.75170@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> Now, i try to make it more simple.
> I have to nodes in a Active/Passive Cluster.
> Where node A is Passive and Node B is Active.
> I have same drive on both the nodes that is, C: D: E: Q: and G:
> where G: is clustered
> disk & Of course here Q: is Quorum disk.
> Here i schedule daily backup on E: drive, which is same location
> on both the nodes.
> as my node B is active the backup is pointing to E: drive of node
> B.
> Now my point here is if my node B becomes Passive and node A
> active then backup
> will point to E: drive of Node A or it fails.
> Thanks & Regards,
> Sajid N.Chhapekar.
> Greg D. Moore (Strider) wrote:
>> <csajid@.gmail.com> wrote in message
>> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
>> > Hi,
>> >
>> > Thanks for your reply.
>> > you mean to say that, if my Node goes offline then my backup will
>> > not switch to the
>> > node which is online.
>> > If yes, then is there any way to take a backup on Local disk as my
>> > seniors want to
>> > do this.
>> If the backup job points to say C:\backup, it should always save it to the
>> local C: drive of the active node.
>> If you always want it to a specific node, create a share and use the UNC
>> path: \\node2\backup.
>> However, I wouldn't do this OR to another disk on the cluster.
>> I'd backup to a disk on a separate machine. For example, we've got a Snap
>> 4200 that we backup to a UNC on.
>>
>> >
>> > Thanks & Regards,
>> > Sajid N. Chhapekar.
>> >
>> >
>> > Aleksandar Grbic wrote:
>> > > do not use your backup strategy for production.
>> > > if first node go offline, your backup go offline too
>> > >
>> > > create backup on cluster disk group
>> > > --
>> > > Aleksandar Grbic
>> > >
>> > >
>> > >
>> > > "csajid@.gmail.com" wrote:
>> > >
>> > > > Hi,
>> > > >
>> > > > Thanks for your reply.
>> > > >
>> > > > I have create a backup job which will take a full database backup
>> > > > at 9:00 PM every night.
>> > > > But my concern here is that, the backup will happened on local
>> disk
>> > > > of node which is online but if that node goes offline then the backup
>> > > > will happened on another node which is online or not.
>> > > > this is my please reply to this as it is production issue.
>> > > >
>> > > > Thanks & Regards,
>> > > > Sajid N. Chhapekar.
>> > > > Aleksandar Grbic wrote:
>> > > > > yes it is possible like any other backup
>> > > > >
>> > > > >
>> > > > > "csajid@.gmail.com" wrote:
>> > > > >
>> > > > > > Hi,
>> > > > > >
>> > > > > > I have done MS SQL Server failover clustering with SQL Server
>> 2000
>> > > > > > as
>> > > > > > One Active node and one Passive Node.
>> > > > > > I have set G: drive as a Clustered Drive where Database Files
>> are
>> > > > > > placed.
>> > > > > > Now i want to take a backup of the database locally on
>> Non-Clustered
>> > > > > > Disk .
>> > > > > > Is it possible to do this. If yes then please let me know How?
>> > > > > >
>> > > > > > Please give me reply.
>> > > > > >
>> > > > > > Thanks & Regards,
>> > > > > > Sajid N. Chhapekar.
>> > > > > >
>> > > > > >
>> > > >
>> > > >
>> >
>|||Hi,
Thanks for reply.
I understand what u are trying to say.
In this case, as we have windows backup stratergy which backup the
the folder where backup file is stored.
So, that if one node fails where backup file is stored, we can get
it from backup tape.
Thanks & Regards,
Sajid N. Chhapekar.
Tibor Karaszi wrote:
> You really should have the backup on shared (clustered) disks, not local disks. Say that E: is a
> local disk which exists on both node A and B. The backups will work fine, and store the backup file
> on the local drive (which one depends on what node is the active node). The database engine doesn't
> really know or care whether it is clustered, it just sees a number of drives.
> But here's a scenario which might make you re-consider:
> Node A does backup locally.
> It then fails, and you also have to do a restore.
> Node B is started and you cannot get to the backup file produced by node A, because that node has
> failed and stored the backup locally.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <csajid@.gmail.com> wrote in message news:1151484909.281425.75170@.p79g2000cwp.googlegroups.com...
> > Hi,
> >
> > Thanks for your reply.
> >
> > Now, i try to make it more simple.
> > I have to nodes in a Active/Passive Cluster.
> > Where node A is Passive and Node B is Active.
> > I have same drive on both the nodes that is, C: D: E: Q: and G:
> > where G: is clustered
> > disk & Of course here Q: is Quorum disk.
> > Here i schedule daily backup on E: drive, which is same location
> > on both the nodes.
> > as my node B is active the backup is pointing to E: drive of node
> > B.
> > Now my point here is if my node B becomes Passive and node A
> > active then backup
> > will point to E: drive of Node A or it fails.
> >
> > Thanks & Regards,
> > Sajid N.Chhapekar.
> >
> > Greg D. Moore (Strider) wrote:
> >> <csajid@.gmail.com> wrote in message
> >> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> >> > Hi,
> >> >
> >> > Thanks for your reply.
> >> > you mean to say that, if my Node goes offline then my backup will
> >> > not switch to the
> >> > node which is online.
> >> > If yes, then is there any way to take a backup on Local disk as my
> >> > seniors want to
> >> > do this.
> >>
> >> If the backup job points to say C:\backup, it should always save it to the
> >> local C: drive of the active node.
> >>
> >> If you always want it to a specific node, create a share and use the UNC
> >> path: \\node2\backup.
> >>
> >> However, I wouldn't do this OR to another disk on the cluster.
> >>
> >> I'd backup to a disk on a separate machine. For example, we've got a Snap
> >> 4200 that we backup to a UNC on.
> >>
> >>
> >> >
> >> > Thanks & Regards,
> >> > Sajid N. Chhapekar.
> >> >
> >> >
> >> > Aleksandar Grbic wrote:
> >> > > do not use your backup strategy for production.
> >> > > if first node go offline, your backup go offline too
> >> > >
> >> > > create backup on cluster disk group
> >> > > --
> >> > > Aleksandar Grbic
> >> > >
> >> > >
> >> > >
> >> > > "csajid@.gmail.com" wrote:
> >> > >
> >> > > > Hi,
> >> > > >
> >> > > > Thanks for your reply.
> >> > > >
> >> > > > I have create a backup job which will take a full database backup
> >> > > > at 9:00 PM every night.
> >> > > > But my concern here is that, the backup will happened on local
> >> disk
> >> > > > of node which is online but if that node goes offline then the backup
> >> > > > will happened on another node which is online or not.
> >> > > > this is my please reply to this as it is production issue.
> >> > > >
> >> > > > Thanks & Regards,
> >> > > > Sajid N. Chhapekar.
> >> > > > Aleksandar Grbic wrote:
> >> > > > > yes it is possible like any other backup
> >> > > > >
> >> > > > >
> >> > > > > "csajid@.gmail.com" wrote:
> >> > > > >
> >> > > > > > Hi,
> >> > > > > >
> >> > > > > > I have done MS SQL Server failover clustering with SQL Server
> >> 2000
> >> > > > > > as
> >> > > > > > One Active node and one Passive Node.
> >> > > > > > I have set G: drive as a Clustered Drive where Database Files
> >> are
> >> > > > > > placed.
> >> > > > > > Now i want to take a backup of the database locally on
> >> Non-Clustered
> >> > > > > > Disk .
> >> > > > > > Is it possible to do this. If yes then please let me know How?
> >> > > > > >
> >> > > > > > Please give me reply.
> >> > > > > >
> >> > > > > > Thanks & Regards,
> >> > > > > > Sajid N. Chhapekar.
> >> > > > > >
> >> > > > > >
> >> > > >
> >> > > >
> >> >
> >
I have done MS SQL Server failover clustering with SQL Server 2000
as
One Active node and one Passive Node.
I have set G: drive as a Clustered Drive where Database Files are
placed.
Now i want to take a backup of the database locally on Non-Clustered
Disk .
Is it possible to do this. If yes then please let me know How?
Please give me reply.
Thanks & Regards,
Sajid N. Chhapekar.yes it is possible like any other backup
"csajid@.gmail.com" wrote:
> Hi,
> I have done MS SQL Server failover clustering with SQL Server 2000
> as
> One Active node and one Passive Node.
> I have set G: drive as a Clustered Drive where Database Files are
> placed.
> Now i want to take a backup of the database locally on Non-Clustered
> Disk .
> Is it possible to do this. If yes then please let me know How?
> Please give me reply.
> Thanks & Regards,
> Sajid N. Chhapekar.
>|||Hi,
Thanks for your reply.
I have create a backup job which will take a full database backup
at 9:00 PM every night.
But my concern here is that, the backup will happened on local disk
of node which is online but if that node goes offline then the backup
will happened on another node which is online or not.
this is my please reply to this as it is production issue.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:
> yes it is possible like any other backup
>
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > I have done MS SQL Server failover clustering with SQL Server 2000
> > as
> > One Active node and one Passive Node.
> > I have set G: drive as a Clustered Drive where Database Files are
> > placed.
> > Now i want to take a backup of the database locally on Non-Clustered
> > Disk .
> > Is it possible to do this. If yes then please let me know How?
> >
> > Please give me reply.
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> >
> >|||I am not quite sure I understand what you are asking, but I'll try to
respond.
I assume you have your data files on your G:\ drive which is a shared drive
that is accessible to the cluster and part of a cluster group.
You want to backup your database to a local drive other than that g:\ drive.
So you want to back up to a non-shared drive such as the c:\ drive?
I would not suggest that. I would suggest that you backup your databases to
a separate shared array that is clustered and in your cluster group.
HTH
Mike Walsh
SQL Server DBA
mwalsh9815(nospam-at-)gmail
<csajid@.gmail.com> wrote in message
news:1151137838.512224.314790@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>> yes it is possible like any other backup
>>
>> "csajid@.gmail.com" wrote:
>> > Hi,
>> >
>> > I have done MS SQL Server failover clustering with SQL Server 2000
>> > as
>> > One Active node and one Passive Node.
>> > I have set G: drive as a Clustered Drive where Database Files are
>> > placed.
>> > Now i want to take a backup of the database locally on Non-Clustered
>> > Disk .
>> > Is it possible to do this. If yes then please let me know How?
>> >
>> > Please give me reply.
>> >
>> > Thanks & Regards,
>> > Sajid N. Chhapekar.
>> >
>> >
>|||do not use your backup strategy for production.
if first node go offline, your backup go offline too
create backup on cluster disk group
--
Aleksandar Grbic
"csajid@.gmail.com" wrote:
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
> > yes it is possible like any other backup
> >
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > I have done MS SQL Server failover clustering with SQL Server 2000
> > > as
> > > One Active node and one Passive Node.
> > > I have set G: drive as a Clustered Drive where Database Files are
> > > placed.
> > > Now i want to take a backup of the database locally on Non-Clustered
> > > Disk .
> > > Is it possible to do this. If yes then please let me know How?
> > >
> > > Please give me reply.
> > >
> > > Thanks & Regards,
> > > Sajid N. Chhapekar.
> > >
> > >
>|||Hi,
Thanks for your reply.
you mean to say that, if my Node goes offline then my backup will
not switch to the
node which is online.
If yes, then is there any way to take a backup on Local disk as my
seniors want to
do this.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:
> do not use your backup strategy for production.
> if first node go offline, your backup go offline too
> create backup on cluster disk group
> --
> Aleksandar Grbic
>
> "csajid@.gmail.com" wrote:
> > Hi,
> >
> > Thanks for your reply.
> >
> > I have create a backup job which will take a full database backup
> > at 9:00 PM every night.
> > But my concern here is that, the backup will happened on local disk
> > of node which is online but if that node goes offline then the backup
> > will happened on another node which is online or not.
> > this is my please reply to this as it is production issue.
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> > Aleksandar Grbic wrote:
> > > yes it is possible like any other backup
> > >
> > >
> > > "csajid@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > I have done MS SQL Server failover clustering with SQL Server 2000
> > > > as
> > > > One Active node and one Passive Node.
> > > > I have set G: drive as a Clustered Drive where Database Files are
> > > > placed.
> > > > Now i want to take a backup of the database locally on Non-Clustered
> > > > Disk .
> > > > Is it possible to do this. If yes then please let me know How?
> > > >
> > > > Please give me reply.
> > > >
> > > > Thanks & Regards,
> > > > Sajid N. Chhapekar.
> > > >
> > > >
> >
> >|||<csajid@.gmail.com> wrote in message
news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> Hi,
> Thanks for your reply.
> you mean to say that, if my Node goes offline then my backup will
> not switch to the
> node which is online.
> If yes, then is there any way to take a backup on Local disk as my
> seniors want to
> do this.
If the backup job points to say C:\backup, it should always save it to the
local C: drive of the active node.
If you always want it to a specific node, create a share and use the UNC
path: \\node2\backup.
However, I wouldn't do this OR to another disk on the cluster.
I'd backup to a disk on a separate machine. For example, we've got a Snap
4200 that we backup to a UNC on.
> Thanks & Regards,
> Sajid N. Chhapekar.
>
> Aleksandar Grbic wrote:
> > do not use your backup strategy for production.
> > if first node go offline, your backup go offline too
> >
> > create backup on cluster disk group
> > --
> > Aleksandar Grbic
> >
> >
> >
> > "csajid@.gmail.com" wrote:
> >
> > > Hi,
> > >
> > > Thanks for your reply.
> > >
> > > I have create a backup job which will take a full database backup
> > > at 9:00 PM every night.
> > > But my concern here is that, the backup will happened on local
disk
> > > of node which is online but if that node goes offline then the backup
> > > will happened on another node which is online or not.
> > > this is my please reply to this as it is production issue.
> > >
> > > Thanks & Regards,
> > > Sajid N. Chhapekar.
> > > Aleksandar Grbic wrote:
> > > > yes it is possible like any other backup
> > > >
> > > >
> > > > "csajid@.gmail.com" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I have done MS SQL Server failover clustering with SQL Server
2000
> > > > > as
> > > > > One Active node and one Passive Node.
> > > > > I have set G: drive as a Clustered Drive where Database Files
are
> > > > > placed.
> > > > > Now i want to take a backup of the database locally on
Non-Clustered
> > > > > Disk .
> > > > > Is it possible to do this. If yes then please let me know How?
> > > > >
> > > > > Please give me reply.
> > > > >
> > > > > Thanks & Regards,
> > > > > Sajid N. Chhapekar.
> > > > >
> > > > >
> > >
> > >
>|||Hi,
Thanks for your reply.
Now, i try to make it more simple.
I have to nodes in a Active/Passive Cluster.
Where node A is Passive and Node B is Active.
I have same drive on both the nodes that is, C: D: E: Q: and G:
where G: is clustered
disk & Of course here Q: is Quorum disk.
Here i schedule daily backup on E: drive, which is same location
on both the nodes.
as my node B is active the backup is pointing to E: drive of node
B.
Now my point here is if my node B becomes Passive and node A
active then backup
will point to E: drive of Node A or it fails.
Thanks & Regards,
Sajid N.Chhapekar.
Greg D. Moore (Strider) wrote:
> <csajid@.gmail.com> wrote in message
> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> > Hi,
> >
> > Thanks for your reply.
> > you mean to say that, if my Node goes offline then my backup will
> > not switch to the
> > node which is online.
> > If yes, then is there any way to take a backup on Local disk as my
> > seniors want to
> > do this.
> If the backup job points to say C:\backup, it should always save it to the
> local C: drive of the active node.
> If you always want it to a specific node, create a share and use the UNC
> path: \\node2\backup.
> However, I wouldn't do this OR to another disk on the cluster.
> I'd backup to a disk on a separate machine. For example, we've got a Snap
> 4200 that we backup to a UNC on.
>
> >
> > Thanks & Regards,
> > Sajid N. Chhapekar.
> >
> >
> > Aleksandar Grbic wrote:
> > > do not use your backup strategy for production.
> > > if first node go offline, your backup go offline too
> > >
> > > create backup on cluster disk group
> > > --
> > > Aleksandar Grbic
> > >
> > >
> > >
> > > "csajid@.gmail.com" wrote:
> > >
> > > > Hi,
> > > >
> > > > Thanks for your reply.
> > > >
> > > > I have create a backup job which will take a full database backup
> > > > at 9:00 PM every night.
> > > > But my concern here is that, the backup will happened on local
> disk
> > > > of node which is online but if that node goes offline then the backup
> > > > will happened on another node which is online or not.
> > > > this is my please reply to this as it is production issue.
> > > >
> > > > Thanks & Regards,
> > > > Sajid N. Chhapekar.
> > > > Aleksandar Grbic wrote:
> > > > > yes it is possible like any other backup
> > > > >
> > > > >
> > > > > "csajid@.gmail.com" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I have done MS SQL Server failover clustering with SQL Server
> 2000
> > > > > > as
> > > > > > One Active node and one Passive Node.
> > > > > > I have set G: drive as a Clustered Drive where Database Files
> are
> > > > > > placed.
> > > > > > Now i want to take a backup of the database locally on
> Non-Clustered
> > > > > > Disk .
> > > > > > Is it possible to do this. If yes then please let me know How?
> > > > > >
> > > > > > Please give me reply.
> > > > > >
> > > > > > Thanks & Regards,
> > > > > > Sajid N. Chhapekar.
> > > > > >
> > > > > >
> > > >
> > > >
> >|||You really should have the backup on shared (clustered) disks, not local disks. Say that E: is a
local disk which exists on both node A and B. The backups will work fine, and store the backup file
on the local drive (which one depends on what node is the active node). The database engine doesn't
really know or care whether it is clustered, it just sees a number of drives.
But here's a scenario which might make you re-consider:
Node A does backup locally.
It then fails, and you also have to do a restore.
Node B is started and you cannot get to the backup file produced by node A, because that node has
failed and stored the backup locally.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1151484909.281425.75170@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> Now, i try to make it more simple.
> I have to nodes in a Active/Passive Cluster.
> Where node A is Passive and Node B is Active.
> I have same drive on both the nodes that is, C: D: E: Q: and G:
> where G: is clustered
> disk & Of course here Q: is Quorum disk.
> Here i schedule daily backup on E: drive, which is same location
> on both the nodes.
> as my node B is active the backup is pointing to E: drive of node
> B.
> Now my point here is if my node B becomes Passive and node A
> active then backup
> will point to E: drive of Node A or it fails.
> Thanks & Regards,
> Sajid N.Chhapekar.
> Greg D. Moore (Strider) wrote:
>> <csajid@.gmail.com> wrote in message
>> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
>> > Hi,
>> >
>> > Thanks for your reply.
>> > you mean to say that, if my Node goes offline then my backup will
>> > not switch to the
>> > node which is online.
>> > If yes, then is there any way to take a backup on Local disk as my
>> > seniors want to
>> > do this.
>> If the backup job points to say C:\backup, it should always save it to the
>> local C: drive of the active node.
>> If you always want it to a specific node, create a share and use the UNC
>> path: \\node2\backup.
>> However, I wouldn't do this OR to another disk on the cluster.
>> I'd backup to a disk on a separate machine. For example, we've got a Snap
>> 4200 that we backup to a UNC on.
>>
>> >
>> > Thanks & Regards,
>> > Sajid N. Chhapekar.
>> >
>> >
>> > Aleksandar Grbic wrote:
>> > > do not use your backup strategy for production.
>> > > if first node go offline, your backup go offline too
>> > >
>> > > create backup on cluster disk group
>> > > --
>> > > Aleksandar Grbic
>> > >
>> > >
>> > >
>> > > "csajid@.gmail.com" wrote:
>> > >
>> > > > Hi,
>> > > >
>> > > > Thanks for your reply.
>> > > >
>> > > > I have create a backup job which will take a full database backup
>> > > > at 9:00 PM every night.
>> > > > But my concern here is that, the backup will happened on local
>> disk
>> > > > of node which is online but if that node goes offline then the backup
>> > > > will happened on another node which is online or not.
>> > > > this is my please reply to this as it is production issue.
>> > > >
>> > > > Thanks & Regards,
>> > > > Sajid N. Chhapekar.
>> > > > Aleksandar Grbic wrote:
>> > > > > yes it is possible like any other backup
>> > > > >
>> > > > >
>> > > > > "csajid@.gmail.com" wrote:
>> > > > >
>> > > > > > Hi,
>> > > > > >
>> > > > > > I have done MS SQL Server failover clustering with SQL Server
>> 2000
>> > > > > > as
>> > > > > > One Active node and one Passive Node.
>> > > > > > I have set G: drive as a Clustered Drive where Database Files
>> are
>> > > > > > placed.
>> > > > > > Now i want to take a backup of the database locally on
>> Non-Clustered
>> > > > > > Disk .
>> > > > > > Is it possible to do this. If yes then please let me know How?
>> > > > > >
>> > > > > > Please give me reply.
>> > > > > >
>> > > > > > Thanks & Regards,
>> > > > > > Sajid N. Chhapekar.
>> > > > > >
>> > > > > >
>> > > >
>> > > >
>> >
>|||Hi,
Thanks for reply.
I understand what u are trying to say.
In this case, as we have windows backup stratergy which backup the
the folder where backup file is stored.
So, that if one node fails where backup file is stored, we can get
it from backup tape.
Thanks & Regards,
Sajid N. Chhapekar.
Tibor Karaszi wrote:
> You really should have the backup on shared (clustered) disks, not local disks. Say that E: is a
> local disk which exists on both node A and B. The backups will work fine, and store the backup file
> on the local drive (which one depends on what node is the active node). The database engine doesn't
> really know or care whether it is clustered, it just sees a number of drives.
> But here's a scenario which might make you re-consider:
> Node A does backup locally.
> It then fails, and you also have to do a restore.
> Node B is started and you cannot get to the backup file produced by node A, because that node has
> failed and stored the backup locally.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <csajid@.gmail.com> wrote in message news:1151484909.281425.75170@.p79g2000cwp.googlegroups.com...
> > Hi,
> >
> > Thanks for your reply.
> >
> > Now, i try to make it more simple.
> > I have to nodes in a Active/Passive Cluster.
> > Where node A is Passive and Node B is Active.
> > I have same drive on both the nodes that is, C: D: E: Q: and G:
> > where G: is clustered
> > disk & Of course here Q: is Quorum disk.
> > Here i schedule daily backup on E: drive, which is same location
> > on both the nodes.
> > as my node B is active the backup is pointing to E: drive of node
> > B.
> > Now my point here is if my node B becomes Passive and node A
> > active then backup
> > will point to E: drive of Node A or it fails.
> >
> > Thanks & Regards,
> > Sajid N.Chhapekar.
> >
> > Greg D. Moore (Strider) wrote:
> >> <csajid@.gmail.com> wrote in message
> >> news:1151397825.548700.255990@.b68g2000cwa.googlegroups.com...
> >> > Hi,
> >> >
> >> > Thanks for your reply.
> >> > you mean to say that, if my Node goes offline then my backup will
> >> > not switch to the
> >> > node which is online.
> >> > If yes, then is there any way to take a backup on Local disk as my
> >> > seniors want to
> >> > do this.
> >>
> >> If the backup job points to say C:\backup, it should always save it to the
> >> local C: drive of the active node.
> >>
> >> If you always want it to a specific node, create a share and use the UNC
> >> path: \\node2\backup.
> >>
> >> However, I wouldn't do this OR to another disk on the cluster.
> >>
> >> I'd backup to a disk on a separate machine. For example, we've got a Snap
> >> 4200 that we backup to a UNC on.
> >>
> >>
> >> >
> >> > Thanks & Regards,
> >> > Sajid N. Chhapekar.
> >> >
> >> >
> >> > Aleksandar Grbic wrote:
> >> > > do not use your backup strategy for production.
> >> > > if first node go offline, your backup go offline too
> >> > >
> >> > > create backup on cluster disk group
> >> > > --
> >> > > Aleksandar Grbic
> >> > >
> >> > >
> >> > >
> >> > > "csajid@.gmail.com" wrote:
> >> > >
> >> > > > Hi,
> >> > > >
> >> > > > Thanks for your reply.
> >> > > >
> >> > > > I have create a backup job which will take a full database backup
> >> > > > at 9:00 PM every night.
> >> > > > But my concern here is that, the backup will happened on local
> >> disk
> >> > > > of node which is online but if that node goes offline then the backup
> >> > > > will happened on another node which is online or not.
> >> > > > this is my please reply to this as it is production issue.
> >> > > >
> >> > > > Thanks & Regards,
> >> > > > Sajid N. Chhapekar.
> >> > > > Aleksandar Grbic wrote:
> >> > > > > yes it is possible like any other backup
> >> > > > >
> >> > > > >
> >> > > > > "csajid@.gmail.com" wrote:
> >> > > > >
> >> > > > > > Hi,
> >> > > > > >
> >> > > > > > I have done MS SQL Server failover clustering with SQL Server
> >> 2000
> >> > > > > > as
> >> > > > > > One Active node and one Passive Node.
> >> > > > > > I have set G: drive as a Clustered Drive where Database Files
> >> are
> >> > > > > > placed.
> >> > > > > > Now i want to take a backup of the database locally on
> >> Non-Clustered
> >> > > > > > Disk .
> >> > > > > > Is it possible to do this. If yes then please let me know How?
> >> > > > > >
> >> > > > > > Please give me reply.
> >> > > > > >
> >> > > > > > Thanks & Regards,
> >> > > > > > Sajid N. Chhapekar.
> >> > > > > >
> >> > > > > >
> >> > > >
> >> > > >
> >> >
> >
Database Backup in SQL Server failover Clustering.
yes it is possible like any other backup
"csajid@.gmail.com" wrote:
> Hi,
> I have done MS SQL Server failover clustering with SQL Server 2000
> as
> One Active node and one Passive Node.
> I have set G: drive as a Clustered Drive where Database Files are
> placed.
> Now i want to take a backup of the database locally on Non-Clustered
> Disk .
> Is it possible to do this. If yes then please let me know How?
> Please give me reply.
> Thanks & Regards,
> Sajid N. Chhapekar.
>Hi,
I have done MS SQL Server failover clustering with SQL Server 2000
as
One Active node and one Passive Node.
I have set G: drive as a Clustered Drive where Database Files are
placed.
Now i want to take a backup of the database locally on Non-Clustered
Disk .
Is it possible to do this. If yes then please let me know How?
Please give me reply.
Thanks & Regards,
Sajid N. Chhapekar.|||yes it is possible like any other backup
"csajid@.gmail.com" wrote:
> Hi,
> I have done MS SQL Server failover clustering with SQL Server 2000
> as
> One Active node and one Passive Node.
> I have set G: drive as a Clustered Drive where Database Files are
> placed.
> Now i want to take a backup of the database locally on Non-Clustered
> Disk .
> Is it possible to do this. If yes then please let me know How?
> Please give me reply.
> Thanks & Regards,
> Sajid N. Chhapekar.
>|||Hi,
Thanks for your reply.
I have create a backup job which will take a full database backup
at 9:00 PM every night.
But my concern here is that, the backup will happened on local disk
of node which is online but if that node goes offline then the backup
will happened on another node which is online or not.
this is my please reply to this as it is production issue.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:[vbcol=seagreen]
> yes it is possible like any other backup
>
> "csajid@.gmail.com" wrote:
>|||Hi,
Thanks for your reply.
I have create a backup job which will take a full database backup
at 9:00 PM every night.
But my concern here is that, the backup will happened on local disk
of node which is online but if that node goes offline then the backup
will happened on another node which is online or not.
this is my please reply to this as it is production issue.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:[vbcol=seagreen]
> yes it is possible like any other backup
>
> "csajid@.gmail.com" wrote:
>|||I am not quite sure I understand what you are asking, but I'll try to
respond.
I assume you have your data files on your G:\ drive which is a shared drive
that is accessible to the cluster and part of a cluster group.
You want to backup your database to a local drive other than that g:\ drive.
So you want to back up to a non-shared drive such as the c:\ drive?
I would not suggest that. I would suggest that you backup your databases to
a separate shared array that is clustered and in your cluster group.
HTH
Mike Walsh
SQL Server DBA
mwalsh9815(nospam-at-)gmail
<csajid@.gmail.com> wrote in message
news:1151137838.512224.314790@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>|||I am not quite sure I understand what you are asking, but I'll try to
respond.
I assume you have your data files on your G:\ drive which is a shared drive
that is accessible to the cluster and part of a cluster group.
You want to backup your database to a local drive other than that g:\ drive.
So you want to back up to a non-shared drive such as the c:\ drive?
I would not suggest that. I would suggest that you backup your databases to
a separate shared array that is clustered and in your cluster group.
HTH
Mike Walsh
SQL Server DBA
mwalsh9815(nospam-at-)gmail
<csajid@.gmail.com> wrote in message
news:1151137838.512224.314790@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>|||do not use your backup strategy for production.
if first node go offline, your backup go offline too
create backup on cluster disk group
--
Aleksandar Grbic
"csajid@.gmail.com" wrote:
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>|||do not use your backup strategy for production.
if first node go offline, your backup go offline too
create backup on cluster disk group
--
Aleksandar Grbic
"csajid@.gmail.com" wrote:
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>|||Hi,
Thanks for your reply.
you mean to say that, if my Node goes offline then my backup will
not switch to the
node which is online.
If yes, then is there any way to take a backup on Local disk as my
seniors want to
do this.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:[vbcol=seagreen]
> do not use your backup strategy for production.
> if first node go offline, your backup go offline too
> create backup on cluster disk group
> --
> Aleksandar Grbic
>
> "csajid@.gmail.com" wrote:
>sql
"csajid@.gmail.com" wrote:
> Hi,
> I have done MS SQL Server failover clustering with SQL Server 2000
> as
> One Active node and one Passive Node.
> I have set G: drive as a Clustered Drive where Database Files are
> placed.
> Now i want to take a backup of the database locally on Non-Clustered
> Disk .
> Is it possible to do this. If yes then please let me know How?
> Please give me reply.
> Thanks & Regards,
> Sajid N. Chhapekar.
>Hi,
I have done MS SQL Server failover clustering with SQL Server 2000
as
One Active node and one Passive Node.
I have set G: drive as a Clustered Drive where Database Files are
placed.
Now i want to take a backup of the database locally on Non-Clustered
Disk .
Is it possible to do this. If yes then please let me know How?
Please give me reply.
Thanks & Regards,
Sajid N. Chhapekar.|||yes it is possible like any other backup
"csajid@.gmail.com" wrote:
> Hi,
> I have done MS SQL Server failover clustering with SQL Server 2000
> as
> One Active node and one Passive Node.
> I have set G: drive as a Clustered Drive where Database Files are
> placed.
> Now i want to take a backup of the database locally on Non-Clustered
> Disk .
> Is it possible to do this. If yes then please let me know How?
> Please give me reply.
> Thanks & Regards,
> Sajid N. Chhapekar.
>|||Hi,
Thanks for your reply.
I have create a backup job which will take a full database backup
at 9:00 PM every night.
But my concern here is that, the backup will happened on local disk
of node which is online but if that node goes offline then the backup
will happened on another node which is online or not.
this is my please reply to this as it is production issue.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:[vbcol=seagreen]
> yes it is possible like any other backup
>
> "csajid@.gmail.com" wrote:
>|||Hi,
Thanks for your reply.
I have create a backup job which will take a full database backup
at 9:00 PM every night.
But my concern here is that, the backup will happened on local disk
of node which is online but if that node goes offline then the backup
will happened on another node which is online or not.
this is my please reply to this as it is production issue.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:[vbcol=seagreen]
> yes it is possible like any other backup
>
> "csajid@.gmail.com" wrote:
>|||I am not quite sure I understand what you are asking, but I'll try to
respond.
I assume you have your data files on your G:\ drive which is a shared drive
that is accessible to the cluster and part of a cluster group.
You want to backup your database to a local drive other than that g:\ drive.
So you want to back up to a non-shared drive such as the c:\ drive?
I would not suggest that. I would suggest that you backup your databases to
a separate shared array that is clustered and in your cluster group.
HTH
Mike Walsh
SQL Server DBA
mwalsh9815(nospam-at-)gmail
<csajid@.gmail.com> wrote in message
news:1151137838.512224.314790@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>|||I am not quite sure I understand what you are asking, but I'll try to
respond.
I assume you have your data files on your G:\ drive which is a shared drive
that is accessible to the cluster and part of a cluster group.
You want to backup your database to a local drive other than that g:\ drive.
So you want to back up to a non-shared drive such as the c:\ drive?
I would not suggest that. I would suggest that you backup your databases to
a separate shared array that is clustered and in your cluster group.
HTH
Mike Walsh
SQL Server DBA
mwalsh9815(nospam-at-)gmail
<csajid@.gmail.com> wrote in message
news:1151137838.512224.314790@.p79g2000cwp.googlegroups.com...
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>|||do not use your backup strategy for production.
if first node go offline, your backup go offline too
create backup on cluster disk group
--
Aleksandar Grbic
"csajid@.gmail.com" wrote:
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>|||do not use your backup strategy for production.
if first node go offline, your backup go offline too
create backup on cluster disk group
--
Aleksandar Grbic
"csajid@.gmail.com" wrote:
> Hi,
> Thanks for your reply.
> I have create a backup job which will take a full database backup
> at 9:00 PM every night.
> But my concern here is that, the backup will happened on local disk
> of node which is online but if that node goes offline then the backup
> will happened on another node which is online or not.
> this is my please reply to this as it is production issue.
> Thanks & Regards,
> Sajid N. Chhapekar.
> Aleksandar Grbic wrote:
>|||Hi,
Thanks for your reply.
you mean to say that, if my Node goes offline then my backup will
not switch to the
node which is online.
If yes, then is there any way to take a backup on Local disk as my
seniors want to
do this.
Thanks & Regards,
Sajid N. Chhapekar.
Aleksandar Grbic wrote:[vbcol=seagreen]
> do not use your backup strategy for production.
> if first node go offline, your backup go offline too
> create backup on cluster disk group
> --
> Aleksandar Grbic
>
> "csajid@.gmail.com" wrote:
>sql
Subscribe to:
Posts (Atom)