Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pontifikas
Starting Member
32 Posts |
 Posted - 2006-06-21 : 03:07:18
|
| I 'm trying to set up transactional replication.The two servers are ready for replication(login accounts, registration properties, all set).I successfully set up server1 as distributor, the replication monitor appears on the entreprise manager and I set off to create the publication.When I reach the point where I have to select between the three types of replication, I see that I'm not allowed to choose Transactional replication.Only merge and snapshot.Why is this happening. Has it something to do with server installation options-tools not set correctly?I'm talking about an Sql server 2000 on Windows 2003 Enterprise Ed.I Thank you in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-21 : 04:03:11
|
| Is the database using simple recovery model?Needs to be bulk or full for transactional repliction.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Transactional replication not allowed!!