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.
> >> > > > > >
> >> > > > > >
> >> > > >
> >> > > >
> >> >
> >