Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-06-17 : 14:15:17
|
| 1)i've configured logshipping, and i need fullbackup of the primary database now. will it affect the logshipping?2)i'd like to configuring logshipping and mirroring on a single database to three servers.i mean A,B,C three servers, A is primary.from A to B logshipping needed.from A to C mirroring is needed.is it possible? if so, are there anything i need to do?3) how will you monitor Mirroring in your environment?can someone help me in this regardArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-06-17 : 18:29:03
|
| Full backups do not affect log shipping, only tlog backups do. You can take tlog backups outside of the log shipping plan, but you must apply them manually to the secondary server and put it in the correct state in order not to break log shipping. The reason why full backups do not affect log shipping is that they don't impact the transaction log chain. The things that affect the chain are tlog backups and truncating the tlog.I don't know why you'd want to implement both log shipping and database mirroring, but yes that is possible.There are lots of articles out there on how to properly monitor database mirroring. There's even stuff in BOL about it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2009-06-19 : 10:57:29
|
| Hi tara,replication inconjunction with logshipping i found in internet. but i've not found the combination of log shipping and mirroring. can you please point me to a good article....sorry for taking your valuble time taraArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-06-19 : 14:17:21
|
| http://www.google.com/search?q=SQL+%22log+shipping%22+%22database+mirroring%22The first result for me is an MSDN article on database mirroring and log shipping.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
log shipping dobts