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?
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
Our Backups are handled by our hosting company (Rackspace). Won't the transaction Log Backups setting I do, will screw their backups plan serialization?
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 ?
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??
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..
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.
![Megan Thee Stallion - Bigger In Texas [Official Video]](http://i.ytimg.com/vi/QxTkZTLWdo4/mqdefault.jpg)
Sir u have got a wonderful speaking style...thanks
Thank you dear for liking it. Appreciate your support.
Thank you very much for job you're doing and sharing the knowledge! Very helpful and easy to understand!
Wow it's up straightforward explanation! Tysm for sharing your knowledge:)
You never failed man! thank you!
Great stuff guys. Keep up the good work!
Hi Raghuram, Please see below link for the scripts:
www.techbrothersit.com/2015/03/how-to-configure-database-log-shipping.html
Very nicely explained every thing ...
HI Tech Brothers Thanks a lot
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.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?
Very Neat Explanation.
Thanks for the video. Great!! 😊😊
Thanks for the video, it is simple, direct and helps a lot!
Are the same steps on version 2008, right?
+Gaspar G Hi Gaspar, You are welcome. Don't remember 2008 was difference. Give a try and I am positive same steps should work.
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
Perfect, thanks a lot
Our Backups are handled by our hosting company (Rackspace). Won't the transaction Log Backups setting I do, will screw their backups plan serialization?
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 ?
Hey, it's a great video, Can I enable log shipping of two databases from the same server?
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.html
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??
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.html
Hi Tech Brothers, thanks for the video! Any info about licensing and edition? Is there a minimum required edition? thanks a lot
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.html
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
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.html
Excellent!
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.html
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..
Can someone clarify if there is any quick way to re-establish log shipping after primary database refresh is done?
thanks for the KT .can you please share that script..
really exellent
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.html
Hi TB, thanks. How can I do that between 2 different machines in the same domain ?
+SP Sarkar this demo was between two machines -
Thank you very much !
When can we c u sir...
If add a ndf in primary how to get in sec server...ppz rply
How would you test log shipping?
Are these steps the same for Log Shipping in a SQL Azure Server?
Thanks for watching the video Diego, I haven't tried in azure, I will find out today and will let you know.
Thanks a lot
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.
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.html
Simple genius!!!
i want performance tuning in SQL server any videos in this concepts please provide me
hey mate try this one ruclips.net/video/2MhpdyzOS-U/видео.html
good