Showing posts with label snapshot. Show all posts
Showing posts with label snapshot. Show all posts

Sunday, February 12, 2012

Can't Use "Transacional publication" Option (It's Grayed Out!)

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