November 26, 2012 at 12:01 am
Thank You, Bhuvnesh. Now I am clear.
November 26, 2012 at 1:27 am
shohelr2003 (11/23/2012)
Now for some reason I wanna restore database to my principal from another databse.Will it cause any inconsistency in mirror databse?
Yes, of course the databases will be totally out of sequence!!
shohelr2003 (11/23/2012)
Or may I need restore database and log backup from that another database to mirror database?
Break the mirror, restore the principal, restore the new mirror from the newly restored principal, setup mirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 3:49 am
Thank You, Perry Whittle. But what does "database will be totally out of sequence" mean?
November 26, 2012 at 4:33 am
means both servers are not same from data (even sql objects too ) perspective
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 5:55 am
shohelr2003 (11/26/2012)
Thank You, Perry Whittle. But what does "database will be totally out of sequence" mean?
The LSNs and hence restore points will be completely different between databases, it would make sense for you to read up a little on how database mirroring works 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 10:41 pm
Perry Whittle (11/26/2012)
The LSNs and hence restore points will be completely different between databases, it would make sense for you to read up a little on how database mirroring works 😉
+ 10
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 11:35 pm
Thank all specially Bhuvnesh and Perry Whittle for your kind help.
I have gone through database mirroring configuration and now I will go through how database mirroring works.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply