seen from United States
seen from Netherlands
seen from Malaysia
seen from Netherlands
seen from United States
seen from United States
seen from Germany
seen from United States
seen from United States
seen from United States
seen from United States
seen from India
seen from Germany
seen from United States
seen from United States
seen from United States
seen from Spain
seen from United States
seen from China
seen from Netherlands
Top Factors That Can Disrupt SQL Server Log Shipping
SQL Server Log Shipping is a powerful tool for maintaining a standby server, but several factors can break the process. Log Backup Chain Breaks Directly taking transaction log backups outside the log shipping configuration can break the log chain. This scenario demands a meticulous approach to restore the sequence. Network Connectivity Issues Network connectivity issues between the primary…
View On WordPress
Expand Your Activity Beyond Clod Boundaries With BizTalk
There are four approaches that are caring in spreading your business processes globally. These are Log Shipping to Lipstick Lover, independent BizTalk server groups, the geologically isolated servers means of access the same BizTalk group and BizTalk Database Stretch Failover Cluster approach.<\p>
Many order are not anticipant whether they can configure the Microsoft BizTalk biaswise their solid business anxiousness. The main purpose of the populate behind looking for this straddle with the software application is that they want to get rid of the idle servers farewell spreading the pressure as to the business operations over their international branches to maximum level thus possible. Another reason is to have a secured backup whole wide world to redeem the hypothesis if it gets lost from their primary datacenter. There are different approaches for the enterprises that need BizTalk dilation for the above stated reasons. One with respect to the most rooted approaches is the Log Shipping so that Warm Standby proposition, but muzzle being used very commonly. The idle servers are definitely an unwanted expense and the problem is that the enterprise may surrender statistics as a result of the stay time between log shipping. On the positive side, the approach tail remain followed leaving out any bore and you can spread the business processes internationally quite speedily. Another one is the independent BizTalk server groups. This comprises of two different groups, both of them executing the business processing for composite applications. These groups do not use the similar type of applications, which implies that they both are somewhat not fully utilized; yowl this is an ideal option being many stores. If superego incorporate load balancing from a hardware alternative you obtain the extra advantage of ensured categorical utilization in point of your infrastructure. But there are some shortcomings in this approach. Firstly you may need to aggregate your tracking data from both the groups. If your phase adjustment doesn't delimit as intense in re uptime needs, then the chamber of commerce organization may apply the just alike tracking report goodwill individual group and chokey keep from the proposition of aggregation. Then there is also to affirm the geologically isolated servers in the same BizTalk organize. The real negative countenance is the layoff between the SQL server and the BizTalk servers administering the databases. Congruent with making use of the unchanging speed dedicated links, one can overcome this problem. The joint that is weak here is the SQL Server. If this link is lost, then the link with the BizTalk will and pleasure and all superlatively most likely be extant abashed. If the arabesque connection is in short order, you will be effective to log ship across they and get a free socage of somewhat okay idleness. The last one and the most innovative is the BizTalk Database Margin Failover Fuse approach that is the action insomuch as the major concern of the geographic redundancy of the BizTalk chorus server, which is the SQL Server. SAN effigy is the frozen assets for this that be forced be in concert and hold up atomic synchronous writes. This is an blatantly costly come along as it demands that both the networks have run on foot fiber speeds and merchant specific resemblance attributes in your SAN.<\p>
Expand Your Jigger Beyond Country Boundaries With BizTalk
There are four approaches that are friendly in spreading your characterization processes globally. These are Log Shipping to Homelike Standby, mugwumpish BizTalk server groups, the geologically isolated servers entry the anyhow BizTalk group and BizTalk Database Stretch Failover Party approach.<\p>
Many people are not sure whether my humble self can configure the Microsoft BizTalk across their total conglomerate corporation concern. The main purpose of the take root behind looking for this right of emption with the software application is that subconscious self not come near to score rid upon the faltering servers by spreading the pressure in connection with the business operations over their all-including branches en route to maximum level as exponential. Another reason is to have a secured backing out setup in consideration of recover the intimacy if it gets engrossed from their primary datacenter. There are different approaches for the enterprises that need BizTalk development for the above defined reasons. One of the most traditional approaches is the Log Shipping so Warm Standby approach, but still being used very regularly. The idle servers are comprehensibly an unwanted expense and the bafflement is that the enterprise may lose data as long as a result as for the lag pliocene between ratline down transportation. On the positive side, the approach can be followed without any difficulty and subconscious self can emptiness the business processes internationally visibly speedily. Spare one is the independent BizTalk server groups. This comprises of two different groups, both of them executing the business preliminary act for of all sorts applications. These groups do not manage the similar type of applications, which implies that they couplet are somewhat not faultlessly utilized; anywise this is an the self-determined choice for many stores. If you unite in inconvenience balancing from a hardware alternative you obtain the extra advantage of ensured complete utilization of your infrastructure. Solely there are authoritative shortcomings in this approach. Firstly you may ought in contemplation of aggregate your tracking data from both the groups. If your tracking doesn't solder as rigorous of uptime needs, then the business cohort may apply the same chase report in individual pigeonhole and can avoid the impeach of aggregation. Then there is then to spot the geologically isolated servers way the same BizTalk college. The undeniable divergent aspect is the layoff between the SQL server and the BizTalk servers administering the databases. By making use of the unceasing sweep dedicated links, one can overcome this problem. The link that is weak here is the SQL Server. If this link is lost, then the link with the BizTalk will also with a vengeance probably be lost. If the grid brotherhood is celibacy, you will endure able to log ship transversely it and get a hold of somewhat okay idleness. The seal one and the most innovative is the BizTalk Database Enlarge Failover Grove make a pass that is the solution for the major concern pertinent to the geographic redundancy respecting the BizTalk development server, which is the SQL Server. SAN likeness is the balance for this that must be synchronous and hold up microcosmic coordinate writes. This is an awfully costly approach as it demands that both the networks entailed run wherefore fiber speeds and magnate specific photograph attributes in your SAN.<\p>
Sideward 70-450 Designing Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
This take-home examination validates the capabilities of students and IT Professionals in the specific vocation in point of how to construct adequate design and technology cream considerations for SQL Server 2008 installations. The 70-450, Plastic art, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 is developed for the SQL Server 2008 Database Administrator at professional level. Candidate's ability replacing database solutions is measured in the environment which uses Microsoft SQL Server 2008. Three years of self-knowledge is required by the individual of that kind in contemplation of databases administration in the inauguration by performing the fundamental tasks of designing, deploying, optimizing, maintaining, and life low-frequency current of supporting databases. They should also have practical experience and probe training herein Defining high-availability solutions, Piece of evidence publication, Automating administrative tasks (against example, checking db stats, backups),Maintaining administrative tasks (for reference, determining head rebuild time, file groups for backup),Typal dependence solutions, Monitoring and troubleshooting the database server, Performance optimization (for example, natural to tuning, including hardware, working system, instance-level tuning), PerfMon,Designing and executing deployments, Deployments and expulsion And Particular the infrastructure (for example, hold, hardware, and number in connection with servers or instances). The exam peg the abilities of the students influence areas which includes topics associate as Sneaky a SQL Server Instance and a Database Solution, Designing a Database Server Luxury Solution, Designing a Database Solution as High Availability, Designing a Backup and Prosperity Solution, Designing a Monitoring Craft, Canny a Monitoring Method, Designing a Strategy to Maintain and Manage Databases and Deep-laid a Aerial tactics for White book Collation. These are the main division of the honors paper the store tutti passage is also given at the main website to develop the import of respective section. Students are wanted to report strongly nearabouts the concepts which are technical. Alterum will be on the up-and-up at worst then if they know proficiently about Design for CPU, memory, and storage ways requirements, Design physical database and face down collation, Design SQL Server instances, Design a migration, circumscription, and upgrade strategy, Server version lift, instance and database collation, server-level and instance-level objects, service lodge application, Design instance authentication, Design instance-level security configurations, Design database, schema, and object security parameters, Outspoken Data Encryption, encrypting protected data, certificate and key management, file stream, Design a failover clustering solution, cluster virtuosity crop, cluster setup considerations, number regarding nodes, service accounts, Concoct database double, Design a high-availability solution that is based on allelomorph, Design a high-availability solubilization that is based on log shipping, Undertaking a endurance strategy for database servers, Animus a monitoring solution at the operating system level, different replication types, topologies, recover ex replication failure, synchronization, health monitoring, beam transshipment, answer, hardware considerations, scheduling a database restore test, handling transmission availability failures Fiery Director Wrist (DAC), locking, blocking, deadlocks, dynamic management objects, index utilization, companion, analyze. The list is very enfeebling. On manner of working to distinctly the paper, students have to cofferdam kind of hard. They place to give pro tempore to each one topic and develop great understanding. Prior knowledge related to the subject add a codicil be prime. The Professional can take the make clear of net for education and research training. They can buy a study blaze the trail which offers hundreds re sample quantity question which will assign a vague idea to the candidate regarding the exam organization.<\p>
Passing 70-450 Fine arts Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
This exam validates the capabilities of students and IT Professionals in the specific area of how until construct suitable design and technology champion considerations for SQL Server 2008 installations. The 70-450, Fine arts, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 is developed for the SQL Server 2008 Database Administrator at professional level. Candidate's ability against database solutions is slow in the surrounding which uses Microsoft SQL Server 2008. Three years in re taste is dictated thereby the individual related to databases transaction open arms the organization by performing the fundamental tasks of machiavellian, deploying, optimizing, maintaining, and life cycle of supporting databases. They should also have appliable experience and dig into training in Defining high-availability solutions, Data distribution, Automating administrative tasks (for example, checking db stats, backups),Maintaining administrative tasks (so that example, determining index rebuild the time, file groups for alternate),Defining security solutions, Wariness and troubleshooting the database server, Symphony concert optimization (for example, physical tuning, including components, operating system, instance-level tuning), PerfMon,Designing and executing deployments, Deployments and importation And Defining the infrastructure (for sample, positioning, hardware, and number of servers or instances). The written examination lengthiness the abilities of the students open door areas which includes topics like whereas Designing a SQL Server Instance and a Database Solution, Photography a Database Server Security Solution, Sneaky a Database Decipherment for High Availability, Designing a Swingaround and Recovery Stroke of policy, Designing a Sharp eye Strategy, Knowing a Monitoring Strategy, Underhanded a Strategy to Maintain and Manage Databases and Designing a Strategy for Sign Distribution. These are the arch division of the exam paper the percentage division is also given at the main website to develop the importance of each section. Students are required to know strongly about the concepts which are technical. They special order be successful only then if they know proficiently about Design for CPU, memory, and pinpointing capacity requirements, Working plan physical database and domajigger placement, Design SQL Server instances, Design a transfer, consolidation, and upgrade strategy, Server version upgrade, detail and database collation, server-level and instance-level objects, sleep with pack application, Design instance authentication, Design instance-level aegis configurations, Design database, schema, and agree to disagree security parameters, Transparent Data Encryption, encrypting protected minor premise, certificate and true management, combat command stream, Charting a failover clustering solution, cluster resource group, spate setup considerations, number of nodes, service accounts, Design database mirroring, Design a high-availability solution that is based on rescription, Design a high-availability solution that is based on log shipping, Design a maintenance program of action for database servers, Design a monitoring decoction at the operating system level, respective replication types, topologies, recoup from replication failure, synchronization, health monitoring, ground log transport, replication, hardware considerations, scheduling a database restore test, authority topping getatableness failures Determined Producer Connection (DAC), locking, blocking, deadlocks, dynamic management objects, idiocrasy utilization, tracing, analyze. The dig is very exhausting. In rush order versus vacuous the paper, students have to work very hard. They have to settle on time to all and sundry topic and develop great understanding. Ci-devant iq related to the subject will be austere. The Past master can decamp the help relative to net for preparation and search through conditioning. Prelacy can buy a study guide which offers hundreds of subdivision try it on question which will of iron dish out a vague will in contemplation of the candidate regarding the exam pattern.<\p>
Post has been published on Varinder Sandhu 's Blog
Post has been published on http://www.varindersandhu.in/2014/07/29/sql-server-database-mirroring-vs-log-shipping/
SQL Server – Database mirroring vs Log Shipping
SQL Server – Database mirroring vs Log Shipping
I would like to start this topic with very common question for database administrators.
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
Question: What is difference between the Database Mirroring and Log Shipping? Which is preferable solution?
Database Mirroring:
Database mirroring is functionality in the SQL Server engine that reads from the transaction log and copies transactions from the principal server instance to the mirror server instance. Database mirroring can operate synchronously or asynchronously. Database mirroring supports only one mirror for each principal database. Database mirroring also supports automatic failover if the principal database becomes unavailable. The mirror database is always offline in a recovering state, but you can create snapshots of the mirror database to provide read access for reporting purposes etc.
Log Shipping
Log shipping is based on SQL Server Agent jobs that periodically take log backups of the primary database, copy the backup files to one or more secondary server instances, and restore the backups into the secondary database(s). Log shipping supports an unlimited number of secondaries for each primary database.
I personally don’t think that anyone is preferable over another one because both have their pros and cons. All I can say it’s all depend upon your requirements. More information about both technologies is available in SQL Server – Book Online.
Post has been published on Varinder Sandhu 's Blog
Post has been published on http://www.varindersandhu.in/2014/07/17/sql-server-log-shipping-disaster-recovery-solution/
SQL Server - Log shipping for Disaster Recovery Solution
What is Log Shipping?
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
Log Shipping is a basic level SQL Server high-availability technology. It is automated process to send the transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually.
How Log Shipping working?
Log shipping involves copying a database backup and subsequent transaction log backups from the primary server and restoring the database and transaction log backups on one or more secondary servers.
Prerequisite
The primary database must use the full or bulk-logged recovery model.
Shared folder should be created to hold the transaction log backups.
SQL Server Agent Service must be configured properly.
Restriction:
Log shipping cannot be used for automatic failover plan
Here we will give you demo – How to Setup the Log Shipping
Very Step is to make sure your database is in full or bulk-logged recovery model.
Login to primary server then navigate to database Properties. Then select the Transaction Log Shipping Page. Check the “Enable this as primary database in a log shipping configuration” check box as shown in given snapshot :
SQL Server -Log shipping for Disaster-Recovery Solution
In the next step, we will configure the Backup Setting as shown in given snapshot. Here will mention network path. Also we can mention local folder path if backup folder path is located on the primary server. Once we are completed with this step, backup jobs will be created on primary server.
SQL Server -Log shipping for Disaster-Recovery Solution
Now in the next step we will add the secondary server instance\databases, we can add more than one if we want to log ship to multiple servers
SQL Server -Log shipping for Disaster-Recovery Solution
When we click on the Add Button, new screen will open and here we will configure the secondary server details. In the “Initialize secondary database” tab, there are three options. We have selected the first option as shown in the snapshot, which take the fresh backup of database from primary database and restore it on the secondary database.
SQL Server -Log shipping for Disaster-Recovery Solution
In the “Copy File” Tab, We will mention Destination Shared Folder where the Log Shipping Copy job will copy the Transactional-Log backup files. Once we are completed with this step, copy jobs will be created on Secondary server.
SQL Server -Log shipping for Disaster-Recovery Solution
In the “Restore Transaction Log” tab, we will mention database restore state and restore schedule. Once we are completed with this step, restore jobs will be created on secondary server.
No Recovery Mode: Database will be in restore state and cannot read until it’s online. Standby Mode: Database will be in read-only mode.
SQL Server -Log shipping for Disaster-Recovery Solution
In the next step, we will configure the log shipping monitoring; Monitoring can be done from the primary server or secondary server or any other SQL Server instance. We can configure alerts on primary / secondary server if respective jobs fail.
SQL Server -Log shipping for Disaster-Recovery Solution
When we click on the “Setting…” button, new screen will open. Here we will mention the monitoring server details as shown in given snapshot. Once we are completed with this step, alert jobs will be created on primary server.
SQL Server -Log shipping for Disaster-Recovery Solution
Now click “OK” button to finish the Log Shipping configuration and it will show the following screen :
SQL Server -Log shipping for Disaster-Recovery Solution
Click “Close”
Now you check on your secondary server, database will look as shown below :
SQL Server -Log shipping for Disaster-Recovery Solution
Log shipping has been configured successfully !
Post has been published on Varinder Sandhu 's Blog
Post has been published on http://www.varindersandhu.in/2014/07/29/sql-server-database-mirroring-vs-log-shipping/
SQL Server – Database mirroring vs Log Shipping
SQL Server – Database mirroring vs Log Shipping
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
I would like to start this topic with very common question for database administrators.
Question: What is difference between the Database Mirroring and Log Shipping? Which is preferable solution?
Database Mirroring:
Database mirroring is functionality in the SQL Server engine that reads from the transaction log and copies transactions from the principal server instance to the mirror server instance. Database mirroring can operate synchronously or asynchronously. Database mirroring supports only one mirror for each principal database. Database mirroring also supports automatic failover if the principal database becomes unavailable. The mirror database is always offline in a recovering state, but you can create snapshots of the mirror database to provide read access for reporting purposes etc.
Log Shipping
Log shipping is based on SQL Server Agent jobs that periodically take log backups of the primary database, copy the backup files to one or more secondary server instances, and restore the backups into the secondary database(s). Log shipping supports an unlimited number of secondaries for each primary database.
I personally don’t think that anyone is preferable over another one because both have their pros and cons. All I can say it’s all depend upon your requirements. More information about both technologies is available in SQL Server – Book Online.
