August 25, 2010 at 12:04 am
Hi Experts,
I have created the Mirror between two server its working fine,
But
if my priciple database crashed or server crashed mean , how can we up the mirrored DB,
Because its in Norecovery mode.. while it mirroring.. so how can we bring for live .. is it any other way to set up Quikly that mirrored server
August 25, 2010 at 1:44 am
Here the staments you need for mirrored Db's
# Normal Failover (Both Partner are online) for Fallback, Maintenace or Testfailover.
ALTER DATABASE %DBNAME% SET PARTNER FAILOVER
## Emergency Failover (Pricipal offline)
ALTER DATABASE %DBNAME% SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
### Pause Mirroring
ALTER DATABASE %DBNAME% SET PARTNER SUSPEND
### Resume Mirroring after failed Server is online again
ALTER DATABASE %DBNAME% SET PARTNER RESUME
##Destroy Mirror Section
########################
## Stop Mirroring of Database:
ALTER DATABASE %DBNAME% SET PARTNER OFF
## Open Database:
RESTORE DATABASE %DBNAME% WITH RECOVERY
August 25, 2010 at 5:20 am
Many thanks,
can we mirror the database from sql 2008 r2 data center to sql server 2008 sp 2
August 25, 2010 at 6:15 am
Saravanan_tvr (8/25/2010)
Many thanks,can we mirror the database from sql 2008 r2 data center to sql server 2008 sp 2
i think there are no limitations beetwen this two editions in mirroring but in case of a failover you have other limitations like CPU etc.. So if your datacenter ist missioncritical you better have the same type of maschine etc.
August 25, 2010 at 6:27 am
R2 can be the mirror, but when/if it fails over to the R2 version then it will upgrade the database therefore failing back will not be an option to 2008.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply