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

[@ramukomera8159]

Sir you are awesome 😘😘😘😘 very clear and neat explanation... You are true ROBIN HOOD. Expecting more videos from you on all HIGH AVAILIBILITY concepts.😍

[@GENADIKRASTEV]

Thank you for the another excellent video Teacher,may you be very healthy and loved

[@Ganeshay-09]

good job brother and more vdo plz update every topic

[@krishnarai3123]

very clear and neat explanation

[@alyssonestevam2813]

Thanks for the explanation, it helps me a lot!! 😁😁😁

[@ramgurung1038]

Thank you Sir, appreciate your detailed explanations

[@deepalidurgawale8488]

Explained very well

[@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

[@egorkosenkov4476]

Thank you very much!!! Trofimovich is going to be satisfied =))))))))))))))))

[@kadirkkkk]

5:37 is it secure to start services as administrator or should ve give permission for service accounts to shared folders?

[@jacksparrow8654]

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]

no one should delete administrator account :D@@jacksparrow8654

[@MiningForPies]

Never ever, have services run as an administrator

[@Harsha_vardhan1]

Hi Sir, Could you please share videos on performance tuning and query tuning

[@ramadeviremata6947]

Bro u didn't explained the .tuf, .wrk file which comes under log shipping concept, please explain those also

[@righttolearnbk]

Ok. Will explain them in a seperate video

[@sqltechzpestechz7053]

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

[@rolfhchristianeslabra4787]

Hi, can we use SQL Service Account instead of Domain Account as Server Agent?

[@HariKrishnaForYou]

Can you explain about .tuf & .wrk Files?

[@jeromeswartz1836]

Is this possible when you have a 3rd party tool to backup your DB and Tlogs?

[@thirupathiraot2207]

Please make a complete video on VLDB, backup and migration strategy for this

[@ItachiUchiha-mm1iv]

are the primary and secondary server instance are on the same networks or in different networks?

[@seyma6627]

Does 'Delete file olders than' option delete only secondary server files?

[@wesg01]

very good training

[@deepnwd]

Can I use log shipping in the case of simple recovery model

[@righttolearnbk]

No

[@ayushchourasiya4616]

How do you get that, machine 2 server name, how do you setup ???? I am not getting that

[@banalasiva5743]

After executing cmd in failover secondary log Shipping will be primary but data not reflecting in primary yyu

[@banalasiva5743]

I having a problem I install virtual machine inside virtual machine I install three servers ok network is keep on disconnecting any solution

[@damamanohar7983]

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]

Quorum is required but we can also configure file share witness

[@venkatasuryasaip5239]

@@righttolearnbkif we have some real time examples also like real time videos it is more helpful for us please look into this

[@righttolearnbk]

@@venkatasuryasaip5239 Noted.

[@Surekhareddy925]

Where from you...can you give classes on ms SQL dba

[@pavankumargali6109]

Can you explain how to get Stand-by mode

[@karthiksv6868]

Could you show us how to configure VirtualBox machines for this Log Shipping setup?

[@righttolearnbk]

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

[@ravindra3216]

Pls do one video for all issues of sql server

[@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]

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.

[@ravindra3216]

Video is excellent

[@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]

It is automatic as you also define schedule during setup. You can also make it manual

[@ravindupethangoda5125]

@@righttolearnbk Thank you ❤️

[@Preetiwaghmareh]

Hello sir can u make video on manual failover of log shipping and manual failover of mirroring

[@righttolearnbk]

Ok

[@Preetiwaghmareh]

@@righttolearnbk thank you

[@kakarlanagajyothi4089]

In data base properties I can not display Transaction log shipping block.

[@righttolearnbk]

Check in primary server primary database properties

[@kakarlanagajyothi4089]

@@righttolearnbk I can do that way but not display.

[@Ganeshay-09]

how to connect network to linux vm if want sharing like linux

[@shaikbabafakruddeen2412]

Can you send the fill details of insulation in sql dba

[@lalsaikatta5407]

Sir one dobut, in primary didn't give the physical file location

[@righttolearnbk]

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)

[@ayushchourasiya4616]

Sir, how to get SSMS in virtual machine ????

[@righttolearnbk]

You have to use drive sharing option in VM settings

[@chaitanyakrishna4358]

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]

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]

@@righttolearnbk would you please make a video on it

[@righttolearnbk]

@@venkatasuryasaip5239 sure. Will do

[@sachindeshmukh7071]

How many secondary servers we can add in log shipping?

[@rajangugnani1220]

25 servers

[@nknk13101992]

Can someone let me know if there is any quick way to re-establish log shipping after primary database is refreshed? TIA

[@righttolearnbk]

You need to configure reverse log shipping after the primary server is up and running.

[@Ingles4allYou]

How to get access to sql server for free for learning purposes to pratice and follow the classes?.

[@righttolearnbk]

Download Evaluation edition which is free for 6 months or else use developer edition

[@androidbuzz2369]

Why their will be a loss of data in log shipping? What is the reason behind this? @righttolearn

[@banalasiva5743]

In failover I insert and deleted primary igot like this msg can u please help

[@righttolearnbk]

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]

@@righttolearnbk thanks can u please make a video on performance tuning all concepts like index ,cluster non cluster, update statics fragmentation please

[@righttolearnbk]

@@banalasiva5743 will do as soon as possible

[@r.pavithraramalingam8182]

Pls explain about .tuf files

[@kallurisaikumar1546]

Thank you sir

[@banalasiva5743]

Exclusive access could not be obtained because the database is in use

[@MahendraSingh-sw1th]

Awesome

[@vijaygoud2414]

Where is tuf file

[@righttolearnbk]

Please check this video kzbin.info/www/bejne/bKusaJmnqtKXjNk

[@andrewan8855]

given 'everyone' to access the share folders with logs files is a big NO NO for security reason.

[@righttolearnbk]

This is given only for demo purposes.