Disaster Recovery

• Topics

  Started by

  Posts

  Last post

• Clustering - WSFC vs AGs

  Hi, More and more I'm having discussions with customers who want to move away from FCI to AGs. The …

  lanky_doodle

  3 replies

  1 week, 1 day ago

  By: sterling3721

• SQL server restore - attaching all data and log files - should I do master etc?

  Hi everyone We've had a critical O/S issue on a server that runs SQL2012 Std Ed. Data is 100% intac…

  antonstar

  2 replies

  2 months ago

  By: antonstar

• 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 months, 1 week ago

  By: as1981

• 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

  8 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

  8 months, 2 weeks 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

  10 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

  11 months, 1 week 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

  1 year, 3 months ago

  By: Jeffrey Williams 3188

• 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

  1 year, 3 months 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

  1 year, 4 months 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

  1 year, 10 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

  1 year, 11 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

  1 year, 11 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

  2 years, 2 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

  2 years, 7 months ago

  By: Jo Pattyn