|
|
|
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 Transaction Log shrink Posted by John at 12/31/2003 12:21:13 PM Hi,
I have Database which is configured for Transaction Replication. My Database options are "AutoShrink". I have scheduled TransactionLog Backup Job Every Hour.
I am unable to see the log is shrinking, it's growing alomost from day one.
Ours is SP3A, and Clustered.
Please advice me, fo...more >>
Attaching a subscription database Posted by Daniel Inman at 12/31/2003 11:55:31 AM According to books online for SQL 2000, it is possible to
use an attachable subscription database to create a new
pull subscription. However, when I go into the property
sheet for the publication (newly created, prior to any
subscriptions) , there is no option to allow copying.
The docum...more >>
HELP!!! Error when reinitializing publication subscription Posted by Greg Simpson at 12/31/2003 10:24:28 AM HELP!
I have just taken over mgmt of a SQL Server warehouse
architecture that uses replication to propogate changes
from a staging server to a production server. The
replication has been broken since 04 Dec. When attempting
to reinitialize the subscription, SQL tells me that I must
drop...more >>
sql 6.5 database export Posted by Mike at 12/31/2003 9:48:16 AM Hello All,
Here's my question: how do I transfer ms sql 6.5 database
from one server to another, same version of the sql? I
have to replace a server, I've configured the new one
pretty much the same way as the old one.
Thanks...more >>
The Publisher has been restored from a backup whose schema change version is different from the Subscriber. Rerun the Snapshot Agent and reinitialize Posted by Paul Kleynhans at 12/31/2003 9:01:51 AM Hi
I have been running Merge Replication with SQL200 Sp3a successfully for over
6 months now. We currently have 15 sites replicating to a central server
with an average of 5000 transactions per site per day.
Everything was going fine up until 3 days ago, when I got the following
error on some...more >>
restore published database after master db restore Posted by docware NO[at]SPAM hotmail.com at 12/31/2003 4:40:02 AM Hi,
We run a merge replication using SQL Server 2000.
In order to be prepared for crash situations, I am in the middle of
testing several rescue scenarios.
Presently I simulate a corrupted master database on the publisher. Due
to the corrupted master db SQL Server is unable to start. I have...more >>
Merge Replication : Sql Server as Publisher and Oracle as Subscriber ? Posted by Luqman at 12/30/2003 3:37:23 PM Is it possible to make replication between sql server and oracle when sql
server is publisher and oracle is subscriber ? I tried but could not
succeed.
Best Regards,
Luqman
...more >>
Replication using a pier to pier network Posted by Richard at CMI at 12/30/2003 2:52:26 PM To learn and practice Replication, I am trying to create
a SQL Replication of two SQL databases accross a WAN
using two Laptop computers one is a Windows2000 Pro OS
and the other is an XP Pro OS.
Problem in authenticating between the two. Any pointers
would be appreciated.
Thanks...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Filtering working correctly with dynamic filters? Posted by R Spen at 12/30/2003 2:40:32 PM I have set up a dynamically filtered merge replication
with pull subscribers. There is a filtered table called
[station] that contains the name of the subscriber
workstation and the filter is 'WHERE description =
HOST_NAME()'. There is a [transaction] table that has a
foreign key relation ...more >>
Migrating a publisher database Posted by Josh at 12/30/2003 1:20:04 PM I have a database (DB1) that needs to be migrated to a new
server. DB1 is involved in both a transactional
replication scheme and a merge replication scheme (all
tables except for three are trans, the other three are
merged). There are currently 10 subscriber databases on
other servers.
...more >>
Replication Posted by anonymous NO[at]SPAM discussions.microsoft.com at 12/30/2003 10:30:03 AM I'm evaluating several replication possibilities, is
anyone aware if SQL Server replication identifies database
corruption before it goes and replicates it? For
instance, if the server I am replicating has a database
that is corrupted, I do not want that corrupted database
to be replicate...more >>
logreader agent fails Posted by Girish Golwala at 12/30/2003 9:28:22 AM Right after restoring
dist db, pub db and msdb,
logreader agent fails with message saying
step did not generate any output?
I tried sp_replrestart and stil l getting same error.
ANy clue? How to resolve this problem?...more >>
Help!!! Transactional replication Issues.. Posted by Narayan at 12/30/2003 7:36:21 AM Hi
We use sql server 2000 , and I have been using
transactional replication, One way with push subscription.
This problem happens occassionally.
When I try to add a colummn or add an article to a
existing publication , the database hangs completely and
totaly frezes up. No transaction...more >>
Missing Stored Procedures for Replication after SP3a applied Posted by Rob Gilchrist at 12/30/2003 4:01:05 AM Hi
We have recently applied SP3a to two of our SQL SERVER 2000 servers. Both machines are running on Win 2000 and neither had any previous Service Packs applied. Both machines are Publishers in merge replication.
Once SP3a was installed the replication failed with the error message
Could n...more >>
Snapshot agent error 2 Posted by Mirko Slavko at 12/29/2003 4:05:39 PM Hi all,
I have a problem with making snapshot of a publisher database. When I start
snapshot agent I get this error at the end: "The process could not bulk
copy out of table '[dbo].[syncobj_0x4644453330353035]'. Invalid time format
(Source: ODBC SQL Server Driver (ODBC); Error number: 0)
I ...more >>
dbcc opentran Posted by chris at 12/29/2003 11:05:43 AM sql2k sp3
Im trying to truncate a tlog on a replicated db. It wont
let me untill the results of dbcc opentran are empty. Im
the only one on this test box and can verify that all data
has made it to the subscriber. But still, even after 20
minutes of waiting, I run dbcc opentran and its n...more >>
Can not get rid of publisher because database was deleted Posted by Christine at 12/29/2003 9:45:39 AM Hello, I removed replication and then deleted a
database. Now in my replication however I still have the
snapshot and the merge but I can not delete the publisher
because the db is no longer in the list. I guess when I
thought I removed the replication I just disabled it.
Any suggestio...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |