Chris,

I bring this topic back the forum bcs it did not work.

The subscriber’s tables continued be deleted when I delete some records on publisher’s tables.

I have tested with both scripting...

Markus,

I review Kimberly Tripp webcast.

She suggested to create filegroup for DB > 100 GB.

For best practice, what is your advise.?

Also, this db is going to use for replication.

THank you for...

Steve,

I attended a Microsoft official parthner training in Dallas once. However, I was dissapointed with the trainner. He just read the book and not much hand on.

Did Michael Hotek...

What is the fixed around.?

I listened to Kimberly Tripps webcast. If I am not mistaken, she advised to create file group for DB > 100 GB.

Any suggestions.?

Thank you.

TJ

Weird!!! I selected all publisher article and run the snapshot once.

It works!!! Thanks a lot.

TJ

Steve,

I tried reinitialize Subscription several times but it did not work.

Then I tried to replicate Northwind database and it works.

Will those specific publisher database tables prevent or cause snapshot failed.?

However,...

Hi Steve,

Before setup the database push or pull replication. I tested the TCP/IP port 1433 on dos prompt.

In sql server 2005, I ping the sql server 2000 ip address.

Ping...

THank you for the help.

Best regards,

TJ

Chris,

I performed some testing on my local box between sql server 2005 (subscriber) and sql server 2000 (publisher and local distributor).

I found out an odd. The transaction replication still...

Chris,

Not sure where located in GUI.

Is located in ----> Table Article Properties ---> Commands tab-->

Replace DELETE command with thhis stored procedure call.

Again, thank you for your kind help.

TJ

Chris,

Thank you for your help.

Enclosed is my database replication scripts

use master

go

--- Create an entry on the sysserver tables, mark it as the Distributor

--- and stores property information.

--- heartbeat_interval in minutes

EXEC...

Chris,

Apologies for misspelled your name!!!

Here is my database replication scripts:

use master

go

--- Create an entry on the sysserver tables, mark it as the Distributor

--- and stores property information.

---...

Hi Christ,

Looking at your script

---SQL2000 syntax

exec sp_addsubscription @publication = 'PUBNAMEHERE'

, @article = 'all'

, @subscriber = 'SUBSCRSERVERNAME'

, @destination_db = 'DBNAME'

, @sync_type = 'none' --...

Thank you for your responses. I am very appriaced your advises.

The actual DB size is 120 GB ++ and it keep growing.

Best regards,

TJ 🙂