About this project
it-programming / desktop-apps
Open
(spanish version below)
help setup transactional replication between an on-premises sql server 2012 standard database and a sql server 2016 database hosted on amazon web services.
*Schema Structure and Sizing*
1. Schemas are identical
2. All tables must be replicated.
3. Database size is about 10GB (including documents)
*Tasks*
1. Create a brief implementation plan
2. Create a SQL script to setup the replication environment.
3. Setup email alerts to monitor replication health.
4. Setup database and log backups.
5. Make sure the database log does not grow uncontrollably.
6. Setup Transactional Replication on SQL Server
Objective:
Help setup transactional replication between an on-premises SQL Server 2012 Standard database and a SQL Server 2016 database hosted on Amazon Web Services.
Schema Structure and Sizing
1. Schemas are identical
2. All tables must be replicated.
3. Database size is about 10GB (including documents)
Tasks
1. Create a brief implementation plan
2. Create a SQL script to setup the replication environment.
3. Setup email alerts to monitor replication health.
4. Setup database and log backups.
5. Make sure the database log does not grow uncontrollably.
6. Set security settings on aws
spanish version ------
configuración de la replicación transaccional en sql server
objetivo:
ayudar a configurar la replicación transaccional entre una base de datos sql server 2012 standard local y una base de datos sql server 2016 alojada en amazon web services.
Estructura y Dimensionamiento del Esquema
1. Los esquemas son idénticos.
2. Todas las tablas deben replicarse.
3. El tamaño de la base de datos es de aproximadamente 10GB (incluyendo documentos).
Tareas
1. Crear un breve plan de implementación.
2. Crear un script SQL para configurar el entorno de replicación.
3. Configurar alertas por correo electrónico para monitorear la salud de la replicación.
4. Configurar copias de seguridad de la base de datos y del registro.
5. Asegurarse de que el registro de la base de datos no crezca de manera incontrolada.
6. Establecer la seguridad en AWS
Category IT & Programming
Subcategory Desktop apps
What is the scope of the project? Small change or bug
Is this a project or a position? Project
I currently have Not applicable
Required availability As needed
Required platforms Windows
Delivery term: December 03, 2023
Skills needed