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

Content with tag Database Mirroring Rss

   Items 1 to 20 of 68    Older >>
 

Change operating modes for SQL Server Database Mirroring

SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.  Read more...
By Additional Articles 2015/08/03 | Source: MSSQLTips.com | Category: database mirroring
Rating: (not yet rated)  Rate this |   Briefcase | 2,903 reads

Move Database Files for a SQL Server Mirrored Database Without Impacting Database Mirroring

Ahmed Yaseen explains how you can move the SQL Server database files without the need to stop and re-create database mirroring.  Read more...
By 2015/01/20 | Source: MSSQLTips.com | Category: database mirroring
Rating: (not yet rated)  Rate this |   Briefcase | 7,680 reads

Is Database Mirroring Causing The Transaction Log To Fill Up

In this article, I describe some steps a DBA can take to check for mirroring on SQL Server, give a status of the mirroring state and some options for resolving any problems with the transaction log that might be caused by Database Mirroring.  Read more...
By C.J. Garcia 2014/11/06 | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 3,541 reads

Database Mirroring Setup

This great tutorial shows how to set up database mirroring across two instances in a virtual environment.  Read more...
By Brady Upton 2014/01/31 (first published: 2011/04/12) | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 13,469 reads

AlwaysOn and Database Mirroring

By Steve Jones 2013/12/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,691 reads

Create Mirror Alerts for All Mirrored Databases

Creates Mirror State-Change Alerts for ALL mirrored databases on a server - can save hours when setting up multiple mirrored instances  Read more...
By Jordon Pilling 2013/11/29 | Source: SQLServerCentral.com | Category: alerts
Rating: |  Discuss |   Briefcase | 3,197 reads

Automatic Page Repair

By Mike Hays 2013/11/12 | Category: high availability (ha)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,747 reads

Reporting Services Disaster Recovery

Dave Lumley presents a Reporting services disaster recovery solution for SQL Server Standard Edition, using 2 servers. Worth the read if you don't run Enterprise.  Read more...
By Dave Lumley 2013/10/17 (first published: 2010/04/21) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 15,383 reads

Configuring Database Mirroring

This article contains a set of instructions for configuring SQL Server mirroring, including pre-requisites. It also includes notes on how to resolve a few issues that I have encountered.  Read more...
By william thier 2013/07/26 (first published: 2011/02/01) | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 15,481 reads

Database Mirroring

By Naseer Ahmad 2013/03/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,904 reads

Mirrors

By Honza Mensdorff 2012/12/11 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,971 reads

Reporting Services Disaster Recovery

Dave Lumley presents a Reporting services disaster recovery solution for SQL Server Standard Edition, using 2 servers. Worth the read if you don't run Enterprise.  Read more...
By Dave Lumley 2013/10/17 (first published: 2010/04/21) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 15,383 reads

Transaction Replication Publisher failover to Mirror

Transaction Replication Publisher failover/failback to mirror standby with automatic redirection of the subscriber and client application.  Read more...
By Paul Brewer 2012/06/28 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,448 reads

Automatic page repair with SQL Server Mirroring

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...  Read more...
By 2012/05/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,818 reads

Setup database mirroring and log shipping together

SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...  Read more...
By 2012/04/25 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,751 reads

Endpoints

By Stanley Kapfunde 2012/04/23 | Category: endpoints
Rating: (not yet rated) |  Discuss |   Briefcase | 2,284 reads

SQL Server Database Mirroring Tips and Tricks, Part 1

Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique...  Read more...
By 2012/03/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,475 reads

Mirroring and different sector sizes? BAD IDEA!

Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.  Read more...
By Theo Ekelmans 2011/12/27 | Source: SQLServerCentral.com | Category: misaligned log io
Rating: |  Discuss |   Briefcase | 3,734 reads

Database Mirroring Failover

By Steve Jones 2011/10/13 | Category: database mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 2,035 reads
   Items 1 to 20 of 68    Older >>
 
Tags
high availability (ha) (20)    
administration (8)    
blogs (8)    
disaster recovery (dr) (6)    
sql server 2005 (4)    
replication (3)    
sql server 2008 (3)    
corruption (2)    
log shipping (2)    
reporting services (ssrs) (2)    
transactional replication (2)    
alerts (1)    
alwayson (1)    
best practices (1)    
data corruption (1)    
dmv (1)    
editorial (1)    
endpoints (1)    
extract, transform, load (etl) (1)    
filestream (1)    
integration services (ssis) (1)    
log_reuse_wait_desc (1)    
management studio (ssms) (1)    
migration (1)    
mirroring partners (1)    
misaligned log io (1)    
olap (1)    
oltp (1)    
page repair (1)    
performance tuning (1)    
sector size (1)    
service broker (1)    
snapshot (1)    
soap (1)    
sqlcmd (1)    
storage management (1)    
transaction logs (1)    
t-sql (1)    
updatable subscriptions (1)