Configuring Log Shipping in SQL Server 2022 between two workgroup Servers (no Active Directory) #sql

[email protected] Chirag's SQL Server DBA Tutorial https://www.chirags.in ***************************************************************************************** Configuring Log Shipping in SQL Server 2022 between two workgroup Servers (no Active Directory) ***************************************************************************************** You Can change the Audio Track in YouTube: Go to ⚙️Setting ➡️ 🎧Audio Track ➡️ English (United States) Hindi Orignal I will be using two ways in SQL Server: 1. Using SQL Server management studio graphic user interface GUI Version 2. Using T-SQL script Here’s a step-by-step guide to configuring Log Shipping in SQL Server 2022 between two workgroup servers (no Active Directory) with IPs: +-------------------------------+-----------------+ | Primary Server IP: | 192.168.224.144 | +-------------------------------+-----------------+ | Secondary (Replica) Server IP:| 192.168.224.145 | +-------------------------------+-----------------+ I’ll: Create a test database and insert sample data. Configure log shipping using SQL Server Management Studio (SSMS). Use SQL authentication for communication (since there's no Active Directory). ✅ Prerequisites (on both servers) Install SQL Server 2022 on both machines. Open SQL Server ports (default: 1433) in the firewall. Create a folder on each server for log shipping: For any doubts and query, please write on YouTube video comments section. Note : Flow the Process shown in video. 😉Subscribe and like for more videos:    / @chiragmahtoofficial   💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment Thanks & Regards, Chitt Ranjan Mahto "Chirag" _________________________________________________________________________________________ Note: All scripts used in this demo will be available in our website. Link will be available in description. #ChiragTutorial #ChiragsTutorial #Chirags #Chirag #ChittRanjanMahto #ChiragMahto #SQLServer2022 #LogShipping #SQLLogShipping #SQLServerLogShipping #LogShippingSQLServer2022 #WorkgroupServers #SQLServerWorkgroup #NoActiveDirectory #SQLServerNoAD #SQLFailover #DisasterRecoverySQL #SQLServerReplication #SQLBackupRestore #SQLHighAvailability #LogShippingWithoutDomain #ConfigureLogShipping #LogShippingStepByStep #SQLServerTutorial #SQLServerTraining #SQLServerSetup #SQLServer2022Tutorial #SQLLogShippingWithoutAD #ConfigureLogShippingWorkgroup #LogShippingGuide #SQLServerManagementStudio #SSMS #SQLAutomation #DatabaseReplication #MicrosoftSQLServer #SQLServerConfiguration #SQLServerScripts #PowerShellSQL #TSQL #DatabaseBackup #DatabaseFailover #SQLRestoreJob #SQLAgentJob #SQLMonitoring #ScheduledBackupSQL #SQLServerBeginner #SQLServerExpert #SQLServerCourse #LearnSQLServer #SQLServerCertification #SQLServerForBeginners #SQLServerHandsOn #DatabaseTraining #LogShippingHandsOn #SQLDBA #MicrosoftTraining #SQLServerDemo #ITTraining #MicrosoftSQLTraining #SQLServerBasics #HowTo #StepByStep #TechTutorial #WindowsServer #ServerConfiguration #TutorialInHindi (if applicable) #YouTubeLearning #FreeCourse #TechnicalTraining #DailyTech #TechGuide #TechSkills #TechExplained #DatabaseTech #ServerAdmin #SystemAdministrator #SQL2022 #SQLServer2019 #AlwaysOn #SQLClustering #FailoverClustering #SQLAvailability #SQLMirroring #SQLBackupStrategy #DatabaseRecovery #RTORPO #SQLServerFailoverSetup #SQLServerTips #SQLServerReplication2022 #LogShippingTutorial2022 #SQLLogShippingExplained #SetUpSQLLogShipping #SQLShipping2022 #DatabaseShipping #SQLDRSetup #SQLServerDR #DRNoDomain #MSLogShipping #LogShippingReplication #ChiragLogShippingGuide