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. th-cam.com/video/6ptALQlgRMI/w-d-xo.html 2. Join computer to a AD th-cam.com/video/-TBGVD-zGK8/w-d-xo.html
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 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.
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
very clear and neat explanation
Thanks for the explanation, it helps me a lot!! 😁😁😁
good job brother and more vdo plz update every topic
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
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 =))))))))))))))))
Hi Sir, Could you please share videos on performance tuning and query tuning
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
are the primary and secondary server instance are on the same networks or in different networks?
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
After executing cmd in failover secondary log Shipping will be primary but data not reflecting in primary yyu
Does 'Delete file olders than' option delete only secondary server files?
Hi, can we use SQL Service Account instead of Domain Account as Server Agent?
Is this possible when you have a 3rd party tool to backup your DB and Tlogs?
Can you explain about .tuf & .wrk Files?
I having a problem I install virtual machine inside virtual machine I install three servers ok network is keep on disconnecting any solution
very good training
Please make a complete video on VLDB, backup and migration strategy for this
How do you get that, machine 2 server name, how do you setup
????
I am not getting that
Where from you...can you give classes on ms SQL dba
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.
th-cam.com/video/6ptALQlgRMI/w-d-xo.html
2. Join computer to a AD
th-cam.com/video/-TBGVD-zGK8/w-d-xo.html
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.
Can I use log shipping in the case of simple recovery model
No
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 how to get Stand-by mode
Pls do one video for all issues of sql server
how to connect network to linux vm if want sharing like linux
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
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)
Video is excellent
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.
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.
Can you send the fill details of insulation in sql dba
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
Sir, how to get SSMS in virtual machine ????
You have to use drive sharing option in VM settings
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
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
Thank you sir
Why their will be a loss of data in log shipping? What is the reason behind this? @righttolearn
How many secondary servers we can add in log shipping?
25 servers
Pls explain about .tuf files
Awesome
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.
Exclusive access could not be obtained because the database is in use
Where is tuf file
Please check this video th-cam.com/video/6zI7fqumdVw/w-d-xo.html