June 9, 2011 at 12:37 pm
Hi
i need to setup a DR setup for database
it may be either mirroring or logshipping.
here is the scenario:
TL backups happens every 1 hr, so mirror comes to sync in every hour.
but the client need to be sync at for every 4 hrs.
so which one is suggestable mirroring or logshipping.
Thanks
June 9, 2011 at 2:37 pm
check books online for differences between the two. Mirroring is a constant replication of the database, whereby log shipping is a set of scheduled operations consisting of a backup at the source and a copy and restore at the destination. Both are detailed at length in BOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 13, 2011 at 3:31 am
for DR side I recommend database Mirroring ,how much data loss you can bare
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 13, 2011 at 4:18 am
Good and valid replies so far.
Actually it is YOU who needs to elaborate on data loss for your business clients !
You would need to suppose they have no knowledge what data loss is and how much they can afford !
They will always go for cheap, not knowing the consequences !
I always prepare both alternatives, as well regarding data loss, as well regarding application needs at DR time !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply