SQL 2012 Mirroring

Hi Experts, we have had SQL mirroring setup on 2 SQL Standard 2012 servers (2012 R2 Datacenter). As of now the mirrored partner has gone down hard and the Principal databases are in Disconnected state. We need to rebuild the mirrored partner on new hardware. Is there something we should be aware of when rebuilding this mirror or can we stand up another SQL server and setup mirroring?

TIA
abhijitm00Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MarekCommented:
If your principal database is intact you can just rebuild the mirroring configuration with another mirror server.
0
abhijitm00Author Commented:
Thanks for replying Marek.

We have rebuilt the secondary server with the same name and IP. Will we just need to enable Mirroring on the Principal to set it up or do we need to a backup and restore of the full sql database followed by the transaction logs?
0
MarekCommented:
You would need the backups to rebuild mirroring, it's like configuring mirroring from scratch.
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

abhijitm00Author Commented:
Should the log backup that needs to be taken be a copy only backup or an actual transaction log? Thanks
0
MarekCommented:
To estabilish mirroring you need full and log backup on the principal database
0
abhijitm00Author Commented:
Thanks. If the backup is older for e.g. in our case backups are taken every 15 minutes on the principal server. By the time I get down to restore another backup would have run and I would not have the most current backup. I was under the impression that during mirroring the mirror database will catch up with the Principal. Won't that be the case? Thanks once again
0
Eugene ZCommented:
use AlwaysOn Availability Groups instead of
deprecated database mirroring

If your edition of SQL Server does not support AlwaysOn Availability Groups, use log shipping.
more:
Deprecated Database Engine Features in SQL Server 2014
http://msdn.microsoft.com/en-us/library/ms143729.aspx
0
MarekCommented:
For mirroring config you can follow http://msdn.microsoft.com/en-us/library/ms190941.aspx
Although mirroring is marked as deprecated, if you can't do AlwaysOn, mirroring may be still a good choice, since that does offer failover if you have a witness server configured (as wintess you can use even express edition)
0
DBAduck - Ben MillerPrincipal ConsultantCommented:
Mirroring requires you to restore the database full and the transaction log, in your case you either need to pause the log backups until you can successfully implement mirroring because the transaction logs are synchronized to the mirror from the principal and if you backup the transaction log on the Principal before establishing the mirror then the transaction logs LSN will not match up and it will not be able to send the tlogs.

So restore full, pause the backups of the log, back up the log and restore it over to the mirror, establish mirroring then resume the log backups.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.