|
|
|
April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 snapshot replication problem Posted by Martin Miethe at 7/31/2006 4:35:36 PM Hello Group,
I had to deactivate my snapshot replication (I deleted it) for a
modification on some tables.
I was replicating 3 small tables to another machine which serves as an
webserver.
I set up the replication again, but it does not seem to work.
I use a schedule (once an hour) for t...more >>
Perform Mirror-Changes to All Databases Posted by Zakir at 7/31/2006 12:43:56 PM Hi,
We're setting up a mirrored database environment with SQL Server 2005.
>From what I have found, we have to perform mirror actions for each
database seperately. Is it possible to perform these standard actions,
such as failing over the database the other sever, to all the mirrored
databases ...more >>
Optimization of network traffic for transaction replication Posted by andsm at 7/31/2006 5:23:02 AM I have schema with transaction replication which has multiple publishers and
one subscriber. And I want to minimize traffic. One way which I see is usage
of hardware compression on Cisco routers.
Are any other ways to reduce network traffic used by transaction
replication? May be with usage o...more >>
Validate subscriptions Posted by Deni at 7/29/2006 7:29:01 PM SQL server 2000
replication - Tran with read only subsriber
When i run Validate subscriptions on publication i see error as below :
SQL server enterprise manager could not validate subscriptions.
Error 20585: Validation failure. Object '(null)' does not exist.
Any idea what is wrong ?...more >>
start agents every 30 secs Posted by Hassan at 7/29/2006 11:53:44 AM I would like to start the agents every 30 secs as opposed to the current
continuos mode for our SQL 2000 transactional replication setup.
Time and again, we have our log reader and distib agents timing out and then
after 10 attempts they fail and then we have to manually go and start them
...more >>
Query Optimisation Posted by Eckhart at 7/29/2006 12:45:34 AM DearAll,
I applied the modifications by implimenting the joins,created indexes
on relevent columns which are acting as optimizer hints-result positve
improvement in the query processing,apart from that there is one more
issue thats supposed to be considered for code reusablity,
Eg: When on mor...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |