ORACLE AND MSSQLSERVER

What is the syntax to stop the Database Mirroring? Alter database set partner off Alter database set partner off

1In which Recovery model we can use in Mirroring? In mirroring the principal and mirror databases are used only full recovery model

What is Role-switching? Inter changing of roles like principal and mirror are called role switching.

Which Trace flag is used in Mirroring? Trace flags are used to temporarily set specific server characteristics or to switch off/on a particular behavior. 1400 Trace flag is used in mirroring. To set trace flag for Database mirroring:- Configuration Manager...

What are the Operating Modes and explain them? a. High Availability (principle+mirror+witness) :- High-availability mode, runs synchronously. Requires a Witness Server instance. The Principal server sends the log buffer to the mirror server, and then...

In which Operations are running the Operating Modes? Asynchronous:- Under asynchronous the principle server does not wait for the response from the mirror server after sneding logbuffer. Synchronous:- Under synchronous the principle server sends the log...

Explain about Principal, Mirror and Witness Servers? 1) Principal Server:- One Server serves the database to client is called Principal server and it having original data. Can have only one Principal Server and it has to be on a separate server. 2) Mirror...

What is End Point? How u create end point? An endpoint is a network protocol which is used to communicate Principal, Mirror and Witness servers over the network. Creation of an end point:- Create endpoint State=started/stopped/disabled...

How to monitoring Mirroring? There are six methods are available for monitoring the Database Mirroring a) Database Mirroring Monitor:- Database Mirroring Monitor is a GUI tool that shows update status and to configure warning thresholds. To open DM Monitor:-...

What is Log buffer? A log buffer is a special location in memory (RAM). SQL Server stores the changes in the database’s log buffer.