Question
SQL: log shipping or replication
Hey guys,
I need to send data for my Geobank Mobile database from the local core shack SQL server to the main SQL server in the office. What algorithm would you recommend: log shipping or replication? It seems like replication can be quite challenging to set up and maintain… besides, I know that log shipping is working at least for one of my colleagues at many sites. But are there any hidden problems?
Setup:
- 4 logging laptops are synchronizing logging data to the SQL GBM database at the local server
- New data is being pushed to the copy of the GBM database on the main SQL server in the office
- An SQL script populates data from GBM views to the buffer table of the main SQL database (GB)
Thanks in advance,
Andrey
Answer
Dear Andrey,
both approaches are applicable here but I agree with you -- replication maintenance may looks quite challenging here and requires more time and skills from person who provides its setup.
I recommend you to start with log shipping and follow this way.
There are good manual how to setup it for network environment:
Regards, Max
Thank you Maxim!
Начал набирать текст на английском для Jira, потом решил заглянуть на форум.
Customer support service by UserEcho
Dear Andrey,
both approaches are applicable here but I agree with you -- replication maintenance may looks quite challenging here and requires more time and skills from person who provides its setup.
I recommend you to start with log shipping and follow this way.
There are good manual how to setup it for network environment:
https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/configure-log-shipping-sql-server?view=sql-server-ver15
Regards, Max