I'm trying to come up with a db backup/Disaster Recovery plan using SQL
Server 2005 Mirroring and Log shipping and I need help understanding which o
f
the following plans is the most possible/practical.
The entire system has 2 loacation (primary & DR) with 2 servers at each.
Scenario #1
DB1 & DB2 are at Loc1
and
DB3 & DB4 (DR servers) are located at Loc2
DB1 is the primary pricipal server and DB3 is the mirror
Log Shipping is done from DB1 to DB2 and from DB3 to DB4
Question with scenario #1 is can log shipping be set up to run from from a
mirror server?
Scenario #2
Log Shipping from DB1 (Loc1) & DB3 (both Loc2)
and
mirroring from DB1 to DB2 (both Loc1) and from DB3 to DB4 (Loc2)
Can Mirroring be done from a server that is being udated via Log shipping?
Scenarion #3
Mirroring from DB1 to DB2
and
LS from DB1 to DB3 & DB4
Any suggestions welcom
Thanks
--
MGHave you read Books Online?
http://msdn2.microsoft.com/en-us/library/ms177412(SQL.90).aspx
How about this great article?
http://www.microsoft.com/technet/pr...5/dbmirror.mspx
There is a section titled: Database Mirroring and Log Shipping in this
article
Keith Kratochvil
"MGeles" <michael.geles@.thomson.com> wrote in message
news:BDB83C22-02A2-438E-9A09-5B2BED126836@.microsoft.com...
> I'm trying to come up with a db backup/Disaster Recovery plan using SQL
> Server 2005 Mirroring and Log shipping and I need help understanding which
> of
> the following plans is the most possible/practical.
> The entire system has 2 loacation (primary & DR) with 2 servers at each.
> Scenario #1
> DB1 & DB2 are at Loc1
> and
> DB3 & DB4 (DR servers) are located at Loc2
> DB1 is the primary pricipal server and DB3 is the mirror
> Log Shipping is done from DB1 to DB2 and from DB3 to DB4
> Question with scenario #1 is can log shipping be set up to run from from a
> mirror server?
> Scenario #2
> Log Shipping from DB1 (Loc1) & DB3 (both Loc2)
> and
> mirroring from DB1 to DB2 (both Loc1) and from DB3 to DB4 (Loc2)
> Can Mirroring be done from a server that is being udated via Log shipping?
> Scenarion #3
> Mirroring from DB1 to DB2
> and
> LS from DB1 to DB3 & DB4
> Any suggestions welcom
> Thanks
> --
> MG
No comments:
Post a Comment