<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Database Design
»
Disaster Recovery
»
mirroring scenario
mirroring scenario
Rate Topic
Display Mode
Topic Options
Author
Message
djordan 4543
djordan 4543
Posted Monday, April 04, 2011 10:49 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:37 AM
Points: 29,
Visits: 129
Can you have this mirroring scenario.
Principal sql server 2008 standard engine
Mirror sql server 2008 R2 enterprise engine
Thanks!
Post #1088428
GilaMonster
GilaMonster
Posted Monday, April 04, 2011 11:50 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 11:45 AM
Points: 37,744,
Visits: 30,023
Yes, but it's not supported except during an upgrade scenario. (upgrading a 2008 mirror pair to 2008 R2). If you ever fail to the mirror, you will not be able to fail back without upgrading the principal to R2.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1088447
djordan 4543
djordan 4543
Posted Tuesday, April 05, 2011 12:04 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:37 AM
Points: 29,
Visits: 129
I'll tell you why we want it - from your explanation seems like we are good to go with that.
We need to replicate a database from one site to another for the sole purpose of reporting. The BI guys insist on a incremental load. I did try transactional replication but had schema issues (schema_binding on functions did not allow replication of table because it could not drop them). Therefore thought this method may be better. Seems to work well when editions on principal and mirror is the same!
Post #1088451
GilaMonster
GilaMonster
Posted Tuesday, April 05, 2011 1:22 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 11:45 AM
Points: 37,744,
Visits: 30,023
I strongly do NOT recommend mirroring with different versions. The mirror should also be 2008 if the principal is SQL 2008. The setup you described is intended to work only for a short time during the upgrade process.
Have you considered log shipping? Ship with standby (also requires same version) and the database is read only automatically. You could set the restore job to restore after hours only so that there are no disconnects.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1088465
djordan 4543
djordan 4543
Posted Tuesday, April 05, 2011 1:26 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:37 AM
Points: 29,
Visits: 129
why do you think the log shipping needs same versions of sql? Is it for the same reason?
Post #1088469
GilaMonster
GilaMonster
Posted Tuesday, April 05, 2011 1:47 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 11:45 AM
Points: 37,744,
Visits: 30,023
djordan 4543 (4/5/2011)
why do you think the log shipping needs same versions of sql?
Because restore WITH STANDBY does not work in an upgrade scenario (primary lower version than secondary). It'll throw an error when you try to restore. Restore with NORECOVERY does, but that does not allow for reading the secondary server
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1088474
Craig Purnell
Craig Purnell
Posted Tuesday, April 05, 2011 5:43 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 5:40 PM
Points: 199,
Visits: 469
For our reporting database, we use log shipping with the standby option and only restore logs at night. It works real well.
Post #1088530
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
