Database mirroring

Question

Database mirroring

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

Schadenfreude-Mei (12/5/2008)
Gail: BES is Blackberry Enterprise Server
According to the instructions from the BlackBerry web site, for DR purposes you have to setup Transactional Replciation (there is a script to run which identifies one from the other from BES). But they are quitw clear to set to FULL recovery model.
Off the BES subject for a sec, I have always been told that I cant have Simple for replication, if this is not so I would love to know how. I did a quick test on my desktop b4 my last post and could not see table additions on my subscriber db after and update to the publisher. Then I switched to FULL and reinitialized and it worked.
So what am i doing wrong?

As have stated you can do Transactional Replication with simple recovery, how dow the BES work? does it use a form of SQL replication.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Schadenfreude-Mei (12/5/2008)
I have always been told that I cant have Simple for replication,

Whoever told you that is mistaken

if this is not so I would love to know how. I did a quick test on my desktop b4 my last post and could not see table additions on my subscriber db after and update to the publisher. Then I switched to FULL and reinitialized and it worked.
So what am i doing wrong?

Don't know. By table addition, do you mean insert into or create table and add to publication?

Here's the screen shot I promised earlier. The name of the DB is hidden, because it's a client's name, but I promise it's the same DB. The replication (with both DBs in simple recovery) is working fine. I just did a whole bunch of updates, watched the log reader pick them up, then went to the subscriber DB, queried the table and all the changes were there.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 3

Don't know. By table addition, do you mean insert into or create table and add to publication?

Insert into a table. Litteraly opening a table, adding a row and whatching the log reader.

Adam Zacks-------------------------------------------Be Nice, Or Leave

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Schadenfreude-Mei (12/10/2008)
Insert into a table. Litteraly opening a table, adding a row and whatching the log reader.

I don't know why that's not working. I did exactly that (except I wrote the insert statement in a query window), on my publisher (simple recovery). By the time I connected a query window to the subscriber (simple recovery), the row was there. The log reader's status showed 1 transaction with 1 statement replicated.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 5

How did you configure snapshots? Did you initialize?

Adam Zacks-------------------------------------------Be Nice, Or Leave

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Snapshots?

It was existing transactional replication that I set up a couple months back to test some stuff and never dropped.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 7

I just tested successfully. But the last two attempts failed. Now I'm not sure what to do.

The BES databases in single (none replicated) mode runs as simple but when setting up replication the instructions say to set to full. Im not sure if this was back in the 2000 days.

The errors I got were to do with growth so ideally i should go back to simple (cant see a reason not to) but then there are the instuctions :w00t:

So confused. 🙁

Thanks for your help Gail.

Adam Zacks-------------------------------------------Be Nice, Or Leave

steveb. SSC-Forever Points: 46733 More actions · Answer 8

You could try and insert a tracer token to see what your latency is like, there may be network issues that are causing a problem

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 9

Heye steveb,

No latency is fine, cause it all running locally, plus the new test which work happens straight away.

I think i just screwed up on past tests. Have always hated repl 🙁

Adam Zacks-------------------------------------------Be Nice, Or Leave