Log Shipping in SQL server || Log Shipping Configuration || Ms SQL
HTML-код
- Опубликовано: 28 авг 2024
- 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...
Sir you are awesome 😘😘😘😘 very clear and neat explanation... You are true ROBIN HOOD. Expecting more videos from you on all HIGH AVAILIBILITY concepts.😍
Thank you for the another excellent video Teacher,may you be very healthy and loved
good job brother and more vdo plz update every topic
Explained very well
Thank you Sir, appreciate your detailed explanations
Thanks for the explanation, it helps me a lot!! 😁😁😁
Hi, can we use SQL Service Account instead of Domain Account as Server Agent?
Bro u didn't explained the .tuf, .wrk file which comes under log shipping concept, please explain those also
Ok. Will explain them in a seperate video
Thank you very much!!! Trofimovich is going to be satisfied =))))))))))))))))
very good training
Please make a complete video on VLDB, backup and migration strategy for this
are the primary and secondary server instance are on the same networks or in different networks?
Right to Learn @BK your explanation is great, can you pls let me know one thing for AG failover quorum is required or not
Quorum is required but we can also configure file share witness
@@righttolearnbkif we have some real time examples also like real time videos it is more helpful for us please look into this
@@venkatasuryasaip5239 Noted.
Can you explain about .tuf & .wrk Files?
Video is excellent
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
How do you get that, machine 2 server name, how do you setup
????
I am not getting that
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
Is this possible when you have a 3rd party tool to backup your DB and Tlogs?
how to connect network to linux vm if want sharing like linux
I having a problem I install virtual machine inside virtual machine I install three servers ok network is keep on disconnecting any solution
Pls do one video for all issues of sql server
Thank you sir
Where from you...can you give classes on ms SQL dba
After executing cmd in failover secondary log Shipping will be primary but data not reflecting in primary yyu
Could you show us how to configure VirtualBox machines for this Log Shipping setup?
Please watch my previous videos.
1. Building vm in virtual box.
ruclips.net/video/6ptALQlgRMI/видео.html
2. Join computer to a AD
ruclips.net/video/-TBGVD-zGK8/видео.html
Does 'Delete file olders than' option delete only secondary server files?
Hello sir can u make video on manual failover of log shipping and manual failover of mirroring
Ok
@@righttolearnbk thank you
How to get access to sql server for free for learning purposes to pratice and follow the classes?.
Download Evaluation edition which is free for 6 months or else use developer edition
Can you explain how to get Stand-by mode
Sir, how to get SSMS in virtual machine ????
You have to use drive sharing option in VM settings
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?
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.
Awesome
5:37 is it secure to start services as administrator or should ve give permission for service accounts to shared folders?
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.
no one should delete administrator account :D@@jacksparrow8654
Why their will be a loss of data in log shipping? What is the reason behind this? @righttolearn
Do we need to manually run the backup, copy and restore jobs from SSMS?? Is there any method to automatically run those jobs?
It is automatic as you also define schedule during setup. You can also make it manual
@@righttolearnbk Thank you ❤️
Can you send the fill details of insulation in sql dba
Sir one dobut, in primary didn't give the physical file location
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)
In data base properties I can not display Transaction log shipping block.
Check in primary server primary database properties
@@righttolearnbk I can do that way but not display.
Pls explain about .tuf files
Can someone let me know if there is any quick way to re-establish log shipping after primary database is refreshed?
TIA
You need to configure reverse log shipping after the primary server is up and running.
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
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)
@@righttolearnbk would you please make a video on it
@@venkatasuryasaip5239 sure. Will do
How many secondary servers we can add in log shipping?
25 servers
In failover I insert and deleted primary igot like this msg can u please help
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.
@@righttolearnbk thanks can u please make a video on performance tuning all concepts like index ,cluster non cluster, update statics fragmentation please
@@banalasiva5743 will do as soon as possible
Where is tuf file
Please check this video ruclips.net/video/6zI7fqumdVw/видео.html
Exclusive access could not be obtained because the database is in use
given 'everyone' to access the share folders with logs files is a big NO NO for security reason.
This is given only for demo purposes.