Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Mirroring Rss

   Items 1 to 11 of 11   
 

Mirror Partner Agent Job To Auto Kick Back to Primary

Query the mirror instance via agent job to auto kick back to primary. If db is in suspended state will resume mirroring.  Read more...
By Ryan Loftin 2016/01/05 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 375 reads

Mirroring Automation

Automating the Mirroring configuration for new databases  Read more...
By Vasan Balu 2015/11/16 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 1,032 reads

Database Mirroring Setup Procedure generator

A script that generates all the commands for installing a new database mirroring between two servers  Read more...
By Jefferson Elias 2015/03/20 | Source: SQLServerCentral.com | Category: mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 873 reads

Database Mirroring Setup Procedure generator

A script that generates all the commands for installing a new database mirroring between two servers  Read more...
By Jefferson Elias 2015/03/17 | Source: SQLServerCentral.com | Category: mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 127 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2015/02/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,533 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 4

This is Part 4 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.  Read more...
By Perry Whittle 2014/05/20 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 3,591 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 3

Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.  Read more...
By Perry Whittle 2014/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 3,426 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 2

This is Part 2 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.  Read more...
By Perry Whittle 2014/03/06 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 4,378 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2015/02/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,533 reads

Steps to Apply a Service Pack or Patch to Mirrored SQL Server Databases

Planning on patching my SQL Servers to the latest service pack, but not sure how to complete this for a environment that is using database mirroring? In this tip, will outline the environment and then walk through the process of patching mirrored servers.  Read more...
By Additional Articles 2012/06/22 | Source: MSSQLTips.com | Category: patching
Rating:  Rate this |   Briefcase | 3,195 reads

Simple Steps to Prepare Mirror Database for Mirroring in SQL Server

To prepare a database for mirroring, you need to perform the following steps: Script the restore of the latest full database backup, script the restore of every transaction log backup that has been made after that full database backup, copy the full database backup and transaction log backups to the mirror server, and run the restore scripts on the mirror server. In this tip I will walk through these steps and provide sample scripts to prepare a database for mirroring.   Read more...
By Additional Articles 2012/06/20 | Source: MSSQLTips.com | Category: mirroring
Rating: (not yet rated)  Rate this |   Briefcase | 3,364 reads
   Items 1 to 11 of 11   
 
Tags
alwayson (3)    
cluster (3)    
t-sql (2)    
logins (1)    
migration (1)    
patching (1)    
powershell (1)    
users (1)