Disaster Recovery

• Topics

  Started by

  Posts

  Last post

• Disaster Recovery - Standby Server - Replication vs Log Shipping -Pros and Cons?

  I want to have a standby server at a remote location. it does not need to fail-over automatically, …

  Kristen-173977

  4 replies

  5 years, 2 months ago

  By: as_1234

• Attaching Multiple MDF and having LDF regenerated

  There are a bunch of posts for attaching a single MDF and having the LDF regenerated using sp_atta…

  Rob Scholl

  2 replies

  5 years, 4 months ago

  By: Rob Scholl

• Recovering an async database from Primary backups in HAG

  First of all - this is all OK now. I just want to know if I did anything wrong or what I could have…

  BrainDonor

  3 replies

  5 years, 5 months ago

  By: BrainDonor

• Restoring the SQL Server Configuration

  Hi SQL gurus, I had to rebuilt a Windows 2005 SQL Server Enterprise this company use to run ERP, ve…

  JCALEX

  2 replies

  5 years, 6 months ago

  By: JCALEX

• Off-site backups

  I've recently started in a new organisation and found that 2 local SQL Servers Backups are not goin…

  PhilipC

  15 replies

  5 years, 8 months ago

  By: Sreekanth B

• Backup strategy| Azure VM snapshots VS SQL server backups for ready only databases - Which is the best option?

  I am designing a backup strategy for one of the new applications. We have a Azure SQL server VM (Ia…

  Keistad

  2 replies

  6 years ago

  By: Jeffrey Williams

• Adding log shipping to synchronous always on cluster for disaster recovery,why need to have have primary as backup default when add log shipping when always on opposite. Is that really true? Any lessons learned in Production environment for this?

  Adding log shipping to synchronous always on cluster for disaster recovery, because other options w…

  kcole2

  1 replies

  6 years ago

  By: Beatrix Kiddo

• DR via SAN replication

  Hi, I am not a DBA. But have been looking into my company's DR procedures, and the SQL Server proce…

  waxingsatirical

  2 replies

  6 years, 1 month ago

  By: Michael L John

• Windows Server 2016 no Active Directory Cluster + SQL Server 2017 Standard Basic AG + Azure Load Balancer as a Listener

  Hello, Please help.I'm trying to Create a SQL Server 2017 Standard Edition Basic Always On Availabi…

  83851263

  1 replies

  6 years, 7 months ago

  By: mykhailo.karpenko

• AlwaysOn: nice but our servers are virtualized

  I am currently exploring some high availability solutions so I dived into the world of High availab…

  Wilfred van Dijk

  6 replies

  6 years, 8 months ago

  By: Shawn Melton

• 52 Hours to Back Up a 17.5 TB DB

  A vendor just informed me that it takes them 52 hours to back up our 17.5 TB SQL Server 2008 R2 Dat…

  imani_technology

  2 replies

  6 years, 8 months ago

  By: alen teplitsky

• IP change on WSFC with SQL Server Availibility Groups

  Hi Guys, One of our infrastructure architects changed the IP Address where our SQL Server Availabil…

  Imke Cronje

  1 replies

  6 years, 11 months ago

  By: Jo Pattyn

• ReportServerTempDB corruption in the log

  Hi, I have got error said Backup detected corruption in the database log when I backup the ReportSe…

  dxu

  1 replies

  7 years, 4 months ago

  By: Jo Pattyn

• Designing and Architecture

  Hi guys, I am new to architectural field and have some very common queries. I am moving my db serve…

  sqlenthu 89358

  5 replies

  7 years, 4 months ago

  By: Gail Shaw

• Want some help in Recovery

  Hi Team, There are two scenarios : Scenario 1: I have a huge database which works on Mon-Sat 9 AM t…

  vinnnu88

  8 replies

  7 years, 11 months ago

  By: HanShi