Comment restaurer une base SQL Server mise en miroir??

Si vous essayer de restaurer une base de données mise en mimoir avec une autre instance, vous allez rencontré ce message d'erreur:

__________________________________________________________________________________________
TITRE : Microsoft SQL Server Management Studio
------------------------------

Échec de Restaurer pour Serveur « SQLAAA01\MSSQLAAA01 ».  (Microsoft.SqlServer.SmoExtended)

Pour obtenir de l'aide, cliquez sur : http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6000.34+((KJ_SP3).140819-1214+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restaurer+Server&LinkId=20476

------------------------------
INFORMATIONS SUPPLÉMENTAIRES :

System.Data.SqlClient.SqlError: Impossible d'effectuer l'opération RESTORE sur la base de données 'APRD' car elle est configurée pour la mise en miroir de bases de données. Utilisez ALTER DATABASE pour supprimer la mise en miroir si vous avez l'intention de restaurer la base de données. (Microsoft.SqlServer.Smo)

Pour obtenir de l'aide, cliquez sur : http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6000.34+((KJ_SP3).140819-1214+)&LinkId=20476

------------------------------
BOUTONS :

OK
------------------------------

Pour résoudre ce problème et faire la restauration voici les actions nécessaires:

Supprimer la mise en miroir:

Propriétés de la base -- Page 'Mise en miroir' -- Bouton ' Supprimer la mise en miroir'

Confirmer la suppression.

Avec T-SQL:

ALTER DATABASE APRD SET PARTNER OFF

Restaurer la base de données

Comme vous le habituellement, restaurer la  base de données sur les deux instances mises en miroir.

La restauration sur le site secondaire est nécessaire pour ne pas avoir le message d'erreur suivant:

Error : Msg 1408, Level 16, State 0, Line 1

The remote copy of database "Mirroringdatabase" is not recovered far enough to enable database mirroring.




La restauration sur le site secondaire est nécessaire pour ne pas avoir le message d'erreur suivant:



Rétablir la mise en miroir



-- Sur la base secondaire



ALTER DATABASE APRD

SET PARTNER = 'TCP://PRINCIPALSERVER.ENVIRONMENT.DOMAIN.NET:5022'









-- Sur la base principale 




ALTER DATABASE APRD

SET PARTNER = 'TCP://MIRRORSERVER.environment.domain.net:5023'

Overview of what I did and what I'm doing

The begin

Recently graduated and perfectly motivated to learn every little thing about the professional world i followed this plan:

Watch what my n+1 do: it's so important to have an idea what your superior do in order to decide on your carrer, to see if it's really what you want or not, if it's really interresting or not.

In my case I see that my n+1 is very talented in systems and applications support, he was admired by all the company thanks to its helpfullness.

He has always a long "to do tasks" list, he delegate to me some of these tasks, the most borring for him- I think- and the most interresting for me at this moment. I took care of every step on the task guide and I ask him about every word and I suggest some modifications.

5 months later ...

After only five months, he announced to me that he will leave the company.And he left after a month.

I was disturbed because I'was nominated to get my n+1's duties that were:

Manage a hundred of environments hosted on an outsourcing platform:

Clone environments

Stop/start

Troubleshooting

Fix issues

Manage Oracle databases

It was a great period ! I developed many skills, both technical and behavioral.

I had a very good entourage, with very good skills and very good behavior, they really helped me to build my career and my personality.

2 years later ...

Two years after, the team has a new organisation and new members who didn't know, I think,  what the team really do and what is its position on the support process, got the lead of the team.

I was very angry because I had in mind that support team manager must have the minimum skills to investigate if a problem occurs on the platform and because the new leaders didn't have this minimum. I always asked: If I had a problem, to whom I should escalate?

Anyway, I kept the high moral and the positive attitude and the stress has been eliminated in a short period of time.

I had the same day-to-day tasks, that's why I have known deeply what I'm doing.

I had been the reponsiblity to move to customers in order to install the product.

5 years, a good time to change the scope

Before the end of my fifth year on the same team, with the same tasks and mainly with the same moral, I felt that is time to change. I had the opportuinity to move to another team. A 2-persons- team: my manager and me.

until now, I'm with this new team.

We provide support for our customers in Middle East and Africa region. Main tasks are:

New installation

Cloning

Fix issues

Release upgrade

Audit

Servers replication

I have 80% of my old duties, but now the chalenge is bigger because I'm directly facing the customer.

I have to learn more and more, not only about our product, but also about all related technologies.

Et la vie continue ...

What is Systems and Operations  Engineer?

According to Whatis.com a Sysops person is one who runs the day-to-day operation of a server and the term suggests a person who is available when the system is. 

I'll share throught this blog my day-to-day experience - if I'll have the time of course :)

I'll try to share here my knowledge, my success, my failures, my mistakes etc ...

My publications will be in english, french and sometimes in arabic.

I hope that it will help some other people.

Regards,
Akram.