Friday, February 24, 2012
Log Shipping and C;ustering
The main aim is to provide DR for 2 clusters to a single cluster located in
a seperate Datacenter.
Any input will be appreciated.
Yes. The two technologies are not mutually exclusive. Geographic
separation is not an issue with log shipping. You may find it easier to
implement a third party or home grown log shipping solution. The
implementation provided by Microsoft is good, but it may not offer all the
options you need.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Adrian56" <Adrian56@.discussions.microsoft.com> wrote in message
news:936B33BA-7C0B-4BF5-9C7F-C3DE24424809@.microsoft.com...
> Can you Implement Log Shipping between geographically dispersed clusters.
> The main aim is to provide DR for 2 clusters to a single cluster located
in
> a seperate Datacenter.
> Any input will be appreciated.
Monday, February 20, 2012
Log Shipping - switching recovery model in log shipping
Hi
I could not able to find Forums in regards to 'Log Shipping' thats why posting this question in here. Appriciate if someone can provide me answers depends on their experience.
Can we switch database recovery model when log shipping is turned on ?
We want to switch from Full Recovery to Bulk Logged Recovery to make sure Bulk Insert operations during the after hours load process will have some performance gain.
Is there any possibility of loosing data ?
Thanks
I think this will break the log chain and you may need to re-setup log-shipping.
You should try on a test system first.
Log Shipping - switching recovery model in log shipping
Hi
I could not able to find Forums in regards to 'Log Shipping' thats why posting this question in here. Appriciate if someone can provide me answers depends on their experience.
Can we switch database recovery model when log shipping is turned on ?
We want to switch from Full Recovery to Bulk Logged Recovery to make sure Bulk Insert operations during the after hours load process will have some performance gain.
Is there any possibility of loosing data ?
Thanks
I think this will break the log chain and you may need to re-setup log-shipping.
You should try on a test system first.