Skip to content

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

  • Home
  • SQL Server
    • Administration
    • Diagnostics
    • Performance
    • Security
    • T-SQL
    • Tools
  • PowerShell
    • Remoting
    • Tools
  • Linux
  • .Net Development
    • Visual Studio
    • C#
    • MVC
    • ASP.NET
  • Servers
    • IIS
    • SharePoint
    • Hyper-V
    • MSMQ
  • Windows

Category: High-availability

Using PowerShell to Failover Availability Groups and WFC Cluster Nodes

Posted on 05/21/201905/21/2019 by Lincoln Bovee'

This article will show you how to failover an AG to another node and then move the WFC role to the same secondary…

Read More

About Availability Groups Database Seeding

Posted on 04/19/2019 by Lincoln Bovee'

This post will serve to describe all things regarding adding databases and trouble-shooting issues with Availability Groups Availability Group Direct Seeding: How to…

Read More

Availability Groups: Things to remember

Posted on 12/07/201806/26/2019 by Lincoln Bovee'

Here are a few things to remember when working with Availability Groups: Backup and Restore NOTE: Using the Recovery Advisor GUI in SSMS…

Read More

Properly Taking a Cluster Offline for Disk Maintenance

Posted on 08/14/201808/14/2018 by Lincoln Bovee'

I recently needed to replace the older, slower attached disks on our clustered SQL instance offline so as to copy each drive to…

Read More

Building an AlwaysOn Availability Group SQL Cluster

Posted on 03/07/201801/17/2019 by Lincoln Bovee'

Here are the steps to build at SQL Server 2017 AlwaysOn Availability Group. We will be using Windows 2016 Standard 64-bit for the…

Read More

About Replication

Posted on 09/28/201610/06/2016 by Lincoln Bovee'

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…

Read More

Tearing down SQL Server Replication

Posted on 06/17/201606/20/2016 by Lincoln Bovee'

I recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to…

Read More

Manually removing log-shipping

Posted on 04/25/201601/31/2017 by Lincoln Bovee'

I have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…

Read More

PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch

Posted on 10/28/201502/12/2016 by Lincoln Bovee'

PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…

Read More

Resolving Failover Log-shipping errors

Posted on 06/10/201510/14/2015 by Lincoln Bovee'

Here is an error I recent received when failing-over our databases at work from our Primary SQL Server to our Secondary during a…

Read More

Posts navigation

1 2 Next

Recent Posts

  • About TempDB and the Version Store 07/16/2019
  • Using PowerShell to Failover Availability Groups and WFC Cluster Nodes 05/21/2019
  • About Availability Groups Database Seeding 04/19/2019
  • About Collations in SQL Server 04/10/2019
  • PostgreSQL vs. SQL Server Notes 02/13/2019
  • Restoring a database using STOPATMARK 01/11/2019
  • Availability Groups: Things to remember 12/07/2018
  • Properly Taking a Cluster Offline for Disk Maintenance 08/14/2018
  • Building an AlwaysOn Availability Group SQL Cluster 03/07/2018
  • Some database design guidelines and best practices 01/29/2018

RSS Paul Randal’s Blog

  • The Curious Case of… eager writing and minimally-logged operations 04/12/2022 Paul Randal
  • The Curious Case of… random failing log shipping restores 03/09/2022 Paul Randal
  • The Curious Case of… data compression caching 02/07/2022 Paul Randal
  • The Curious Case of… tracking page compression success rates 01/12/2022 Paul Randal
  • Crazy, crazy end-of-year sale! 12/01/2021 Paul Randal

RSS Brent Ozar’s Blog

  • Is Remote Work the New Normal for DBAs? 06/28/2022 Brent Ozar
  • Now is the Right Time for the 2022 Brent Ozar Unlimited Scholarship Applications. 06/27/2022 Brent Ozar
  • I’m Coming Back to Israel for the Data.TLV Summit! 06/26/2022 Brent Ozar
  • I Wish SQL Server Warned About Hard-Coded Estimates. 06/23/2022 Brent Ozar

RSS Richard Siddaway’s PowerShell Blog

  • Time for cube calculation 01/29/2020
  • Spheres 01/29/2020
  • Recent releases 01/28/2020
  • Circles 01/28/2020
  • VScode improvement 12/31/2019

RSS SQLBlog.com Posts

RSS MSN PowerShell Blog

  • Hosting PowerShell in a Python script 06/27/2022 Jim Truher
  • PSReadLine 2.2.6 enables Predictive Intellisense by default 06/27/2022 Jason Helmick
  • PowerShellGet 3.0 Preview 14 05/31/2022 Sydney Smith
  • Major update to the PowerShell Extension for Visual Studio Code 05/04/2022 Sydney Smith
  • Announcing PowerShell Crescendo General Availability (GA) 03/10/2022 Jason Helmick
Powered by Newp WordPress Theme. © 2022 LincolnBlog.net. All Rights Reserved.