i guess Im randomly asking but does anybody know of a tool to get back into an instagram account?? I somehow lost my password. I appreciate any assistance you can give me!
Hi i have source sql server where there are views. I just have access to those views. I cannot configure that sql server etc. I have also another sql server where i have full control and the ke ypoint is i have to somehow create tables which will be replication of those views from source sql server. I need to have the data on the second sql server always with same data as is on source views... so if any update on source on second sql server somehow tables data has to be reflected. Is there anyway to configure that second sql server to reach the goal?
thanks for the great presentation, I'm new to mssql server, I would like to inquire if there is a type of replication where the generated transaction logs on the hourly basis can be applied automatically on the secondary db server?
If I need to configure replication high availability for less than 1 TB database, is it best to set up as transactional or peer-to-peer in terms of ease of configuration as well as maintainability?
Hi Peter, How about using Availability Group instead of using Replication. Because if your schema change , add a new table or drop a column, you have to deal with Replication reconfiguration. Use AG and you should be fine. Also you can use Transaction replication as well.
@@TechBrothersITThanks for your response. Transactional replication is now set up but my manager is talking about implementing AlwaysOn too. However, we have sql server 2016 enterprise edition for prod and only standard edition for dev enviroment. Do you think it's best to just set up AlwaysOn FCI and not AG at this point?
Great content as always. Thanks a lot!
powerful video keep th good work... thank you techbrothers
+ZimSpace Thanks for kind words dear. Doing our best! Thanks for watching.
its helpful for me thank you
precise and perfect.. great job sir
Thank you very much TechBrothers for your efforts. truly appreciate your kindness.God bless you.
i guess Im randomly asking but does anybody know of a tool to get back into an instagram account??
I somehow lost my password. I appreciate any assistance you can give me!
Need one help... Is there any way to pause replication and i can refresh subscriber full database and then resume replication
Hi i have source sql server where there are views. I just have access to those views. I cannot configure that sql server etc. I have also another sql server where i have full control and the ke ypoint is i have to somehow create tables which will be replication of those views from source sql server. I need to have the data on the second sql server always with same data as is on source views... so if any update on source on second sql server somehow tables data has to be reflected. Is there anyway to configure that second sql server to reach the goal?
Can I replicate on SQL Server Instances across two different Servers? Also does this slow down the performance of a Production environment?
What are the factors that cause replication latency. We ate experiencing this issue a lot.
Thanks tekbrothersIT you are good
+micki maraki thanks dear for kind words and thanks for watching.
thanks for the great presentation, I'm new to mssql server, I would like to inquire if there is a type of replication where the generated transaction logs on the hourly basis can be applied automatically on the secondary db server?
+alexander alto replication can be scheduled - so if you setup transactional - you can schedule to synch every hour and it will be automatic. :)
TechBrothersIT
can you provide a video instruction on how to configure this? many thanks,
alex
If I need to configure replication high availability for less than 1 TB database, is it best to set up as transactional or peer-to-peer in terms of ease of configuration as well as maintainability?
Hi Peter, How about using Availability Group instead of using Replication. Because if your schema change , add a new table or drop a column, you have to deal with Replication reconfiguration. Use AG and you should be fine. Also you can use Transaction replication as well.
@@TechBrothersITThanks for your response. Transactional replication is now set up but my manager is talking about implementing AlwaysOn too. However, we have sql server 2016 enterprise edition for prod and only standard edition for dev enviroment. Do you think it's best to just set up AlwaysOn FCI and not AG at this point?