Prev: Update SQL 2005 with spk2
Next: Err:The merge process could not enumerate deletions at the 'Pu
From: Quintin Zammit on 16 Apr 2007 10:01
Hi,

I am running SQL 2000 SP4 EE on 2 servers (1 remote and 1 local) and both
servers are serving only one resource hungry database. The data from certain
tables in the remote server is being replicated on the local server
continously via transactional replication. The transaction log files for the
remote database has increased substantially (over 50GB) and as a result the
server came low on disk space.

I had no option but to move the transaction log file, but in order to move
the log file I needed to detach the database. As the database was marked for
replication it did not allow me to clear the connections and detach the
database. I had to delete the replication, detach the database, remove the
log file, attach the database back and created the publication and
subscription.

Unfortunately only new data being generated is being replicated. When I try
to reinitialise the subscription the following error is being encountered: -
"Subscription 'subscription name' cannot be reinitialised automatically
because it was initialised manually when it was created. To reinitialise
this subscription, you must drop and recreate it.

Any help will be greatly appreciated.

Regards,
QZ


From: Paul Ibison on 16 Apr 2007 12:58
You can do another nosync initialization, or you could change the
subscription type to automatic and have a niormal ODBCBCP of data to the
subscriber.
Rgds,
Paul Ibison
From: Charles Wang[MSFT] on 16 Apr 2007 22:51
Hi,
I understand that you have a transactional replication. You recreated the
replication due to truncating the large transaction log; however you found
that only new data is being replicated and you could not reinitialized the
subscription.
If I have misunderstood, please let me know.

I think that this issue can be resolved by restoring your database on your
subscriber. Please refer to the section "Backing up and resotring a
subscription database" of this article:
Strategies for Backing Up and Restoring Transactional Replication
http://msdn2.microsoft.com/en-us/library/aa237094(SQL.80).aspx

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================



From: Charles Wang[MSFT] on 19 Apr 2007 09:53
Hi,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

 | 
Pages: 1
Prev: Update SQL 2005 with spk2
Next: Err:The merge process could not enumerate deletions at the 'Pu