0

SQL: log shipping or replication

azagoskin 8 months ago in Geobank / SQL updated 8 months ago 2

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

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:

https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/configure-log-shipping-sql-server?view=sql-server-ver15


Regards, Max

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:

https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/configure-log-shipping-sql-server?view=sql-server-ver15


Regards, Max

+1

Thank you Maxim!

Начал набирать текст на английском для Jira, потом решил заглянуть на форум.