Pinned Loading

1. Collection of useful PowerShell comm... Collection of useful PowerShell commands/snippets

   1

   # PowerShell Commands

   2

   3

   ## Sanity check (i.e., change term window size)

   4

   `mode con:cols=150 lines=50`

   5

2. MS SQL Log shipping - Moving a stand... MS SQL Log shipping - Moving a standby/read only MS SQL replica database to a new server

   1

   # Moving the log ship secondary database

   2

   I had a challenge recently to move a very large log shipping replica to a new sql server,

   3

   Without a access to a backup/diff set and only the shipped transaction logs, here is how I did it.

   4

   Tested on SQL Server versions 2017, 2019.

   5

   Ingredients - source secondary database, new/existing destination secondary server for the replica database