Thanks,

I am running 2005 shop with SP3

Publisher 2005

Distributor 2005

Subscriber 2005

Want to upgrade

FIRST Distributor 2008

and Subscriber 2008

later on after a month

Publisher to 2008

that should work?

Thanks

hi, how upgrade work. can I

upgrade publisher from 2005 to 2008 first

or first I have to upgrade distributor/subscriber from 2005 to 2008

but, can I create publication on 2008 and subscription on 2005:-)

Thanks, do you have any document?:cool:

hi guys,

someone can help me to understand.

can I keep the subscrption on 2005 server and upgrade distributer and publisher to 2008:hehe:

Thanks, i will try thins afterhours

Thanks Gail,

somehow(by mistake) this db is also use as publisher too, but I am not replication any data for that database.

I am 110% sure this db is a subscriber

Transaction information for database 'DB_Replicated '.

Oldest active transaction:

Replicated Transaction Information:

Oldest distributed LSN ...

this db is subscription db, i stop the log reader job and then run the shrink the db but it is not shrinking the log file.

I want to shrink the log file, I try to stop the distributor agent job, so tran going on, but when I run this

select name,log_reuse_wait, log_reuse_wait_desc from sys.databases

I...

I do not mind the growth, but want to shrink the log file, that is not happening

still I have 35GB free space, but the log file increasing very fast. I already add two files

Logreader is running, latency rate is good.

I don't now what else wrong.

Log reader is running, I will stop the logreader after the production is done tonight, then try to shrink the database.

if you know any other way pl let me know.