| Author |
Topic |
|
memarcie
Yak Posting Veteran
91 Posts |
 Posted - 2007-09-18 : 10:12:00
|
| I'm setting up replication for the first time on a new development server. When I use the publication wizard all the tables are shown as locked? I don't have the option to select any tables and the show in the wizard with a key and a red X. What does this mean? How do I change it?Thanks,Marcie |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-09-18 : 12:17:04
|
| Thats means you are doing Transactional replication and every table should have a primary key. Red X and key means there is no primary key. |
 |
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-09-19 : 08:17:50
|
| Thank you, I recreated as a snapshot and it failed last night. I'll be trying to figure this out today. |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-09-19 : 08:25:27
|
| Can anyone tell me what this means "I/O error while writing BCP data-file". This is the Error detail from the Snapshot agent. It seems pretty self explanitory, but I don't have a file named BCP, so not sure what that refers to. Thanks,Marcie |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-09-19 : 08:29:57
|
| This is the error message: "The process could not bulk copy out of table '[dbo].[syncobj_0x4141453135373944]'." |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2007-09-19 : 11:06:12
|
| BCP is the Bulk Copy Process. I didn't realize that replication used BCP but it makes sense to use it. |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-09-19 : 12:30:46
|
| Is there a way to find out what table it is referring to? '[dbo].[syncobj_0x4141453135373944]'? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-19 : 23:37:28
|
| What's sql sp level? What's sql service account? Are those servers in same domain? How did you set replication? |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-09-26 : 07:51:46
|
| I'm doing a snapshot replication. Do the tables need to have a primary key? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-26 : 23:28:54
|
| No. |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-10-15 : 12:48:13
|
| My problem causing the error "I/O error while writing BCP data-file" was caused because of not enough space on the drive where the snapshot was being created. |
|
|
|
|
replication - creating subscription