Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Mirroring Rss

   Items 1 to 6 of 6   
 

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 | 2,823 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 | 2,828 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 | 3,653 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 2013/11/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,517 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 | 2,792 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,170 reads
   Items 1 to 6 of 6   
 
Tags
alwayson (3)    
cluster (3)    
logins (1)    
migration (1)    
patching (1)    
powershell (1)    
users (1)