Used the Wizard to Creat Publication for the first time.
I saw three choices "Snapshot publication", "Transacional publication"
and "Merge publication".
I wanted to slect "Transacional publication" but it was grayed out. I
wonder why!!
Created a database with one table on server A.
Created same database with same table on server B.
I'm making A the publisher/distributor and B the subscriber.
The Recovery Model for both database on both servers is 'Full' model.
I backed up a transaction log.
How can I get to select Publication using the 'Transaction' type?
Thank you very much
Mike
*** Sent via Developersdex http://www.codecomments.com ***
I suspect your SQL Server version is MSDE - transactional replication is not
supported on MSDE - upgrade to SQL Server standard.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mike" <-nospam@.yahoo.com> wrote in message
news:OBwQbcz2FHA.3600@.TK2MSFTNGP12.phx.gbl...
> Used the Wizard to Creat Publication for the first time.
> I saw three choices "Snapshot publication", "Transacional publication"
> and "Merge publication".
> I wanted to slect "Transacional publication" but it was grayed out. I
> wonder why!!
> Created a database with one table on server A.
> Created same database with same table on server B.
> I'm making A the publisher/distributor and B the subscriber.
> The Recovery Model for both database on both servers is 'Full' model.
> I backed up a transaction log.
> How can I get to select Publication using the 'Transaction' type?
> Thank you very much
>
> Mike
> *** Sent via Developersdex http://www.codecomments.com ***
|||(...or Personal Edition).
Paul Ibison
No comments:
Post a Comment