Common Log shipping Error for SQL DBA Interviews || SQL Log shipping major three errors @TechandArt

Hi Mate,
Welcome to my channel Tech & Art.

**STAY HEALTHY AND KEEP LEARNING***
***ALWAYS HAPPY AND CONNECTED ***

In this session we are going to discuss about common logshiping errors and resolution for sql DBA interviews. @TechandArt

Stay tuned by clicking the subscribe button and clicking on bell icon for future notifications. Thanks 🙏

SQL ARCHITECTURE:-

SQL SELECT STATEMENT:-

SQL DML STATEMENTS PROCESSING:-

SQL AAG

Linked server

SQL MIRRORING

SQL REPLICATION

SQL LOGSHIPING

ORACLE INSTANCE AND DATABASE:-

ORACLE INSTANCE STARTUP SEQUENCE

ORACLE INSTANCE SHUTDOWN SEQUENCE:-

SQL SERVER BACKUP/RESTORE:-

SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED,

#sqlserver #sqllogshiping  #techandart

[TechandArt]

Hello Mate,
Hope it's some kind of help from my side, if you faced any issues plz do a comment and yes, plz share with others as well. Thanks 🙏

[gurupanda]

Awesome veryhelpfulas usually... thanks for sharing sir 👍👍👍👍

[aswinm]

Because of ur video. I am DBA now . Thanks very much

[sansak]

hi great work, but my usual doubt is, when we add transactions to primary server anyway it is not going to add on secondary instantly, it work on copy job getting restored, so how same path matters, in primary when the back up happened to shared folder at interval of loshipping backup job the record details will get exist, it will get copied to secondary server copy folder then will get restored, so here how same path validation required i didnt understand, could you please help me with ans, tq in advance.

[inmcc]

Hi, I'm getting error as cannot open backup file. system error-1396 Logon failure while restoring backup to secondary database building log shipping. Any suggestion?