I can be reached at email@example.com
or by phone at 954.360.1141
Student from class 6231B. Please add a link to top SQL sites\blogs that you have found beneficial to managing\scripting. One stop shopping for SQL giants. Thanks
In a high availability scenario can we mirror two SQL 2008 database servers and use the secondary server for other SQL Server instances that get log shipping from the primary server’s databases that are mirrored?
Mirroring is per database, not database instance. The only INSTANCE level high availability is SQL clustering.
At the database level, you can combine mirroring and log shipping, see http://msdn.microsoft.com/en-us/library/ms187016.aspx
Depending on what you’re trying to accomplish, you may want to investigate SQL 2012 AlwaysOn, the upgrade may give you capabilities that justify the upgrade cost.
In SQL Server 2008 Standard can the chart says in will only do a single thread mirror. What exactly does that mean? One database? One CPU? One instance?
One per database, see http://sqlcat.com/sqlcat/b/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx
Could you recommend a good book on SQL replication? Thanks for the replies to my other questions.
I should ask if you want a general introduction or have a particular problem to solve. As far as a book, well….
I learned about replication online, there are really good resources out there. The best?
I’ve learned more from this website than any other source.
Also The Microsoft SQL Escalation Team has an awesome blog, really good focus on troubleshooting and understanding errors:
If I stop at 3 resources, I’d need to include SQLBits. Click on the ‘Content’ link on the left, then search for replication. Or ANYTHING SQL related.
Thanks for the reply. I was looking for a good overall book on SQL Server 2008 R2 that had the best information about replication. I have a book called Profession Microsoft SQL Server 2008 Administration by WROX publishing that has a decent section on it. It is kind of out of date though. I believe you are right though I have found the websites to be much more targeted and up to date on the subject. Thanks for the links.
Your email address will not be published. Required fields are marked *