|
|
|
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 Where are my primary keys? Posted by Jude at 10/14/2007 9:32:03 PM Sql Server 2000 - SP4
Transactional Replication
Snapshot replaced all my primary key indexes on the subscriber db with =
Unique Clustered Indexes & named them things like =
"MSCCSPK_20070818113232139"
Why?=20
How do I get my subscriber db back to the way it was, with primary keys?
--=20...more >>
Replication Errors Posted by Dan Kotarski at 10/11/2007 12:00:00 AM Hi,
We run a SQL2000 Standard ed server with SP3. Every evening, I see the
following error in the event log:
App: E 'Thu Oct 11 00:25:43 2007': SQLSERVERAGENT - " Microsoft SQL Server
Replication : The C:_PROGRA~1_MICROS~4_80_COM_replmerg.exe
executable is terminating abnormally because i...more >>
SQL 2005 Transactional Latency Alert Posted by DTully at 10/10/2007 4:36:01 PM I'm setting up the transactional latency notification in SQL 2005 Perfomance
Monitor. What I am seeing is if I lower the theshold so Perfoamnce is marked
"Critical" for the subscriber, the alert is not firing and always shows 0 for
number of occurences.
I've followed the instructions at
h...more >>
Replication advice sought - 1.4Million new records Posted by Jim at 10/10/2007 12:00:00 AM We have a site consisting of a publisher and three subscribers. At one of
the subscribers I've disabled the replacation for the table in question,
then loaded in roughly 1.4 million new recoerds.
In order to get it to replicate well back to the pubilsher (and then the two
other subscribers) I ...more >>
replicating schema changes Posted by imarchenko at 10/9/2007 2:36:46 PM Hello!
I have setup testing transactional replication environment on my local
computer running SQL Server 2000. I was trying to test replication of schema
changes done to one of the tables participating in publication using command
similar to:
sp_repladdcolumn @source_object='Authors...more >>
Replication left the database in a weird state Posted by InvestorTrade at 10/9/2007 2:11:57 PM On my main DB Server (Running MSSQL Server 2000 latest SP) I'm
publishing the database, mybigdb (540Gb data file - my drive is
560Gb), using transactional and merging replication. Everything was
great until this morning, when I ran out of HDD space - so in order to
clear up some drive space I ...more >>
Synchronisation failing on SQL CE Database Posted by Sinead at 10/9/2007 8:49:03 AM Hi All,
I am having a problem setting up merge replication between SQL 2005 and SQL
Compact Edition. I've set this up before several times with no problems
however I had to delete the publication to create a new one with extra tables
and since then I am having problems during initial synchr...more >>
SQLServer 2005 - Trans. replication - Unable to create subscriptio Posted by CITS_DBA at 10/8/2007 9:08:01 PM Hi Folks,
Both servers are running SQLServer2005
I have created a publication and now wish to create a push subscription,
however using the wizard and executing the script that the wizard creates,
results in the following:
Via the wizard:
TITLE: New Subscription Wizard
-----------------...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Deteted Subscription : Distribution Agent still there Posted by Sandeep Shankar at 10/8/2007 12:00:56 PM SQL Server 2000 : Publisher and Subscriber
Our subscriber server crashed. It had 2 transactional subscription
I am rebuilding the subscription.I created these 2 subscriptions using no
sync.
My problem was, When I started distribution agent, I got following error.
"The subscription(s) ha...more >>
Unable to Restore Database... need some help Posted by Noncentz303 at 10/8/2007 10:51:01 AM My initial message was this:
System.Data.SqlClient.sqlError: REStORE cannot process database because it
is in use by this session. Use master
I checked and nobody is logged into the database. I removed the session from
the DB by choosing to run in master but to no avail.. (same error messa...more >>
reinitialization a subscription problem PLEASE HELP Posted by Majali at 10/8/2007 6:48:13 AM hi all
I have a problem in my subscriptions,any one can help?
I'm using Merge replication with filters and partitions.
some filters is a date based filters
When I reinitialize a subscription some of the old data -that not
satisfy the filter criteria- is still exist and not removed
So,what is t...more >>
The replication agent had encountered a file compression (cabinet) library error while calling 'FCIDestroy()'. Posted by Manish at 10/8/2007 6:17:50 AM when i run SnapshotGenerationAgent.GenerateSnapshot(), it fails.
the log file generated is as follows
.............................
.............................
Flushing cabinet folder
The replication agent had encountered an exception.
Source: Replication
Exception Type: Micro...more >>
MSrepl_commands clean up Posted by HS at 10/8/2007 12:00:00 AM Hi
I got Peer-to-Peer Replication configured and running on SQL Server 2005 EE
+ SP2 on Windows 2003 R2 + SP1 platform.
Total number of DB servers replicated 4.
My question is how to I shrink the distribution DB once it starts to grow
about 3GB per day? (Current distribution DB size is ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |