HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Database Mirroring of SQL server

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
databaseserversqlmirroring

Problem

I have two databases that are mirrored to another server using database mirroring.

The mirror server has to be down for some reason for few days.

Now, the production server is having principal databases in (PRINCIPAL/DISCONNECTED) State.

Clients can access those databases.

Questions

  • So what happens when they keep on adding data to these databases??



  • Will the data get committed or waits till the mirror comes up?

Solution

Your .LDF log is growing, as it cannot be truncated because the mirror is unavailable. Eventually you'll run out of space unless you either break the mirroring or bring the mirror back online.

Context

StackExchange Database Administrators Q#10082, answer score: 2

Revisions (0)

No revisions yet.