Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint?
Ans : 5022
2) Database Mirroring comes with which edition?
Ans: SQL Server 2005 SP1....
2014-11-17
20,515 reads
MSSQLFUN
Script to Monitor SQL Server Database Mirroring Status
SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database Mirroring send logs to mirror from principle. We need...
2014-11-13
16 reads
Script to Monitor SQL Server Database Mirroring Status
SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database...
2014-11-13
1,510 reads
Add Witness to Existing SQL Server Database Mirroring
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2. Click Configure Security, Configure Database Mirroring Security...
2014-11-10
13 reads
Add Witness to Existing SQL Server Database Mirroring
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2....
2014-11-10
4,006 reads
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working...
2014-11-03
12 reads
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of...
2014-11-03
6,416 reads
2014-10-29
3 reads
Add Database File on Database invloved in DB Mirroring
Add Database File on Database invloved in DB Mirroring.
2014-10-29
9 reads
Add Database File on Database invloved in DB Mirroring
MSSQLFUN
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file...
2014-10-29
691 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers