SQL Server DBA Tutorial 113-How to Configure Database Log Shipping in SQL Server

In this video you will learn step by step process of how to configure Database Log Shipping using SQL Server Management studio as well as using T-SQL Script. It shows process of how to enable Log Shipping configuration, how to configure Backup settings on Primary, how to add Secondary Server for Log Shipping, how to configure Log Shipping Monitoring Server, what is Primary, Secondary and Monitoring servers in Log Shipping and how to configure copy/restore Operation in SQL Server Log Shipping.
Blog post link for the video:
sqlage.blogspot...
Visit our website to check out SQL Server DBA Tutorial Step by Step
www.techbrother...

[@Krishna-pk9up]

Sir u have got a wonderful speaking style...thanks

[@TechBrothersIT]

Thank you dear for liking it. Appreciate your support.

[@vorkpalur]

Thank you very much for job you're doing and sharing the knowledge! Very helpful and easy to understand!

[@ganavigowda1]

Wow it's up straightforward explanation! Tysm for sharing your knowledge:)

[@binyammamo6454]

You never failed man! thank you!

[@sreeramchandu]

HI Tech Brothers Thanks a lot

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html

[@ТатьянаШШШ]

Thank you!
What should we do if the primary server is crushed? So I'd like to ask how can we make the secondary server to work as the primary one if the primary server isn't available?

[@nzrdb6]

Great stuff guys. Keep up the good work!

[@vishalbhorkar9235]

Very nicely explained every thing ...

[@manisanthosh126]

Very Neat Explanation.

[@shabasalsabil9558]

Thank you for your video very informative and detailed oriented May I know the the reason I why i can't run the copy and restore job in secondary server its failed again and again

[@nasarazam]

Our Backups are handled by our hosting company (Rackspace). Won't the transaction Log Backups setting I do, will screw their backups plan serialization?

[@06manfer]

Perfect, thanks a lot

[@Omar.bin.khattab]

thanks ... but can this workaround work without domain mean every server on another network and configured connection to server using static ip and port forwarding inside Router how to connect two servers for log shipping using ip ?

[@gass8]

Thanks for the video, it is simple, direct and helps a lot!
Are the same steps on version 2008, right?

[@TechBrothersIT]

+Gaspar G Hi Gaspar, You are welcome. Don't remember 2008 was difference. Give a try and I am positive same steps should work.

[@lakshayarora3935]

Thanks for the video. Great!! 😊😊

[@susantakumarrath3311]

Excellent explanation Tech Brothers!!
Could there be a case that we Backup the DB in Primary directly to a local location in the Secondary server (instead of Primary local location or Shared location) and Restore from there so we can avoid the Copy job in between??

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html

[@nknk13101992]

Can someone clarify if there is any quick way to re-establish log shipping after primary database refresh is done?

[@alexandrebraga93]

Hey, it's a great video, Can I enable log shipping of two databases from the same server?

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html

[@gaetanoparrello1543]

Hi Tech Brothers, thanks for the video! Any info about licensing and edition? Is there a minimum required edition? thanks a lot

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html

[@sqltechzpestechz7053]

Can u tell me if i am on secondry server but i want the physical logical work location of primary server...how should i get it

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html

[@ecstasy3129]

Great... But user used on shared folder is not clear.

[@sau002]

Excellent!

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html

[@raghu1028]

thanks for the KT .can you please share that script..

[@debaprasadsaho6063]

Hi TB ,
copy job is failling....
( The job failed. The Job was invoked by Schedule 22 (DefaultCopyJobSchedule). The last step to run was step 1 (Log shipping copy job step.).
...any permission will be there ? Backup shared folder was showing error ,when i give service account to full control .it is working fine .but after giving full control to service account and agent account in copy job still copy job falling..

[@pushparaj5114]

really exellent

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html

[@TechBrothersIT]

Hi Raghuram, Please see below link for the scripts:
www.techbrothersit.com/2015/03/how-to-configure-database-log-shipping.html

[@cricketfever147]

If add a ndf in primary how to get in sec server...ppz rply

[@siva5244]

good

[@sarif75]

Simple genius!!!

[@2441844]

How would you test log shipping?

[@vishalbhorkar9235]

When can we c u sir...

[@sarksp]

Hi TB, thanks. How can I do that between 2 different machines in the same domain ?

[@TechBrothersIT]

+SP Sarkar this demo was between two machines -

[@sarksp]

Thank you very much !

[@gngn8116]

i want performance tuning in SQL server any videos in this concepts please provide me

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html

[@06manfer]

Are these steps the same for Log Shipping in a SQL Azure Server?

[@TechBrothersIT]

Thanks for watching the video Diego, I haven't tried in azure, I will find out today and will let you know.

[@06manfer]

Thanks a lot

[@TechBrothersIT]

Yes Diego, follow the same steps, they apply in azure too. Just keep mind if you are setting up between two azure servers, they need to communicate with each other otherwise setup will fail.

[@gurupanda4192]

hey mate try this one ua-cam.com/video/2MhpdyzOS-U/v-deo.html