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?
Our Backups are handled by our hosting company (Rackspace). Won't the transaction Log Backups setting I do, will screw their backups plan serialization?
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
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 ?
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..
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??
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.
Wow it's up straightforward explanation! Tysm for sharing your knowledge:)
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!
You never failed man! thank you!
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?
Great stuff guys. Keep up the good work!
Very nicely explained every thing ...
Our Backups are handled by our hosting company (Rackspace). Won't the transaction Log Backups setting I do, will screw their backups plan serialization?
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
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.
HI Tech Brothers Thanks a lot
hey mate try this one th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
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 ?
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..
Very Neat Explanation.
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 th-cam.com/video/2MhpdyzOS-U/w-d-xo.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 th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
Thanks for the video. Great!! 😊😊
Hey, it's a great video, Can I enable log shipping of two databases from the same server?
hey mate try this one th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
Can someone clarify if there is any quick way to re-establish log shipping after primary database refresh is done?
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 th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
thanks for the KT .can you please share that script..
If add a ndf in primary how to get in sec server...ppz rply
When can we c u sir...
How would you test log shipping?
Perfect, thanks a lot
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 !
i want performance tuning in SQL server any videos in this concepts please provide me
hey mate try this one th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
really exellent
hey mate try this one th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
Excellent!
hey mate try this one th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
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 th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
Simple genius!!!
good
Hi Raghuram, Please see below link for the scripts:
www.techbrothersit.com/2015/03/how-to-configure-database-log-shipping.html