SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Disaster Recovery (DR) Rss

   Items 1 to 20 of 208    Older >>
 

Step by Step Configuring AlwaysOn with Log Shipping

In this article, I will show you a procedure to combine SQL Server AlwaysOn with logshipping and to make log-shipping to work even in case of failovers between availability replicas in primary site.  Read more...
By Ganapathi varma Chekuri 2017/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 978 reads

Backups Aren't Backups Until a Restore Is Made

Steve Jones comments on the Gitlab outage.  Read more...
By Steve Jones 2017/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 88 reads

Broken tempdb

By Steve Jones 2017/01/26 | Category: disaster recovery (dr)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,155 reads

Clownpocalypse and DR

Today we have a guest editorial as Steve is out of town at the PASS Summit. Grant looks at disasters and being prepared.  Read more...
By Grant Fritchey 2016/10/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 109 reads

Why Log Shipping is still a viable solution in 2016

An explanation as to what Log Shipping is and why it's still a viable solution in 2016.  Read more...
By Kevin Chant 2016/02/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 155 reads

Streamline Log Shipping Failovers: DR Made Just For You…

A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.  Read more...
By Micah Nikkel 2015/09/08 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,552 reads

Why PolyBase matters - Part 2

Part 2, a more in depth look at An alternative approach to disaster recovery and backup strategies using PolyBase.   Read more...
By Alain Dormehl 2015/08/11 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 1,687 reads

Why PolyBase matters

An alternative approach to disaster recovery and backup strategies using PolyBase.   Read more...
By Alain Dormehl 2015/08/10 | Source: SQLServerCentral.com | Category: aps
Rating: |  Discuss |   Briefcase | 6,013 reads

Data Loss or Downtime

This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.  Read more...
By Steve Jones 2015/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 225 reads

Disaster Recovery and Big Data

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?  Read more...
By Additional Articles 2015/04/29 | Source: Database Journal | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 8,783 reads

Script out/store all indexes on a server

This script will store all index definitions into a table that you can use to "re-create" the indexes at a later date.  Read more...
By MyDoggieJessie 2015/03/11 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,038 reads

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.  Read more...
By Steve Jones 2015/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 280 reads

Two Days Off

Verizon is taking their cloud service offline for maintenance for two days. Steve Jones doesn't think that sounds good.  Read more...
By Steve Jones 2015/01/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 189 reads

Test Your Situation

One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.  Read more...
By Steve Jones 2015/01/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

Beware the Small Things

Minor disasters can become major ones quickly.  Read more...
By Steve Jones 2014/12/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 145 reads

Reverse Engineering Disasters

Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.  Read more...
By Steve Jones 2014/08/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 171 reads

Practically Cloudy: SQL Server Disaster Recovery to Microsoft Azure - Backups

In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server professional, Buck Woody shows that, whatever your version of SQL Server, there is a way of storing offsite backups in the cloud.  Read more...
By Additional Articles 2014/08/11 | Source: SimpleTalk | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 9,154 reads

Disaster Recovery and the Big Data Application

Ask database administrators how they implement disaster recovery in their big data environments and you'll get two typical responses: DR plans are not necessary and backups take up a lot of space. Despite this reasoning, a disaster recovery plan for your big data implementation may be essential for your company's future.  Read more...
By Additional Articles 2014/02/04 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 4,184 reads

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. This article looks at the common design patterns.  Read more...
By Additional Articles 2013/12/11 | Source: MSDN Communities | Category: always on
Rating:  Rate this |   Briefcase | 4,883 reads

Helping Streamline Log Shipping Failovers

Using Log Shipping? Looking for a more automated way to fail over during a disaster? Read on...  Read more...
By Micah Nikkel 2013/12/03 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 1,411 reads
   Items 1 to 20 of 208    Older >>
 
Tags
strategies (42)    
editorial (31)    
backup and restore (21)    
administration (20)    
sql server 7 (16)    
high availability (ha) (12)    
blogs (10)    
log shipping (9)    
sql server 2005 (9)    
database mirroring (6)    
clustering (5)    
security (5)    
database weekly (4)    
friday poll (4)    
replication (4)    
always on (3)    
availability (3)    
backups (3)    
miscellaneous (3)    
patches (3)    
programming (3)    
service packs (3)    
aps (2)    
backup strategy (2)    
big data (2)    
configuring (2)    
editorial - mp3 (2)    
editorial - wmv (2)    
encryption (2)    
installation (2)    
monitoring (2)    
polybase (2)    
product reviews (2)    
reporting services (ssrs) (2)    
restore (2)    
reviews (2)    
sql server 2012 (2)    
sql server 2016 (2)    
sql server parallel data warehouse (2)    
sql-dmo (2)    
sqlservercentral (2)    
transaction log (2)    
#alwayson (1)    
#dr (1)    
#logshipping (1)    
#logshippingstatus (1)    
7zip (1)    
alerts (1)    
alwayson (1)    
azure (1)    
backup (1)    
backup and recovery (1)    
bcp (1)    
business continuity (bc) (1)    
cloud computing (1)    
common language runtime (clr) (1)    
compression (1)    
data (1)    
dr (1)    
dts (1)    
editorial - ipod (1)    
enterprise (1)    
export (1)    
failover (1)    
gzip (1)    
highavailability (1)    
hp data protector (1)    
indexing (1)    
interpersonal skills (1)    
permissions (1)    
rebuild (1)    
rebuilding system databases (1)    
resolve logins (1)    
resource database (1)    
robocopy (1)    
sharepoint (1)    
sql server agent (1)    
sql server essentials (1)    
sqlclr (1)    
sqldenali (1)    
striped backups (1)    
system databases (1)    
tempdb (1)    
transparent data encryption (tde) (1)    
virtualization (1)    
webinar (1)    
workgroup (1)    
zip (1)