Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nic_jones
Starting Member
3 Posts |
 Posted - 2009-10-01 : 16:27:03
|
| If we were to implement a Primary, Mirror and Witness and the database becomes corrupted with the Primary and Mirror dbases both corrupted in the same way, how and to what point can we recover?There's some debate in our team as to where we can recover to. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
nic_jones
Starting Member
3 Posts |
Posted - 2009-10-02 : 03:50:05
|
| Hi & thanks for your answer.Assuming we still have the transaction logs, would it be possible to recover up to the last transaction or can we only recover the transactions in the previous transaction log?Thanks |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-02 : 05:08:08
|
| It's very unlikely for the principal and the mirror to both be corrupt the same way. Corruptions are usually a problem with the IO subsystem and hence won't be mirrored.Providing the corruption's not in the log file, you should be able to get right up to the last transaction, providing you have a clean database backup and all the log backups since then.--Gail ShawSQL Server MVP |
|
|
|
nic_jones
Starting Member
3 Posts |
Posted - 2009-10-02 : 05:43:23
|
| Many thanks |
|
|
|
|
|
|
Recovery point