Microsoft SQL 2016 AG restore

$10-30 USD

Complété

Publié

il y a presque 5 ans

$10-30 USD

Payé lors de la livraison

I have a 2 node AG running SQL 2016 Standard. We had an issue where the primary went off line and we switched to secondary. The primary was restarted and left and thought to have resynced buy the secondary site developed network problems. So I wanted to go back to primary but when I looked SQL service was not running. I started service but the data base is too far out of sync. This is a production system so we can have no downtime. My SQL guy is out sick so I am looking for someone to do this He says it is about a 10 minute job. PLEASE do not bid on job unless you know what needs to be done and have done it before. Thanks

SQL

Microsoft SQL Server

Database Administration

Database Programming

N° de projet : 20454856

Concernant le projet

7 propositions

Projet à distance

Actif à il y a 5 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@harihut

Hello Sir, Iam core SQL DBA with 10+ years of experience. Well versed in AlwaysON Configurations. I understand your problem. Please give me chance to work on this..Waiting for your mesaage

$30 USD en 1 jour

5,0

(13 commentaires)

4,2

7 freelances proposent en moyenne $24 USD pour ce travail

@AyavinSolutions

Hi, I have experience in doing this and can take up and complete right now. Please share the details. Regards Samira

$35 USD en 1 jour

0,0

(0 commentaires)

0,0

@nandasheetal22

I have 7.5+ years of experience in Oracle, SQL, PostgreSQL Development along with performance tuning. Have worked on SQL server backup, restore, import, export earlier and have good experience over it. Please let me know if you find me suitable for this job. We can discuss further.

$20 USD en 1 jour

0,0

(0 commentaires)

0,0

@saurabhdhanotia6

Here will be our strategy: 1. We will try Suspend and Resume Data movement. 2. 3. If step 1 didn't works, we have to stop all backups if any then re-configure AG by removing and adding Database.

$20 USD en 1 jour

0,0

(0 commentaires)

0,0

@monisateeque

Its not much complicated ( when it is done by a right person). Also, as mentioned by you - you are running AG on Standard edition, this means only 2 servers are involved (with only 1 DB in the AG) When he 2 replicas are out of sync, depending on the current state of the (old) primary (but now out if sync) database, we can try the following methods 1. SET HADR RESUME, or 2. Change the AG more from Sync to Async, and then change it back 3. Stop the backup-jobs (only) for the relevant DB on the (currently) Production replica. Reconfigure AlwaysOn (by taking the DB out of AG, restoring it from the Backups taken as recently as possible and then adding the DB back to the AG) When this is achieved Fail- over the AG to new server. And making sure its set as the Primary Replica. Some more steps will be added If you have added any new logins when your DB was live on the current server.

$25 USD en 1 jour

0,0

(0 commentaires)

0,0

@zurabjanezashvil

Hello, I am working now one of the largest Bank in Georgia, at DW Developer, MS SQL Server, so I think, I can help you, At first I can make something for you, FOR TEST, till we start the project.. My price is low, because I am new. I am ready for test job and waiting for your answer, thank.

$10 USD en 8 jours