|
|
|
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 SQL server replication from non-clustered database servers Posted by G.Fink.Nottle NO[at]SPAM gmail.com at 6/21/2006 7:32:04 PM Hello,
Being a bit of a SQL Server novice, need some advice with the following
situation.
Server A and Server B have SQLServer 2000 based databases. The vendor
of the application/system has implemented their own replication process
to ensure the 2 databases are in sync. However, there is no...more >>
Merge Replication Failures Posted by tony at 6/21/2006 12:37:11 PM I have replication setup between server A & B, both SQL 2005. Server A
is distributor/publisher & B is subscriber. I have has merge
replication working for 10 databases for awhile now. Each database has
only one merge publication and one subscription each.
Symptoms: Publications starting s...more >>
Merge Replication Provider (Agent); Error number: -2147201001 Posted by GC at 6/21/2006 12:37:03 PM Hi,
Why the replication could not create this new column.
The replication have 5 new column to create on the subcriber
He create the first 3 columns and at the fourth one I receive this message
The schema script 'exec sp_repladdcolumn '[dbo].[temps]','HeuresRNC',' float
NOT NULL DEFAU...more >>
Replication questions Posted by Lisa at 6/21/2006 9:56:02 AM Hi,
My SQL server is version 2000. I am trying to get email alert when any of my
distribution agents is down. I have set up Outlook XP and able to
send/receive email. I have set up SQL mail to use that profile. In
Replication alert, I enabled agent fail, but I still fail to receive alert
...more >>
Replication from SQL Server 2005 to SQL Express using RMO Posted by Aaron Peronto at 6/21/2006 5:39:02 AM I am having a problem with getting merge replication to work between a SQL
2005 Publication and a SQL Express subscriber using RMO in a C# windows app.
Everything I have read indicates that you can use a MergePullSubscription
object, set the values for DatabaseName, PublisherName, PublicationNa...more >>
How to Replicate an SQL Server 2000 Database Posted by Bondwireless at 6/21/2006 5:12:01 AM Hi, i am new to this so really need some helpfull and easy to follow
information so that i can successfully replicate my SQL Server Database.
Here is my dilema. I have a working SQL Server 2000 Database which has an IP
address and alias so can be connected to by the outside world. However on ...more >>
Snapshot Agent stalls while setting up new Publication Posted by Spike at 6/21/2006 3:05:02 AM I'm trying to set up a new publication for a database. However, everytime I
try it the snapshot agent hangs while trying to bulkcopy the contents of a
particular table.
I've tried running dbcc checkdb, and dbcc checktable but everything seems to
be okay. Can anyone point me in the right d...more >>
MSmerge_conflict_publication_article table Posted by Doug at 6/20/2006 12:36:02 PM In SQL 2005, how do you look at, and ultimately update, system tables such as
a MSmerge_conflict_publication_article table? I can't find an
INFORMATION_SCHEMA view that allows this. Currently in SQL 2000, I will
periodically purge the conflicts that have been recorded in these type of
t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Distributed transactions, replication, views Posted by deja NO[at]SPAM 2bytes.co.uk at 6/20/2006 6:21:08 AM hi,
I have been tasked with restructuring a database. The database is
currently recreated for different periods so for 2005/2006 we have one
database and for 2006/2007 we have another. But clearly some tables do
not change much and so they want these tables hived off to a separately
maintaina...more >>
Distributer and Subscriber together Posted by laststubborn at 6/20/2006 1:02:20 AM Hi all,
Is it possible to hold distirbuter and subscriber at the same machine
in transactional replication?
If you help me promtly I really appreciate it.
Thanks
...more >>
Trans Replication from 2 disjoint domains Posted by Hassan at 6/19/2006 11:49:05 PM I have a ServerA in one domain and ServerB in another domain.
The only way I can get to them is thru an IP address.
So ServerA which is the publisher can ping ServerB which is a subscriber and
not vice versa.
Is that all I need in addition to opening up the default port of 1433 of
Serve...more >>
Central subscriber question Posted by Kevin3NF at 6/19/2006 9:59:15 PM This could be for 2000 or 2005...all my experience is with 2000...
Transactional replication.
I need to set up a Central Subscriber to be a reporting server, subscribing
to 80 different database that are identical in schema (each db is a
different facility). I cannot alter the schema of t...more >>
snapshot agent won't restart Posted by danieltsai via SQLMonster.com at 6/19/2006 2:50:23 PM Hi,
I set up schedule of snapshot agent running once every day and a
subscriber agent after it. It was doing well. However, when I restart SQL
server using service manager every time, all schedules never run after the
restart. Is there any setting I can change to let agents start automatical...more >>
Log Shipping target, transactional replication source Posted by Kapal Mo at 6/19/2006 2:09:15 PM Can the target of a log shipping database, be used as a source for
transactional replication?
...more >>
How to: Restart the Distribution Agent w/ Transaction Replication Posted by sdebriere NO[at]SPAM gmail.com at 6/19/2006 6:59:40 AM I apologize for the lame question. However, I'm unable to find where in
SQL Server 2005 you can restart the Distribution Agent.
Can someone help me out by giving some direction on how to restart the
disribution agent?
Thanks Seth
...more >>
Log shipping Failover. Posted by Miguel at 6/19/2006 12:00:00 AM Hello.
How must I configure SQL Server clients, when a failover occurs between a
primary server and secondary server using Log shipping?
I know that in a Mirroring environment I can configure the SQL provider with
2 server names. Can I do anything similiar in a Log shipping environment?
...more >>
Syntax error or access violation Posted by Roger Nygård at 6/19/2006 12:00:00 AM msSQL2000 sp4
Win2003 server
ERROR:
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
when I run this SP.
{CALL sp_tmp_rn_tp (260, 340, 1, 4, NULL, NULL,
{ts '2006-07-03 00:00:00.000'},
{ts '2006-08-13 00:00:00.000'},
{ts '2006-06-17 11:00:00.000'},
{ts '2006-06-17...more >>
Stored Procedure Execution Issue Posted by Paul Mu at 6/18/2006 9:40:02 PM I have a stored procedure to archive data from a large table. This SP is set
to be replicated using @type = N'proc exec'. The replication environement is
transactional, and servers are W2K, W3K and SQL2K with SP4.
However, when I execute the SP, it is executed on the publishing database
but...more >>
Query slow after replication Posted by WW at 6/18/2006 5:31:03 AM We are fairly new to replication and we have suddenly encountered a
problem with our databases after replication is configured. A standard
query we have always used normally takes 5 sec to run. Once
replication is configured this same query takes 15sec. I have ruled
out the server, the code...more >>
Multiple locations Posted by Mark Minnie at 6/17/2006 9:16:37 PM I copied the following text from a newsgroup posting from 2001:
I need to be able to replicate data from a point of sale application to
and
from the central office to all of the stores. The central office and
all of
the stores have to have the ability to update and change the data.
Multiple
...more >>
False Replication Error Posted by golfnut at 6/17/2006 1:26:02 PM I had to restore a replicated database and the publications did not delete
cleanly. I had to go into the tables and manually remove the publications for
this database. I have recreated the publications and they are successfully
running but I have a red x on all four of the publications. How do...more >>
SQL Server 7 to Mysql 5 Posted by Excequiel Aróstica at 6/16/2006 6:54:52 PM It is possible to Replicate data from SQL Server 7 to a data base in Mysql,
the subject is that I need to have updated in MySQL 5.
Thank.
...more >>
2 sources to 1 target replication Posted by dummy#1 at 6/16/2006 4:16:01 PM Can you replicate 2 tables from different servers and databases to 1 target
table on a server, database?
How do you set it up? What type of replication?
I am using SQL2K.
Thanks....more >>
Merge Replication generate empty Tables Posted by Bonato Pierantonio at 6/16/2006 12:00:00 AM Hi all,
I have a problem. I use a Merge replication between 2 SQL 2000. I schedule
this tasks:
at 6.00 import data from external source (AS400 in this situation) to
Publisher
at 6.45 generate the Snapshot
every hour merge replication
Every morning I find my table on Publisher perfectly f...more >>
schedule the re-initialization Posted by Bonato Pierantonio at 6/16/2006 12:00:00 AM Hi all,
it is possible to schedule the re-initialization of all Subscriptions?
Thanks
...more >>
replication script Posted by leffe at 6/16/2006 12:00:00 AM I'm trying to write a dynamic replication script, who recreate a publication
and so on, but have a problem to do same table selection as the wizard used
to create a publication, anyone who knows how the wizard do the selection.
...more >>
Synchronization Posted by kevin.loo NO[at]SPAM gmail.com at 6/15/2006 11:35:46 PM Hi,
I would like to synchronize(not sure the term using in sql server 2000)
a table, let say Table_A of Database_A to Table_B of Database_B, which
is in the same sql server, everytime when Table_A update, insert or
delete.
Let say I want to synchronize it automatically. What is the method I...more >>
Upgrading from SQL 2000 Standard to Enterprise Edition Posted by Micheal at 6/15/2006 6:56:02 PM Hi there
I have identified some issues with performance and believe increasing RAM on
my production server will resolve the issue. Problem being that I have 2000
Standard (limits me to 2gb of RAM, though server currently has 4gb installed)
and want to allocate more - meaning changing my edtio...more >>
Enabling a db for replication question Posted by pdx at 6/15/2006 11:45:02 AM I'm trying to enable a db for replication so that a dbo_owner of the db can
setup a publication.
According to a book I'm referencing as well as BOL the process is as follows:
1) Connect to the Publisher in Microsoft SQL Server Management Studio, and
then expand the server node.
2) Right...more >>
Auto retry synchronization/agent Posted by justin NO[at]SPAM compuag.com at 6/15/2006 11:39:37 AM Is there a way to automatically retry to synchronization after certain
errors? I'm new to replication and it seems like I always have to
restart synchronization after a few hours. All is well after a simple
restart, so it would make life a lot easier if it could do an auto
retry. I'm currentl...more >>
Need help w/ replication between secure networks Posted by dvdproactive at 6/15/2006 8:17:03 AM I need to set up SQL replication between 3 separate networks. I have 3
servers, ServerA, ServerB, and ServerC. ServerA and ServerB can communicate
with each other, ServerB and ServerC can communicate with each other, but
ServerA and ServerC cannot communicate with each other. ServerA will a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |