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