hi,

on the page from soureforce.net there is no button to create an ticket, or to submit an bug.

Had andybody an idea, or an link, to get in contact with the...

Hi,

on the distribution-server i am able to run the sp "sp_replmonitorhelppublication" without error.

hi,

have you ever read this:

http://grumpydba.blogspot.de/2012/09/sql-2008-r2-reporting-services-wont.html

the services need maybe more time for respond. and with this link, you can set up the time for service to respond.

let me know it this...

Hi,

thanks for your reply. I had many replications, transactional replications. the biggest database is about 450 GB, and it needs about 14 hours, to create a snapshot, do deliver the...

did you a full backup of the transactionlog, or of the database?

i can only shrink my transactionlog if i made backup before.

with which Login you are looking for the database. Is this a member of sysadmin?

are there any results starting this query:

SELECT name

FROM master..sysdatabases

or

EXEC sp_databases

Hi,

here you can find information about mirroring with a witness-server:

http://technet.microsoft.com/en-us/library/ms189902.aspx

you have to put the witness-server in a datacenter 3, to avoid a crash with your mirror, if the datacenter 2...

Hi,

can you check, if the port is open?

http://angryip.org/w/Home

Hi,

are you sure, that thare are no primary keys in your tables. It is not possible to replicate a table without a primary key.

Hello,

i found my solution on this page, i hope it is okay to post it in this forum:

http://www.mssqltips.com/sqlservertip/2502/limit-snapshot-size-when-adding-new-article-to-sql-server-replication/

I could test this in my QA and it works.

thanks for you help,...

ok,

there are many articles on, I will rebuild it in the QA environment, and test.

thanks for your help, when I discovered it, I post it here in the topic

🙂

Hi John,

i read this page:

http://technet.microsoft.com/en-au/library/ms171864%28v=sql.105%29.aspx

"It is recommended not to add/drop indexes on replication columns in user tables. This results in synchronization failure because replication columns are treated as system columns....

Yep,

i read this page yesterday, when my trouble starts. But is there a difference between putting the new article via Microsoft SQL Server Management Studio or put the new article...

Hello,

after we had to life without our replication for about 20 hours, we have also considered setting up a second replication for the new table.

But, i think, we need every...

Hello,

thanks for your reply, but i don' understand everything.

How can i populate the new table?

And what do you mean with back-fill)

Is it possible, to create the table at the subscriber...