Hi,
We are running SQL Server Failover cluster in Active/Passive mode.
Now, we want to setup DR server for this clustered database using
Log shipping.
But my concern is, can we do log shipping with clustered database ?
and the answer of this question is Yes then Please let me know How ?
Thanks & Regards,
Sajid C.
Yep...you can. Just like how you do it in a non-clustered instance. The only
problem you will have in here is if you want to be notified thru email if
your restore jobs fail as MAPI is not supported in a clustered environment.
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God has plan for
them"
"csajid@.gmail.com" wrote:
> Hi,
> We are running SQL Server Failover cluster in Active/Passive mode.
> Now, we want to setup DR server for this clustered database using
> Log shipping.
> But my concern is, can we do log shipping with clustered database ?
> and the answer of this question is Yes then Please let me know How ?
>
> Thanks & Regards,
> Sajid C.
>
|||Hi,
Thanks for your reply.
Can you please provide me some document or any link for the same.
What are the necessary steps which should i take to do this task.
Thanks & Regards,
Sajid C.
bass_player wrote:[vbcol=seagreen]
> Yep...you can. Just like how you do it in a non-clustered instance. The only
> problem you will have in here is if you want to be notified thru email if
> your restore jobs fail as MAPI is not supported in a clustered environment.
> --
> MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
> "Helping people grow and develop their full potential as God has plan for
> them"
>
> "csajid@.gmail.com" wrote:
Showing posts with label usinglog. Show all posts
Showing posts with label usinglog. Show all posts
Friday, March 30, 2012
Log Shipping with clustered database.
Hi,
We are running SQL Server Failover cluster in Active/Passive mode.
Now, we want to setup DR server for this clustered database using
Log shipping.
But my concern is, can we do log shipping with clustered database ?
and the answer of this question is Yes then Please let me know How ?
Thanks & Regards,
Sajid C.Yep...you can. Just like how you do it in a non-clustered instance. The onl
y
problem you will have in here is if you want to be notified thru email if
your restore jobs fail as MAPI is not supported in a clustered environment.
--
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God has plan for
them"
"csajid@.gmail.com" wrote:
> Hi,
> We are running SQL Server Failover cluster in Active/Passive mode.
> Now, we want to setup DR server for this clustered database using
> Log shipping.
> But my concern is, can we do log shipping with clustered database ?
> and the answer of this question is Yes then Please let me know How ?
>
> Thanks & Regards,
> Sajid C.
>|||Hi,
Thanks for your reply.
Can you please provide me some document or any link for the same.
What are the necessary steps which should i take to do this task.
Thanks & Regards,
Sajid C.
bass_player wrote:[vbcol=seagreen]
> Yep...you can. Just like how you do it in a non-clustered instance. The o
nly
> problem you will have in here is if you want to be notified thru email if
> your restore jobs fail as MAPI is not supported in a clustered environment
.
> --
> MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
> "Helping people grow and develop their full potential as God has plan for
> them"
>
> "csajid@.gmail.com" wrote:
>
We are running SQL Server Failover cluster in Active/Passive mode.
Now, we want to setup DR server for this clustered database using
Log shipping.
But my concern is, can we do log shipping with clustered database ?
and the answer of this question is Yes then Please let me know How ?
Thanks & Regards,
Sajid C.Yep...you can. Just like how you do it in a non-clustered instance. The onl
y
problem you will have in here is if you want to be notified thru email if
your restore jobs fail as MAPI is not supported in a clustered environment.
--
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God has plan for
them"
"csajid@.gmail.com" wrote:
> Hi,
> We are running SQL Server Failover cluster in Active/Passive mode.
> Now, we want to setup DR server for this clustered database using
> Log shipping.
> But my concern is, can we do log shipping with clustered database ?
> and the answer of this question is Yes then Please let me know How ?
>
> Thanks & Regards,
> Sajid C.
>|||Hi,
Thanks for your reply.
Can you please provide me some document or any link for the same.
What are the necessary steps which should i take to do this task.
Thanks & Regards,
Sajid C.
bass_player wrote:[vbcol=seagreen]
> Yep...you can. Just like how you do it in a non-clustered instance. The o
nly
> problem you will have in here is if you want to be notified thru email if
> your restore jobs fail as MAPI is not supported in a clustered environment
.
> --
> MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
> "Helping people grow and develop their full potential as God has plan for
> them"
>
> "csajid@.gmail.com" wrote:
>
Friday, February 24, 2012
Log Shipping and loading service packs
Hi All
Does anyone know if there will be any issues with
upgrading a SQL service pack on a SQL server that is using
log shipping? I want to upgrade the standby server last.
Is this order correct?
Thanks
H
Hi,
No problem, You can update the service pack in production server first and
later the stand by servers.
Thanks
Hari
MCDBA
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:743301c430ab$29489520$a501280a@.phx.gbl...
> Hi All
> Does anyone know if there will be any issues with
> upgrading a SQL service pack on a SQL server that is using
> log shipping? I want to upgrade the standby server last.
> Is this order correct?
> Thanks
> H
Does anyone know if there will be any issues with
upgrading a SQL service pack on a SQL server that is using
log shipping? I want to upgrade the standby server last.
Is this order correct?
Thanks
H
Hi,
No problem, You can update the service pack in production server first and
later the stand by servers.
Thanks
Hari
MCDBA
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:743301c430ab$29489520$a501280a@.phx.gbl...
> Hi All
> Does anyone know if there will be any issues with
> upgrading a SQL service pack on a SQL server that is using
> log shipping? I want to upgrade the standby server last.
> Is this order correct?
> Thanks
> H
Log Shipping and loading service packs
Hi All
Does anyone know if there will be any issues with
upgrading a SQL service pack on a SQL server that is using
log shipping? I want to upgrade the standby server last.
Is this order correct?
Thanks
HHi,
No problem, You can update the service pack in production server first and
later the stand by servers.
Thanks
Hari
MCDBA
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:743301c430ab$29489520$a501280a@.phx.gbl...
> Hi All
> Does anyone know if there will be any issues with
> upgrading a SQL service pack on a SQL server that is using
> log shipping? I want to upgrade the standby server last.
> Is this order correct?
> Thanks
> H
Does anyone know if there will be any issues with
upgrading a SQL service pack on a SQL server that is using
log shipping? I want to upgrade the standby server last.
Is this order correct?
Thanks
HHi,
No problem, You can update the service pack in production server first and
later the stand by servers.
Thanks
Hari
MCDBA
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:743301c430ab$29489520$a501280a@.phx.gbl...
> Hi All
> Does anyone know if there will be any issues with
> upgrading a SQL service pack on a SQL server that is using
> log shipping? I want to upgrade the standby server last.
> Is this order correct?
> Thanks
> H
Subscribe to:
Posts (Atom)