database mirroring QUESTIONS

1. What is database mirroring?
2. In which SQL Server version it was introduced?
3. Why mirroring why not Log shipping?
4. What are the difference between Log Shipping and mirroring?
5. Can you explain the specific usability of mirroring, Log Shipping and Replication?
6. What is prerequisite, recommendation and restriction to configure mirroring?
7. Can we configure mirroring between different editions of same SQL Server version?
8. What is alternate of mirroring in SQL Server 2012 and 2014?
9. Do we need SAN to configure mirroring which support failover?
10. Can we configure mirroring on 32 bit version or only on 64 version?
11. What is restriction if use 32 bit machine?
12. Can we configure mirroring between 32 and 64 bit machine?
13. Can witness SQL version differs from principle and mirror server?
14. Can we upgrade SQL while mirror is configured? If yes How?
15. Can database recovery model have in Bulk-logged mode?
16. Can we restore principal database to mirror database in other than NORECOVERY mode? If yes then which state?
17. Can Log Shipping and mirroring configure together?
18. Can we mirror system database like master, msdb, model, and tempdb?
19. Can we renamed mirrored database?
20. Does mirroring support FILESTREAM file group?
21. How many database mirroring can configure per instance on 32 bit of machine?
22. Does mirroring support cross database transaction or distributed transaction?
23. What is recommended CPU usage if configure mirroring in High Safety mode on both the server?
24. Is drive letter required to be same on both the server?
25. Can we place same datafile on different drive on principal and mirror server?
26. If drive letter is different on both the server. Then what is the steps to add a new datafile?
27. Can we have different collation setting on both the database?
28. What does mean by dedicated network adaptor?
29. Is High Safety mirroring is recommended on WAN network? If not then why?
30. What is synchronous and asynchronous operating mode of mirroring?
31. What is different mode of mirroring?
32. Which mirroring mode is recommended?
33. What is best practice of configuring database mirroring mode on production server?
34. What is difference between High safety and High performance mode?
35. What is transaction safety setting?
36. What is the role of witness in mirroring? When we need to set up witness too?
37. What is status of mirror server shows in case of principle server is unavailable in high performance mode?
38. What is different role switching is available?
39. What is hot standby and warm standby server?
40. Please explain how log transmission and transaction commits work in high performance mode and in high safety mode?
41. Which operating mode run with minimum transaction latency?
42. When I High-Performance mode is more appropriate?
43. What is the impact of witness if we setup in high-performance mode?
44. What is step to up the mirror server in case of principle server is unavailable in high-performance mode?
45. What is step to up the mirror server in case of principle server is unavailable in high-safety mode?
46. Explain how role switching works high-safety mode? What the impacts if we setup mirroring with automatic failover and manual failover?
47. What is SAFETY FULL and SAFETY OFF?
48. Is quorum is required to setup witness?
49. What are the different state of witness server? When it shows CONNECTED and DISCONNETED or UNKOWN?
50. What are the different system catalog tables available to monitor monitoring?
51. Please explain below operating mode?
52. Can you please explain 3-4 important column and its possible value of sys.database_mirroring table?
53. What is SQL query to set/change operating mode?
54. Can we configure witness in High-performance mode?
55. What are the different type of quorum are possible in setting up mirroring?
56. What is the role switching?
57. What are the different type of role-switching is available and which operating mode it uses?
58. Can you please explain how
59. What is the steps of upgrade SQL on both the partner? Please explain all the steps?
60. What is different mirroring state is available? Please explain below:
61. Can you please go through setting up mirroring steps?
62. Did you ever setup mirroring using query? If yes please have few query uses?
63. What are different authentication mode use in setting up mirroring? Please explain its implication
64. How can you pause and resume mirroring? Can I have the SQL query?
65. Can you please tell what the different way you use to monitor your mirror? Which later help you troubleshoot the issue in case?
66. What are different system stored procedures available to monitor overall monitoring health?
67. What is database mirroring endpoint?
68. What is default database mirroring endpoint?
69. Does this port is different in AG or same?
70. Can we configure mirroring without setting up endpoints?
71. Can we have multiple endpoints setup for different mirroring database in SQL instance?
72. How you create an endpoint? Can I have its query?
73. Can you share some troubleshooting you did in mirroring?
74. What you do when you see redo log is keep accumulating at principle server?
75. Is there any recommended step when you do any BCP operation on principle server?
76. Suppose your table size is of 300 GB and you have to rebuild it. Tell me what is the precautionary step you will take so that your mirroring should not be effected?
77. What is the step to move datafile in mirroring? Please step out every steps?
78. What will happen if I delete any datafile on principle server? Will it affect mirroring session?
79. Can you tell me how mirroring service both high availability and Disaster recovery?
80. Is this is now degrading features of SQL Server?