The Experts below are selected from a list of 465 Experts worldwide ranked by ideXlab platform
Ken Simmons - One of the best experts on this subject based on the ideXlab platform.
-
Database Mirroring overview
2009Co-Authors: Robert L Davis, Ken SimmonsAbstract:Database Mirroring was introduced in SQL Server 2005 and provides multiple levels of protection depending on the configuration you choose for your environment. Database Mirroring is the practice of keeping two copies of your Database synchronized with each other so that if you lose one copy, you can continue work with the other. If you have ever worked with log shipping, you should be familiar with many of the concepts in Database Mirroring. In fact, Database Mirroring in its early stages was referred to as real-time log shipping or dynamic log shipping. You will see however, that Database Mirroring is a far more robust and enterprise-level solution than is log shipping. For example, prior to Database Mirroring, if you had wanted a solution that ensured zero data loss, your only option would have been failover clustering. This chapter will cover all the components that make Database Mirroring tick. Sure, you can set up Database Mirroring using a wizard and move on with life. But, since you are reading an entire book dedicated to Database Mirroring, something tells me you want to know what is going on under the hood.
-
Database Mirroring setup
2009Co-Authors: Robert L Davis, Ken SimmonsAbstract:When you set up Database Mirroring, the experience can range from the incredibly simple to the overly complex. SQL Server offers a Database Mirroring wizard to guide you through the simple setups. The wizard is quick and easy and really is the way to go when you just need to get the basics up and running.
William R Stanek - One of the best experts on this subject based on the ideXlab platform.
-
microsoft sql server 2008 administrator s pocket consultant
2001Co-Authors: William R StanekAbstract:From the author and series editor of the immensely popular ADMINISTRATOR'S POCKET CONSULTANT series from Microsoft Press-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals. Microsoft SQL Server 2008 Administrator's Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you'll want with you at all times as you deal with Microsoft SQL Server 2008 and SQL Server 2008 R2 administration. Whether you handle administration for 50 users or 5000, this hands-on, fast answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it's the portable, readable guide that you consistently save you time and minimize system downtime by giving you the right information right now. Get fast facts to:Plan, deploy, and configure SQL Server 2008 R2 Administer server and surface security, access, and network configuration Import, export, transform, and replicate data Use SQL Server Management Studio for core administrative tasks Manipulate schemas, tables, indexes, and views Automate maintenance and implement policy-based management Monitor server activity and tune performance Manage log shipping and Database Mirroring Perform backups and recovery
Robert L Davis - One of the best experts on this subject based on the ideXlab platform.
-
Database Mirroring overview
2009Co-Authors: Robert L Davis, Ken SimmonsAbstract:Database Mirroring was introduced in SQL Server 2005 and provides multiple levels of protection depending on the configuration you choose for your environment. Database Mirroring is the practice of keeping two copies of your Database synchronized with each other so that if you lose one copy, you can continue work with the other. If you have ever worked with log shipping, you should be familiar with many of the concepts in Database Mirroring. In fact, Database Mirroring in its early stages was referred to as real-time log shipping or dynamic log shipping. You will see however, that Database Mirroring is a far more robust and enterprise-level solution than is log shipping. For example, prior to Database Mirroring, if you had wanted a solution that ensured zero data loss, your only option would have been failover clustering. This chapter will cover all the components that make Database Mirroring tick. Sure, you can set up Database Mirroring using a wizard and move on with life. But, since you are reading an entire book dedicated to Database Mirroring, something tells me you want to know what is going on under the hood.
-
Database Mirroring setup
2009Co-Authors: Robert L Davis, Ken SimmonsAbstract:When you set up Database Mirroring, the experience can range from the incredibly simple to the overly complex. SQL Server offers a Database Mirroring wizard to guide you through the simple setups. The wizard is quick and easy and really is the way to go when you just need to get the basics up and running.
Yong Yang - One of the best experts on this subject based on the ideXlab platform.
-
Study on application of availability data acquisition based on Database Mirroring
2014Co-Authors: Ming Yang, Yong YangAbstract:Many businesses in the securities industry need to rely on a lot of information systems to maintain. Nowadays, with the increasing task amount in securities market, the demand of data information during operation is growing, and in order to fulfill the need for data, securities industry must analyze and process the data information. Therefore, securities enterprises' demand of data system is getting higher and higher, requiring a higher availability of data acquisition system. This article focuses on the application of securities industry commonly applied data warehouse, analyzing the defect of data acquisition by data warehouse during the operation of securities businesses. This paper makes a deep analysis of the securities company's data acquisition application, designing a new data acquisition application solution in two aspects of data acquisition task mechanism and system failover about the fault tolerance and availability research. So that the problems related to data acquisition in securities business can be solved by corresponding securities information system, and the securities business data can be analyzed and processed reasonably.
Sujoy Paul - One of the best experts on this subject based on the ideXlab platform.
-
pro sql server 2008 replication
2009Co-Authors: Sujoy PaulAbstract:Pro SQL Server 2008 Replication is for MS Database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book will also cover advanced topics like replication with heterogeneous Databases, backup and recovery of replicated Databases, Database Mirroring with replication, log shipping with replication, troubleshooting, plus optimization and tuning. Tools like tablediff, SQLCMD, DTA, SQL Profiler, and Replication Monitor will be discussed to demonstrate the different techniques used in monitoring, administering, and troubleshooting replication. Examines the detailed configuration and the internal workings of the different replication types using reallife scenarios Covers replication with Database Mirroring and troubleshooting Discusses replication administration using different tools What youll learn Configure hierarchical replication: snapshot, transactional and merge, and heterogeneous replication using reallife scenarios. Gain insight into the internal workings of the different replication types. Master the usage of different tools like tablediff, SQLCMD, DTA, and Replication Monitor in administering replication. Perform administration tasks such as backup and recovery, and manage replication with other highavailability techniques like Database Mirroring and log shipping. Conduct optimization and tuning of replicated Databases. Develop troubleshooting techniques. Who is this book for? This book is a comprehensive guide for experienced users of SQL Server as well as new users. It also aims at familiarizing the current users of SQL Server 2005 with the new features of replication should they upgrade to SQL Server 2008. This book will delve into the basics of replication like the publishersubscriber model, the different replication types (such as snapshot, transactional, merge, and heterogeneous), the corresponding architecture, implementation, and administration. Database administration tasks like backup and recovery, managing replication with highavailability techniques like Database Mirroring, log shipping with replication, optimization of replicated Databases, and troubleshooting techniques will also be discussed. This book will benefit primarily novice and intermediate users by introducing replication and the different processes and then building on the basics to develop and address the advanced features of replication. This is a musthave companion book that will help you in developing, administering and mastering the intricacies of replication. About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hardwon solutions to problems you will face in your professional programming career.
