Question : After doing a failover to mirror database, the application is throwing below error Login failed for user ‘NT […]
Tag: mirroring
Does Traceflag 1800 require a restart?
Question : We have recently migrated our database mirroring secondary to new hardware. The log drive (and other SQL Server […]
Troubleshooting Mirroring Configuration
Question : I am configuring database mirroring on SQL Server 2012. After configuration I am getting the following error when […]
MSSQL Mirroring + db integrity check
Question : Is it necessary to do a database integrity check (DBCC check) on mirrored databases? https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/automatic-page-repair-availability-groups-database-mirroring?view=sql-server-2017 Automatic page repair […]
Transaction Log and mirroring – looking for dumbest explanation possible
Question : First of all I must admit that I struggle with concept of Transaction Log. I mean – I […]
Mirroring after restoring the database on a new machine
Question : We’ve had alot of problems with one of our database servers and two days ago the call was […]
Microsoft SQL Server Error 1475 when Mirroring
Question : Could anybody help me please. I am trying to mirror our SQL Server 2005 to our DR site. […]
How to safely resume a SQL Server Mirroring scheme that had a expired certificate?
Question : We have a production database with a SQL Server 2012 Mirroring scheme with three machines: Principal, Mirror, Witness. […]
Sql Server Mirroring Failover and Failback
Question : I have the following mirroring setup for DR. Principal (ServerA) Mirror (ServerB). When we do a DR test […]
Ola Hallengren with database mirroring
Question : I am about to setup Ola Hallengrens database maintenance plan. We have our database mirrored and I was […]