patternsqlMinor
Database Mirroring of SQL server
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
Clients can access those databases.
Questions
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.