1. Русский
  2. Question
0

SQL: log shipping or replication

azagoskin 1 year ago • updated 1 year 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
mmingalov (Moderator (RUS)) 1 year ago

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
mmingalov (Moderator (RUS)) 1 year ago

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
azagoskin 1 year ago

Thank you Maxim!

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

Customer support service by UserEcho