snapshot...
anything overwritten or lost.
"jaylou" <jaylou@discussions.microsoft.com> wrote in message
news:EE97BCC9-6445-44F4-BF33-D115DDD98B43@microsoft.com...
>I scrpited out my replication as a delete and create.
> I ran the delete with no issues, but when I tried to run the create that's
> when I fell into the compatibilty issue.
> i changed all the SQL 200 compatibity levels to 2005 and changed my script
> from 80rtm to 90rtm on the create statement of the script SQl generated.
>
> I reran the create and it created with no issues. I started my agent and
> synced my data since I only care about what happens here in my main office
> anything changed at my branch got overwritten if there were any changes at
> both places.
>
> Is that the same way you did yours? maybe you had a better solution, mine
> seemed to work for me but I am always looking for better and different
> solutions.
>
> "Rafael Lenartowicz" wrote:
>
>> John,
>> I had very similar situation just the other day, where somebody deleted
>> publication on SQL2000's level while
>> there were some pubs already created in 2005's level and I needed to
>> recreate the publication.
>> I somehow managed to fix it, but I'm afraid I might have lost some
>> unsynchronized data in the process - I'm not sure it was the best way to
>> do
>> it. Could you post step by step description how did you handle it?
>> thanks,
>> r
>>
>> "jaylou" <jaylou@discussions.microsoft.com> wrote in message
>> news:C284873D-DD99-45A5-A191-047EE33E004E@microsoft.com...
>> > Similar, but what I had to do was to change the compatibilty level of
>> > all
>> > my
>> > subscriptions to 2005 and I was able to add this new one back in.
>> >
>> > Thanks for the response.
>> >
>> > "Paul Ibison" wrote:
>> >
>> >> Is this related to your issue:
>> >>
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.replication&tid=4e5d642b-a4c0-4574-8bae-98fcc88e19b8&p=1 >> >> IE I'm wondering if you have a republishing setup.
>> >> Cheers,
>> >> Paul Ibison SQL Server MVP,
>> >>
www.replicationanswers.com >> >>
>> >>
>> >>
>>
>>
>>
