No video

Log Shipping in SQL server || Log Shipping Configuration || Ms SQL

  Рет қаралды 74,497

Right to Learn @BK

Right to Learn @BK

Күн бұрын

SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances.
The transaction log backups are applied to each of the secondary databases individually.
An optional third server instance, known as the monitor server, records the history and status of backup and restore operations and, optionally, raises alerts if these operations fail to occur as scheduled..
1. Back up the transaction log at the primary server instance.
2. Copy the transaction log file to the secondary server instance.
3. Restore the log backup on the secondary server instance.
HA and DR : • High Availability and ...
Find and fix orphan users in SQL server, watch link
• How to Find and Fix Or...

Пікірлер: 75
@ramukomera8159
@ramukomera8159 2 жыл бұрын
Sir you are awesome 😘😘😘😘 very clear and neat explanation... You are true ROBIN HOOD. Expecting more videos from you on all HIGH AVAILIBILITY concepts.😍
@Ganeshay-996
@Ganeshay-996 2 ай бұрын
good job brother and more vdo plz update every topic
@GENADIKRASTEV
@GENADIKRASTEV Жыл бұрын
Thank you for the another excellent video Teacher,may you be very healthy and loved
@deepalidurgawale8488
@deepalidurgawale8488 3 жыл бұрын
Explained very well
@ramgurung1038
@ramgurung1038 Жыл бұрын
Thank you Sir, appreciate your detailed explanations
@alyssonestevam2813
@alyssonestevam2813 2 жыл бұрын
Thanks for the explanation, it helps me a lot!! 😁😁😁
@egorkosenkov4476
@egorkosenkov4476 3 ай бұрын
Thank you very much!!! Trofimovich is going to be satisfied =))))))))))))))))
@rolfhchristianeslabra4787
@rolfhchristianeslabra4787 6 күн бұрын
Hi, can we use SQL Service Account instead of Domain Account as Server Agent?
@wesg01
@wesg01 Жыл бұрын
very good training
@ramadeviremata6947
@ramadeviremata6947 2 жыл бұрын
Bro u didn't explained the .tuf, .wrk file which comes under log shipping concept, please explain those also
@righttolearnbk
@righttolearnbk 2 жыл бұрын
Ok. Will explain them in a seperate video
@ravindra3216
@ravindra3216 2 жыл бұрын
Video is excellent
@HariKrishnaForYou
@HariKrishnaForYou 2 жыл бұрын
Can you explain about .tuf & .wrk Files?
@ItachiUchiha-mm1iv
@ItachiUchiha-mm1iv 9 ай бұрын
are the primary and secondary server instance are on the same networks or in different networks?
@ayushchourasiya4616
@ayushchourasiya4616 5 ай бұрын
How do you get that, machine 2 server name, how do you setup ???? I am not getting that
@sqltechzpestechz7053
@sqltechzpestechz7053 4 ай бұрын
I have one doubt. For ex primary db gets deleted and u restore the secondary db with recovery then after that how to bring the copy db to the primary from where its gets deleted
@thirupathiraot2207
@thirupathiraot2207 3 жыл бұрын
Please make a complete video on VLDB, backup and migration strategy for this
@damamanohar7983
@damamanohar7983 3 жыл бұрын
Right to Learn @BK your explanation is great, can you pls let me know one thing for AG failover quorum is required or not
@righttolearnbk
@righttolearnbk 3 жыл бұрын
Quorum is required but we can also configure file share witness
@venkatasuryasaip5239
@venkatasuryasaip5239 2 жыл бұрын
@@righttolearnbkif we have some real time examples also like real time videos it is more helpful for us please look into this
@righttolearnbk
@righttolearnbk 2 жыл бұрын
@@venkatasuryasaip5239 Noted.
@Ganeshay-996
@Ganeshay-996 2 ай бұрын
how to connect network to linux vm if want sharing like linux
@jeromeswartz1836
@jeromeswartz1836 9 ай бұрын
Is this possible when you have a 3rd party tool to backup your DB and Tlogs?
@kallurisaikumar1546
@kallurisaikumar1546 3 жыл бұрын
Thank you sir
@banalasiva5743
@banalasiva5743 3 жыл бұрын
I having a problem I install virtual machine inside virtual machine I install three servers ok network is keep on disconnecting any solution
@Omar.bin.khattab
@Omar.bin.khattab Жыл бұрын
thanks so much , but how can we implement log shipping between 2 servers not in same domain or network each server on its network , how to make shared folder between them
@banalasiva5743
@banalasiva5743 3 жыл бұрын
After executing cmd in failover secondary log Shipping will be primary but data not reflecting in primary yyu
@seyma6627
@seyma6627 Жыл бұрын
Does 'Delete file olders than' option delete only secondary server files?
@karthiksv6868
@karthiksv6868 3 жыл бұрын
Could you show us how to configure VirtualBox machines for this Log Shipping setup?
@righttolearnbk
@righttolearnbk 3 жыл бұрын
Please watch my previous videos. 1. Building vm in virtual box. kzbin.info/www/bejne/bKHXcn-HocyFg6s 2. Join computer to a AD kzbin.info/www/bejne/Y4WleIl6Yt96gZo
@Surekhareddy925
@Surekhareddy925 3 жыл бұрын
Where from you...can you give classes on ms SQL dba
@ravindra3216
@ravindra3216 2 жыл бұрын
Pls do one video for all issues of sql server
@MahendraSingh-sw1th
@MahendraSingh-sw1th 2 жыл бұрын
Awesome
@ayushchourasiya4616
@ayushchourasiya4616 5 ай бұрын
Sir, how to get SSMS in virtual machine ????
@righttolearnbk
@righttolearnbk 4 ай бұрын
You have to use drive sharing option in VM settings
@kadirkkkk
@kadirkkkk Жыл бұрын
5:37 is it secure to start services as administrator or should ve give permission for service accounts to shared folders?
@jacksparrow8654
@jacksparrow8654 5 ай бұрын
yes same doubt for me. there is no need to do that step. tomarrow if adminsitrator balu login if deleted. all logshipping jobs won't work.
@kadirkkkk
@kadirkkkk 5 ай бұрын
no one should delete administrator account :D@@jacksparrow8654
@jigneshpatel6956
@jigneshpatel6956 Жыл бұрын
sir if i have 15000 or more databases then log shipping is possible or create any problem. i tried Always On HA but after 700 - 800 database secondary server not synchronized with primary so not working. Log shipping is working?
@jacksparrow8654
@jacksparrow8654 5 ай бұрын
do you really think in real time use these many of databases in single primary server? architects won't recommend this model my friend. automatic failover is not there in the logshipping. this is used for only few databases having servers only.
@kakarlanagajyothi4089
@kakarlanagajyothi4089 3 жыл бұрын
In data base properties I can not display Transaction log shipping block.
@righttolearnbk
@righttolearnbk 3 жыл бұрын
Check in primary server primary database properties
@kakarlanagajyothi4089
@kakarlanagajyothi4089 3 жыл бұрын
@@righttolearnbk I can do that way but not display.
@Ingles4allYou
@Ingles4allYou Жыл бұрын
How to get access to sql server for free for learning purposes to pratice and follow the classes?.
@righttolearnbk
@righttolearnbk Жыл бұрын
Download Evaluation edition which is free for 6 months or else use developer edition
@pavankumargali6109
@pavankumargali6109 Жыл бұрын
Can you explain how to get Stand-by mode
@ravindupethangoda5125
@ravindupethangoda5125 Жыл бұрын
Do we need to manually run the backup, copy and restore jobs from SSMS?? Is there any method to automatically run those jobs?
@righttolearnbk
@righttolearnbk Жыл бұрын
It is automatic as you also define schedule during setup. You can also make it manual
@ravindupethangoda5125
@ravindupethangoda5125 Жыл бұрын
@@righttolearnbk Thank you ❤️
@lalsaikatta5407
@lalsaikatta5407 3 жыл бұрын
Sir one dobut, in primary didn't give the physical file location
@righttolearnbk
@righttolearnbk 3 жыл бұрын
If the backup folder is located in primary then we need to give the physical file location. In my case the backup folder is located in some other machine (other than primary and secondary)
@Preetiwaghmareh
@Preetiwaghmareh Жыл бұрын
Hello sir can u make video on manual failover of log shipping and manual failover of mirroring
@righttolearnbk
@righttolearnbk Жыл бұрын
Ok
@Preetiwaghmareh
@Preetiwaghmareh Жыл бұрын
@@righttolearnbk thank you
@shaikbabafakruddeen2412
@shaikbabafakruddeen2412 3 жыл бұрын
Can you send the fill details of insulation in sql dba
@nknk13101992
@nknk13101992 3 жыл бұрын
Can someone let me know if there is any quick way to re-establish log shipping after primary database is refreshed? TIA
@righttolearnbk
@righttolearnbk 3 жыл бұрын
You need to configure reverse log shipping after the primary server is up and running.
@androidbuzz2369
@androidbuzz2369 Жыл бұрын
Why their will be a loss of data in log shipping? What is the reason behind this? @righttolearn
@sachindeshmukh7071
@sachindeshmukh7071 2 жыл бұрын
How many secondary servers we can add in log shipping?
@rajangugnani1220
@rajangugnani1220 4 ай бұрын
25 servers
@chaitanyakrishna4358
@chaitanyakrishna4358 3 жыл бұрын
Hi BK Can you please help me to compress the log file in sql due to this I don’t have enough space in my e drive resulting in slowness in sap system
@righttolearnbk
@righttolearnbk 3 жыл бұрын
1. If the database is in full recovery model, take the T-log backup and then shrink the file 2. If the database is in simple recovery model, directly shrink the log file Steps to shrink (Select Database in SSMS > Right click > Tasks > Shrink > Files)
@venkatasuryasaip5239
@venkatasuryasaip5239 2 жыл бұрын
@@righttolearnbk would you please make a video on it
@righttolearnbk
@righttolearnbk 2 жыл бұрын
@@venkatasuryasaip5239 sure. Will do
@banalasiva5743
@banalasiva5743 3 жыл бұрын
In failover I insert and deleted primary igot like this msg can u please help
@righttolearnbk
@righttolearnbk 3 жыл бұрын
After failover you have to take tail log backup at primary server and then restore in secondary. Then after you can do reverse log shipping after primary server is up.
@banalasiva5743
@banalasiva5743 3 жыл бұрын
@@righttolearnbk thanks can u please make a video on performance tuning all concepts like index ,cluster non cluster, update statics fragmentation please
@righttolearnbk
@righttolearnbk 3 жыл бұрын
@@banalasiva5743 will do as soon as possible
@r.pavithraramalingam8182
@r.pavithraramalingam8182 2 жыл бұрын
Pls explain about .tuf files
@vijaygoud2414
@vijaygoud2414 8 ай бұрын
Where is tuf file
@righttolearnbk
@righttolearnbk 8 ай бұрын
Please check this video kzbin.info/www/bejne/bKusaJmnqtKXjNk
@banalasiva5743
@banalasiva5743 3 жыл бұрын
Exclusive access could not be obtained because the database is in use
@andrewan8855
@andrewan8855 3 жыл бұрын
given 'everyone' to access the share folders with logs files is a big NO NO for security reason.
@righttolearnbk
@righttolearnbk 3 жыл бұрын
This is given only for demo purposes.
Endpoints in SQL server || How to create a endpoint || Ms SQL
16:07
Right to Learn @BK
Рет қаралды 18 М.
Senior DBA Class - Transaction Log Shipping Tips and Tricks
44:14
Brent Ozar Unlimited
Рет қаралды 9 М.
what will you choose? #tiktok
00:14
Анастасия Тарасова
Рет қаралды 3,5 МЛН
女孩妒忌小丑女? #小丑#shorts
00:34
好人小丑
Рет қаралды 84 МЛН
Пройди игру и получи 5 чупа-чупсов (2024)
00:49
Екатерина Ковалева
Рет қаралды 4,2 МЛН
Always ON Availability Groups in SQL server - A HA-DR Solution || Ms SQL
28:19
SQL Server High Availability and Disaster Recovery overview
33:57
Tail Log Backup in SQL Server || When to take a Tail log backup || Ms SQL
19:48
The BEEFY mini PC - Minisforum AtomMan G7 PT
12:40
ShortCircuit
Рет қаралды 129 М.
Types of Backup in SQL Server || Ms SQL
20:25
Right to Learn @BK
Рет қаралды 44 М.
How to Configure Log Shipping
10:10
CBT Nuggets
Рет қаралды 10 М.