I am running SQL 2K & Win 2K. I restored a backup, to a
different name, that was being replicated when it was
backed up. After the restore, I cannot detach the
backup, because SQL thinks it is being replicated. How
can I fix/detach this dB?
Larry,
have a look at sp_removedbreplication 'dbname' and sp_replicationdboption in
BOL.
Regards,
Paul Ibison
|||If sp_removedbreplication doesnt work you can update the category column in
sysdatabases to 0
Thanks
Gopal
|||If working inside the database, you may also have to manually set the
replinfo column in sysobjects to 0.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
Showing posts with label win. Show all posts
Showing posts with label win. Show all posts
Monday, March 19, 2012
Sunday, March 11, 2012
Deletes in the subscriber
Hi,
I'm having a problem with replication.
The situation is the following:
Operating System of the server: Win server 2003
Database: SQL 2000
Subscribers: SQLCE in PDA's HP5550
Number of subscribers: 23
Subscription: Daily
Somme of the subscribers (PDA) take some a long time to process all the information from the replications. This process of replication take 30 to 45 minutes. In the replication monitor i see that it sends something like 230 000 deletes. It′s a lot for a
PDA processing.
What can i do to improve this situation.
Thatk's for your atention
Best Regards
PPereira
Hi PPereira,
You might be interested in the following document:
Diagnosing and Troubleshooting Slow Partitioned Merge Processes
http://msdn.microsoft.com/library/de...artitioned.asp
Hope this helps,
Reinout Hillmann
SQL Server Product Unit
This posting is provided "AS IS" with no warranties, and confers no rights.
PPereira wrote:
> Hi,
> I'm having a problem with replication.
> The situation is the following:
> Operating System of the server: Win server 2003
> Database: SQL 2000
> Subscribers: SQLCE in PDA's HP5550
> Number of subscribers: 23
> Subscription: Daily
> Somme of the subscribers (PDA) take some a long time to process all the information from the replications. This process of replication take 30 to 45 minutes. In the replication monitor i see that it sends something like 230 000 deletes. It′s a lot for
a PDA processing.
> What can i do to improve this situation.
> Thatk's for your atention
> Best Regards
> PPereira
I'm having a problem with replication.
The situation is the following:
Operating System of the server: Win server 2003
Database: SQL 2000
Subscribers: SQLCE in PDA's HP5550
Number of subscribers: 23
Subscription: Daily
Somme of the subscribers (PDA) take some a long time to process all the information from the replications. This process of replication take 30 to 45 minutes. In the replication monitor i see that it sends something like 230 000 deletes. It′s a lot for a
PDA processing.
What can i do to improve this situation.
Thatk's for your atention
Best Regards
PPereira
Hi PPereira,
You might be interested in the following document:
Diagnosing and Troubleshooting Slow Partitioned Merge Processes
http://msdn.microsoft.com/library/de...artitioned.asp
Hope this helps,
Reinout Hillmann
SQL Server Product Unit
This posting is provided "AS IS" with no warranties, and confers no rights.
PPereira wrote:
> Hi,
> I'm having a problem with replication.
> The situation is the following:
> Operating System of the server: Win server 2003
> Database: SQL 2000
> Subscribers: SQLCE in PDA's HP5550
> Number of subscribers: 23
> Subscription: Daily
> Somme of the subscribers (PDA) take some a long time to process all the information from the replications. This process of replication take 30 to 45 minutes. In the replication monitor i see that it sends something like 230 000 deletes. It′s a lot for
a PDA processing.
> What can i do to improve this situation.
> Thatk's for your atention
> Best Regards
> PPereira
Subscribe to:
Posts (Atom)