Sir you are awesome 😘😘😘😘 very clear and neat explanation... You are true ROBIN HOOD. Expecting more videos from you on all HIGH AVAILIBILITY concepts.😍
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
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
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
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.
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)
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)
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
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
very clear and neat explanation
Thanks for the explanation, it helps me a lot!! 😁😁😁
Thank you Sir, appreciate your detailed explanations
Explained very well
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
Thank you very much!!! Trofimovich is going to be satisfied =))))))))))))))))
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
Never ever, have services run as an administrator
Hi Sir, Could you please share videos on performance tuning and query tuning
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
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
Hi, can we use SQL Service Account instead of Domain Account as Server Agent?
Can you explain about .tuf & .wrk Files?
Is this possible when you have a 3rd party tool to backup your DB and Tlogs?
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?
Does 'Delete file olders than' option delete only secondary server files?
very good training
Can I use log shipping in the case of simple recovery model
No
How do you get that, machine 2 server name, how do you setup
????
I am not getting that
After executing cmd in failover secondary log Shipping will be primary but data not reflecting in primary yyu
I having a problem I install virtual machine inside virtual machine I install three servers ok network is keep on disconnecting any solution
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.
Where from you...can you give classes on ms SQL dba
Can you explain how to get Stand-by mode
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
Pls do one video for all issues of sql server
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.
Video is excellent
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 ❤️
Hello sir can u make video on manual failover of log shipping and manual failover of mirroring
Ok
@@righttolearnbk thank you
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.
how to connect network to linux vm if want sharing like linux
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)
Sir, how to get SSMS in virtual machine ????
You have to use drive sharing option in VM settings
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
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.
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
Why their will be a loss of data in log shipping? What is the reason behind this? @righttolearn
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
Pls explain about .tuf files
Thank you sir
Exclusive access could not be obtained because the database is in use
Awesome
Where is tuf file
Please check this video ruclips.net/video/6zI7fqumdVw/видео.html
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.