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.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 Mirroring question

Author  Topic 

jreid
Starting Member

2 Posts

Posted - 2008-09-24 : 09:09:26
I'm hoping someone can help out a Noob with sql and mirroring question. If your primary database has some data corruption, does that corrupt data get sent to the mirrored database? Thanks in advance.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-24 : 15:02:45
I had the same question with Microsoft regarding this issue.I didn't get perfect feedback regarding this. But in SQL 2008, upon research, I got that if there is suspect pages in Principal database ,it won't be mirrored to secondary until it is repaired.
Go to Top of Page

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2008-10-01 : 11:32:32
Yes thats true for SQl Server 2008
Go to Top of Page
   

- Advertisement -