|
|
|
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 Reporting DB Question Posted by Mark at 8/14/2006 9:01:03 AM Hello,
I have the need for a read-only copy of a database on a remote server which
needs to be updated several times throughout the day without interrupting
users which may be using the datbase at the time of updates. I believe my
only options are transactional replication or log shipping....more >>
Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver Posted by David Haas at 8/14/2006 8:12:02 AM I was going to use this resolver but it does not take each column update into
account even tho column tracking is enabled. For example if I change column
A on one server and column A and B on the seperate server, and the first
change was the later change. When the resolver runs it doesn't ke...more >>
Problem using the offload agent parameters Posted by GRP at 8/14/2006 7:07:01 AM We have a replication setup that has been working for a long time which
involves one server acting as the Publisher and Distributer. We have over 400
clients that replicate using 1 trans and 1 merge subscription each. We have a
windows account that we use to manage security on both sides by us...more >>
Changing and Deleting Tables once Replication has begun Posted by Bondwireless at 8/14/2006 5:02:02 AM Hi,
i have SQL 2005 SP1 on two Windows 2003 R2 Enterprise Servers. One is the
main DB and the other is just being replicated to.
I would like to make some changes to existing tables as well as add some
tables to a database which has been published and subscribed to by the second
server.
...more >>
Access to distribution job properties Posted by andsm at 8/13/2006 4:55:01 AM In SQL2k I was able to easy find and change, when necessary, distribution
job. I was able to do it from several places, include replication monitor.
In SQL2k5 I found how to easily find log reader and snapshot jobs for
publication - in replication monitor, but not found how to easy find
distr...more >>
snapshot could not be generated because the publisher is inactive Posted by JMorganSmith NO[at]SPAM gmail.com at 8/11/2006 2:52:30 PM Publisher:
SQL Server 2000 (32-bit) SP4 (service using Windows account in Domain1)
Windows 2003 SP1
Distributor:
SQL Server 2005 (64-bit) SP1 (service using Windows account in Domain2)
Windows 2003 SP1
Connectivity fine between boxes/domains
REPL-LogReader job - no errors
REPL-Distribu...more >>
Problem with merge replication Posted by Roman at 8/11/2006 8:39:07 AM Hi all,
I use merge replication with windows CE clients and SQL Server 2005.
I have an issue which I didn't get solved yet:
1. If someone collects data in an existing table on the client
(subscription exists) and the publication on the server is changed in
the meantime. After replication ...more >>
Tran-Repl error Posted by sqldba at 8/10/2006 11:29:18 PM I am getting folowing error from 2-3 different server for which i am doing
Transactional Replication. I checked my network, hardware & every thing is
fine. Windows Server 2000 & SQL 2000 are on latest SP. couple of times when
ever i get this error message, i stopped & started Distributor & Log...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How do you replicate one server ot another to be a backup?? Posted by BJ at 8/10/2006 10:06:02 PM WE have two SQL 2000 servers running on Windows Server 2003. One server is
setup and works fine. What we wanted to do (without going outside of
Microsoft software) was to replicate one server to the other either nightly
or on the fly. Reason is, if we lost the first server we need to be able...more >>
tranactional replication after re-indexing Posted by Methodology at 8/10/2006 6:01:02 AM Hi
I need to setup replication from one DB to another. Primary DB is 150GB.
Every Saturday a full re-index is done on the DB which is obviously going to
create a HUGE transaction. As my replica server is geographically remote - ie
contactable over a WAN im thinking that there arent going to...more >>
RMO executing Synchronize() method failure Posted by Tomasz Krupa at 8/10/2006 2:08:01 AM Hello,
While executing Synchronize() method I've got a error:
"The subscription to publication 'XYZPublication' could not be verified.
Ensure that all Merge Agent command line parameters are specified correctly
and that the subscription is correctly configured. If the Publisher no longer
h...more >>
changing merge agent profile for HTTPS - mergeSubscriberType = anonymous Posted by Bruce Baker at 8/10/2006 12:00:00 AM Hi
We are using HTTPS merge replication - subscriber is nosync
Our setup is as follows:
subscription.CreateSyncAgentByDefault = False -- I wrote a windows service
to synchronise
subscription.UseWebSynchronization = True
subscription.InternetSecurityMode = AuthenticationMethod.BasicAu...more >>
Replicate with SQL Server CE Posted by Samuel Shulman at 8/9/2006 4:20:38 PM I am looking for a link to what is necessary to replicate between SQL Server
(2000 or 2005) and SQL Server CE as well as what version of SQL Server
(MSDE, SQL Server Express) can replicate with the CE version
Thank you,
Samuel Shulma
...more >>
Temporary Offsite Database Posted by cmay at 8/9/2006 3:54:04 PM A database we have running SQL Server 2003 will need to be copied and
taken offsite on a laptop for about a week. While the laptop is out of
town, both SQL Servers, the one in the office and the one in the field,
will both continue to operate.
They will both get new Customers, WorkOrders and ...more >>
Mirroring with Witness Posted by M.McDanold at 8/9/2006 2:52:45 PM I am having trouble setting up database mirroring with a witness. Setting up
mirroring without a witness is working fine. But when I try to set up a
witness, using either the Wizard or direct T-SQL, error 1456 appears, “The
alter database command could not be sent to remote server
TCP://...more >>
Indices and Schema applied during snapshot when drop table not che Posted by Larry Herbinaux at 8/9/2006 1:54:51 PM During the create publication process, I selected the "Delete all data in the
existing table" option in the Name conflicts section. I do not want the
existing table dropped and re-created.
I would expect only bulk copy statements in the agent log, but I also see
that it applied indices and...more >>
possible to re-add replication after manually removing it? Posted by Rich at 8/8/2006 11:00:02 PM Hello,
This article
http://support.microsoft.com/default.aspx?scid=kb;en-us;324401
shows how to manually remove replication from a database.
sp_removedbreplication '<Database name>'
After running this SP on my test system, I observed in Replication monitor
that my publication appear...more >>
Cannot modify horizontal filter Posted by Larry Herbinaux at 8/8/2006 3:30:01 PM It appears that the only thing I can do is modify the where clause. In
Hilary's book, he shows examples where you can perform joins on other tables
which is what I need to do. After further research, I have found that Join
filters are only allowed for Merge replication. I tried to setup Mer...more >>
replication and triggers Posted by Mike Read at 8/8/2006 9:40:23 AM In my database I have 2 copies of every table. One is the main data table
and the other is a history table. The history table has the same columns
and column order as the main data table with a historydate and history user
columns added. I have triggers on all my data tables to move a copy...more >>
Snapshot keeps applying over and over again Posted by john.gagnon NO[at]SPAM gmail.com at 8/8/2006 9:01:33 AM We are running SQL 2000 publisher, SQL 2000 subscriber, and we are
trying to use SQL 2005 as the distributor - we have set this up a
number of times before so we know it works.
When we try to do a replication test against our production machine (as
the subscriber running SQL 2000) the create s...more >>
New Subscription - how to specify subscriber table? Posted by Rich at 8/8/2006 8:36:03 AM Hello,
I started replication on a test DB on my dev server. I used the wizards.
This went fine. I started a new transactional replication job on a table on
my testDB and picked out an article - my test table, then I created a push
subscription to the remote server and specified the testD...more >>
Snapshot Replication - Rollback Posted by Vikas at 8/8/2006 7:28:02 AM Hi all
I have a snapshop replication on my machine with "TestCentre" as Publisher
and "TestStore" as subscriber on the same machine. Replication is working
fine. I just wanted to delete 2 databases. I tried to delete them, but came
out with error. as they are dependencies. So, I deleted P...more >>
Replication History Posted by Joy at 8/8/2006 5:22:52 AM Hi,
I am new to replication. Can someone tell me how do i get to know when did
the last replication take place, meaning i would like to know the date time
stamp of it.
regards,
Joy...more >>
SQL2005 - What am I doing wrong? Posted by James Vickers at 8/8/2006 2:17:28 AM Hi all,
TIA for any help anyone can give me.
I have been working with SQL2000 for a month, testing out whether
transactional replication will solve our business needs with our 3 sites
located in US, UK and Germany. We have trialled it over 3 Broadband lines,
and all is good.
We have n...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |