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 |
|
rborias
Starting Member
1 Post |
 Posted - 2008-07-16 : 10:57:54
|
| HelloNeed alittle help here is possible. I am new to SQl replication and not really a DBA but its my job here. I have just set up SQL repliaction between 2 servers. I have it set for snapshot replication. Finally got it running with out initial errors.I tested a small citrix DB and can get it to replicate with no errors. Now when I do a 14 gig app DB I am getting errors. I am the error "invalid column name (insert column name)". It's an app created column. Even if I uncheck not to add this one it still tries to replicate it. I tried on the subscription end to restore the DB and start the replication to letting the DB replicate fully. I still get that error.What I can do or look for to resolve this issue? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 13:34:48
|
| What column and datatype is it? Can you elaborate? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 22:50:45
|
| Did you enable replicate schema changes? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 23:13:26
|
quote:
Originally posted by rmiao
Did you enable replicate schema changes?
It comes by default in SQL 2005 Replication. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 23:16:18
|
| But many people disabled that. |
|
|
|
|
|
|
SQL 2005 replication