| Groups | Blog | Home |
|
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 URGENT - Restoring a Replicated database to an older full backup Posted by zashah NO[at]SPAM gmail.com at 10/6/2007 9:21:40 AM Hi
A release to a replicated database has to be rolled back, the database
in question has Transactional Replication (one subscribing database),
both machines are SQL2000 SP3a.
The replicated database was backed up prior to the changes (sprocs,
new columns inc. some to replicated tables, vie...more >>
Replication Latency Problem Posted by Jacx at 10/6/2007 5:56:07 AM Hi all,
I have two servers who are almost alike. They both Have databases on SAN.
These two servers are subscribers to transactional replication.
On one of the servers as soon as data starts replicating the latency
increases and that server never gets in SYNC.
Any solutions????
thanks in ...more >>
Total Newbie Question - Do I have stop Replication to change a field Posted by Joe at 10/5/2007 11:14:17 AM I need to add a field to a table that is being replicated. We are using
transactional replication on SQL Server 2005. I was told I needed to
completely break replication on *all* the database tables to do this.
Is this correct?
Thanks!
-Joe
...more >>
Replication Validation error Posted by hughtwg NO[at]SPAM yahoo.com at 10/5/2007 8:25:37 AM I've created a snapshot replication between two servers. When I try to
validate the subscription I get the following error:
Error 20523: Could not validate the article 'categories'. It is not
activated.
I have looked at the 'categories' table in both servers and it appears
that it is being up...more >>
Backup Question with Replication enabled Posted by Rich at 10/5/2007 6:34:01 AM I am new to SQL 2005 and I have a question on backup specifically restoring a
database.
The setup is a database that is a publisher is replicating its data to a
sunscriber via a pull method. (Sorry if I am not using all the correct
terms). We have SQL performing backups (Full and Differen...more >>
Basic replication question Posted by manu at 10/5/2007 4:02:03 AM Hi,
I just want to know whether MSDTC service is required to set up replication
in SQL Server 2000/2005.
If MSSDTC is not started then will I be able to configure replication or run
replication without problems?
Thanks
Manu Jaidka...more >>
Database replication in .net 2.0/3.5 Posted by Harald SMS at 10/5/2007 1:50:01 AM Can anyone give me some good advise on approaching data replication in sql
server 2005/2008, and programming libraries for this in .net framework? Maybe
some good articles or books are around?
--
Harald SMS...more >>
Copy SQL2000 DB from test server back to production... Posted by Kevin F (Michigan) at 10/4/2007 7:29:03 PM I detached a production db, copied to my test environment (desktop), modified
it, and now wish to copy it back to the production server WITHOUT overwriting
the exiting copy on the production server. Both dbs have the same name, and
I DO NOT want to overwrite the production db. I renamed the ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Mirroring question, Posted by Jay Bukstein at 10/4/2007 12:26:03 PM I've set up SQL Mirroring in 2K5 and it seems to running fine. My question
is this coming weekend the building that has the principal database server
the power is going off for 8 hours, Do I need to promote the mirror when
this happens or is it automatic even though I don't have a witness se...more >>
HELP - Error adding an article to a merge replication - Any ideas? Posted by Pete Ocasio at 10/4/2007 9:09:49 AM I have search high and low for an answer and still coming out empty... the
closest answer was to apply the latest udpdate but I am already at SP$ SQL
Server 2000.
What is the best way to add an article to a merge replication?
sp_addmergearticle 'PUB_1','test_tbl','test_tbl',
@force_inva...more >>
merge replication - rowguid column out of sync - for tough solvers - urgent Posted by Fotis Mylonas at 10/3/2007 6:27:38 PM Hallo dear all,
We have a merge replication topology with a central server at the role of
publisher and distributor and 8 subscribers around him. All machines have
windows server 2003, and sql 2005 entrprise edition.
the problem is this:
the replication was not initalized by the publisher, in...more >>
Replication maintenance jobs Posted by NC3 at 10/3/2007 12:59:55 PM We've just migrated to a new firm wide application that uses
transactional replication for reporting purposes. I've configured
replication 2 or 3 different times while in test/development without
many issues. On cutover Monday replication became a show stopper due
to configuration issues mainly ...more >>
Replication setup Posted by sharman at 10/3/2007 6:01:00 AM Hi,
I am a newbie to replication. I recently joined a company where I have a SQL
Server running 2000 SP3 and I see a distribution database and Replication
Monitor in the Enterprise Manager.
On going to Tools->Replication ->Configure Publishing, Subscribers and
Distribution a pop-up wind...more >>
How to backp up a SQL Server 2005 database to 2000 format Posted by Juan Manuel AlegrÃa B. at 10/2/2007 12:00:00 AM Hi, I have a problem, I´m working with SQL Server 2005 database but I need
that database in a SQL Server 2000 database format.
Thanks for your help.
...more >>
Merge Performance Posted by Jon at 10/1/2007 11:43:02 AM Scenario:
I work for a company that is implementing a large-scale disconnected PDA
application. We are using merge replication. We have 204 articles, about
100 of which are bidirectional. Of these 100, about 50 are filtered using
joins. Currently, partitioned snapshots take about 2 minute...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |