July 15, 2009 at 3:38 pm
Hi,
I just want to know how all other DBA's approach in configuring log shipping in SQL Server 2005.
1.Do you use Separate Monitor server for Monitoring Log shipping?
2.How big the performance will impact if we do not use separate server for Moinitoring?
3.If we do not have separate Monitoring server, which will act as Monitor server? Primary or Secondary? How will we know that?
4. Do you guys use separate Network share for Keeping the Transaction logs or Local to Primary server? which one is prefered and why?
5.Do you configured Log shipping in clustered environment? what are differences in configuring logshipping in Standalone and Cluster environment?
thanks
July 17, 2009 at 11:52 am
Hi,
Could you please give me some info on above questions..
thanks
July 17, 2009 at 1:01 pm
Mani (7/15/2009)
Hi,I just want to know how all other DBA's approach in configuring log shipping in SQL Server 2005.
1.Do you use Separate Monitor server for Monitoring Log shipping?
2.How big the performance will impact if we do not use separate server for Moinitoring?
3.If we do not have separate Monitoring server, which will act as Monitor server? Primary or Secondary? How will we know that?
4. Do you guys use separate Network share for Keeping the Transaction logs or Local to Primary server? which one is prefered and why?
5.Do you configured Log shipping in clustered environment? what are differences in configuring logshipping in Standalone and Cluster environment?
thanks
In my Company:
1. No. It's useless.
2. no performance impact since it's only using msdb.
3. Modify sql jobs on both servers to email you on failures and use server level report "Transaction Log Shipping Status"
4.Yes. Share on primary for backup of logs. Share on Secondary for copied logs from Primary.
5. No difference as long as you have #4 configured correctly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply