How we will bring missed 1000 rows to mirroed database?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hi ,

Recenttly some body asked in interview as below..

I am using database mirroring as high availabily. My question is in principal database one table is having 5000 rows but in mirroed database same table is having 4000 rows.How we will bring missed 1000 rows to mirroed database?

please tell me

Posted 28-Aug-14 4:15am

satyalaxman

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nelek · Answer 1 · 2014-08-28T06:18:00

Point 1:
I don't think that knowing the answer afterwards is going to bring you much. There is quite a high probability that you are not going to be invited by the same company who already discarded you (for other companies, please refer to point 2)

Point 2:
I don't think that knowing the answer afterwards is going to bring you much. There is no security that you will get the same question in different interviews.

Point 3:
If you don't know the answer, you will learn more studying and trying to solve it on your own, than asking for a solution in an internet forum. Probability to learn different things while trying to solve a single problem is higher on your own, than receiving a "ready-to-go" solution and learning it by heart.

Point 4:
If you don't know the answer to the questions asked in an interview, you probably are not the right guy for that job.

Point 5:
Due to point 4 it is quite probable, that you don't get a better answer than this.

Disclaimer:
I am being realistic and saying what many other users will probably think when reading the question. I don't try / want to be offensive to your person (if you think so, I am very sorry). I just think that sometimes a tiny kick in the ass, can make you wake up and consider that you are maybe approaching a problem from the wrong angle and need a change of actitude.