November 2008
Intermediate to advanced
910 pages
27h 16m
English
book
Professional Microsoft® SQL Server® 2008 Administration
by Brian Knight, Ketan Patel, Wayne Snyder, Ross LoForte, Steven Wort
Content preview from Professional Microsoft® SQL Server® 2008 Administration
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
17.4. Preparing the Mirror Server for Failover
When you set up mirroring, your intentions are clear that in the event of failover, the mirror takes on the full load. In order for the mirror to be fully functional as a principal, you have to do some configurations on the mirror server. Please note that database mirroring is a database-to-database failover solution only; the entire SQL Server instance is not mirrored. If you want to implement full SQL Server instance failover, then consider Windows failover clustering. We compare different high-availability technologies in the section "Database Mirroring and Other High-Availability Solutions."
17.4.1. Hardware, Software, and Server Configuration
Your mirror server hardware should be identical (CPU, memory, storage, and network capacity) to that of the principal if you want your mirror server to handle the same load as your principal. You may argue that if your principal is a 16-way, 64-bit server with 32GB of RAM, having identical mirror hardware is a costly solution if your principal is not going down often and such expensive hardware is sitting idle. If your application is not critical, then you may want to have a smaller server just for failover and taking the load for some time, but I would argue that if the application is not that critical, you do not have such extensive hardware on the primary either.
Moreover, with such huge hardware, the process on the server must be very heavy, so if you failover, your mirror should be ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.