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:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[ganavigowda]

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

[vorkpalur]

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

[Krishna-pkup]

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

[nzrdb]

Great stuff guys. Keep up the good work!

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

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?

[gass]

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

[shabasalsabil]

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

[susantakumarrath]

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??

[alexandrebraga]

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

[gaetanoparrello]

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

[raghu]

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

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

[nknk]

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

[cricketfever]

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

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

[debaprasadsaho]

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..

[sqltechzpestechz]

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

[ecstasy]

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

[sarksp]

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

[gngn]

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