|
|
|
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 unidirection replication Posted by Shawn Mason at 5/7/2007 10:46:23 PM I have a client requesting to one-way replication and they don't want to
start with the same data. They simply want to pick a day and start moving
all new entries from one to the other. Is there an easy way to do this?
the subscriber needs to be updated within minutes of the Publisher.
th...more >>
Attach And Detach Replication Posted by sam at 5/7/2007 8:59:01 PM I would like to attach and detach my database due to change the log file
since that logfile already contain too large data.
But the problem occur, It's said that must drop the replication before do
any attach on that data .But i can't drop the replication since i still need
replicate the data...more >>
Publisher fields vs. Subscriber fields Posted by Francisco Morais at 5/7/2007 3:53:28 PM Hi,
Is it possible to replicate a table and giving different names to the fields
in the publisher? (making the field names in the Publisher different from
the fields in the Subscriber.)
TIA
FM
...more >>
Monitoring agent status Posted by Big Ern at 5/7/2007 10:10:01 AM All -
I'm trying to setup a way to monitor the agent status for replication. I
tried using the built in "Alerts" and they are not working. I made sure that
they are enabled, but after enabling the Alerts, it does not show that the
event had ever happened when I check the history. I've made...more >>
Parameterized filters Posted by yaser at 5/6/2007 12:00:00 AM Hi all;
I know that Parameterized filters allow different partitions of data to be
sent to different Subscribers without requiring multiple publications to be
created (parameterized filters were referred to as dynamic filters in
previous versions of SQL Server). A partition is simply a subs...more >>
Total Newbie Question Posted by Chris at 5/5/2007 10:59:36 PM We want to have a three stage production environment:
1. Test Server
2. Preproduction - a server for show clients stuff before putting it live
3. Production
Ideally we would like the data on Preproduction and Test to be very close to
the live. Replication seems the right tool for this. How...more >>
some tables weren't replicated in replication Posted by Iter at 5/4/2007 9:23:01 PM Hi Guy,
Today, I found some tables weren't replicated, they were not synchronised,
and some other tables got replicated. The replication setup is correct. I
checked the replication from replication monitor, no error, very strange. We
use transaction replication. Can anybody guess the reason?...more >>
Replication Question Best Practices Posted by tommcf at 5/4/2007 1:41:01 PM Hi,
I have a requirement to replicate a database for reporting purposes. I
would like the publisher and subscriber to reside in the same instance of SQL
server. I would like to know if this is possible, and what would be the best
replication type if it is possible.
Configuration
8...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2000 SP4 Rollback Plan Posted by ACM at 5/4/2007 12:18:00 AM Hi Everyone,
A customer running merge replication would like to install SQL sp4 on the
server acting as both the Publisher and the distributer.
They have asked me to research and produce a document detailing a rollback
plan should they wish to rollback the SP4 installation to their current...more >>
Logreader failed to construct replicated command from LSN Posted by Chuck Lathrope at 5/3/2007 7:23:02 PM I have this error coming up 'The process could not execute 'sp_replcmds' on
'VDB1' which always seems to accompany 'Logreader failed to construct
replicated command from LSN {0008e253:00009ddb:0003}.'
I turned on verbose logging and it gave this:
2007-05-04 01:31:16.018 Publisher: {call sp_rep...more >>
Replication Screwup Posted by LPR-3rd at 5/3/2007 9:52:06 AM Running SQL 2005 on Win 2003.....
First, I cannot find sp_MSload_replication_status. When I run it, I
get the following error
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_MSload_replication_status'.
Is the SP not a part of 2005???
Second.... I attempted t...more >>
Replication newbie, help please... Posted by msnews.microsoft.com at 5/3/2007 12:00:00 AM Dear all,
I have a web application that uses sql2005 database. And a local windows
application that uses exactly same sql2005 database structure. I want to
synchronize databases. When new record added from web I want them into my
local db. When my local db changes I want them to go my server ...more >>
Partition table replication. Posted by Chen at 5/2/2007 8:51:01 AM Hi,
Our production database runs on SQL Server 2005 (SP1) and I want to
implement currently no-partition to partition table. Does anyone can tell,
once table partitioned, it still can replicate from primary to subscriber
site using transactional replication?
Regards,
Chen...more >>
SQL 2000 Transactional Replication Issue Posted by myrights99 NO[at]SPAM gmail.com at 5/2/2007 8:34:54 AM I am having issue where the data are not getting displayed on
subscriber but are on publisher. so if i run query in query analyzer
on publisher i see those records but same query run on Subscriber no
results. i see the different in database size of 300MB so if my
Publisher as 10500 then on subsc...more >>
Replication is failing due to use of FTS on my subscriber, what can I do? Posted by Daniel Crichton at 5/1/2007 4:16:58 PM I'm in the middle of setting up a non-updating transactional replication
from SQL Server 2000 SP3 (can't put SP4 on as the main application we use
hasn't been certified for SP4 yet) to SQL Server 2005 SP1 (I could put SP2
on if it will fix the issue, but it would mean taking our e-commerce sit...more >>
Snapshot Agent Updates statistics on all PK indexes even when there is NOTHING to do!! Posted by isyourfriend NO[at]SPAM gmail.com at 5/1/2007 9:29:50 AM On SQL Server 2005 SP2 we got this "new feature" which I am probaly
aware of why you do need the update statistics but what I can't tell
is WHY you run the update statistics if there is NOTHING to do? Thanks
M$.
Does any one knows how or if it is possible, to turn that "feature"
OFF?
-Noel...more >>
service pack4 Posted by pardhiveswar via SQLMonster.com at 5/1/2007 4:41:11 AM Hi
currently we are using server1 (publisher)
second server distributor and other 5 servers as subscribers with service
pack 3.we are planning to apply sp4 to all these servers .my question is
which one we have to apply first ,second,third..
In publisher we are using bridgeware applicatio...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |