|
|
|
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 Error executing a batch of commands - when building subscriber Posted by Damien at 9/14/2007 1:35:30 AM Hi All,
I'm trying to build a transactional replication environment, using SQL
Server 2000, SP4. I'm getting the error "Error executing a batch of
commands. Retrying individual commands". It's occurring right at the
end of the process (after all of the DRI scripts have been applied),
so I'm n...more >>
Snapshot "after" script Posted by José Araujo at 9/13/2007 6:15:25 PM Hi everyone,
I need to run a script in the publisher each time the snapshot is
*generated*.
Any ideas?
Thanks for the info... José Araujo.
...more >>
Distributor Last Action, Where Art Thou? Posted by Daniel Jameson at 9/13/2007 10:30:38 AM Hi,
In SQL 2000's Replication Monitor, I could watch the Distribution Agent
durring initial snapshot synchronization and watch the "Last Action" to see
what table was being currently pushed.
In the SQL 2005/2008 Replication Monitor, I've found the Subscription
window, and it tells me tha...more >>
Replication issues after a Database Restore - Unable to drop or create Transactional Replication Posted by Query Builder at 9/13/2007 10:01:29 AM Hi,
I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server
Because of an unfortunate scenario, I had to restore one of the
publication databases. I scripted the replication module and dropped
the publication first. Then did a full restore.
When...more >>
How to setup replication over dedicated network card? Posted by Zarko Jovanovic at 9/13/2007 8:21:34 AM hi all,
I have a need to set up transactional replication for reporting
purposes. Reporting server is on the same LAN but we will like to use
dedicated cross-over between servers for replication purposes only.
How can I pursue distribution agent to use that NIC only?
tia...more >>
Undistributed Command when using transactional replication Posted by Rob Cooper at 9/13/2007 1:42:02 AM Hi,
I have the following setup
1x SQL2005 server running in 80 compatibility mode which is the publisher
and distributor to 5x SQL2005 push subscription servers.
Originally the publisher was listening on port 1433 (std SQL port) the port
was changed to 4449 as another server DTSs data ...more >>
SQL 2000 SP4 replicating to SQL2005 Mirror servers Posted by Paul at 9/13/2007 12:00:00 AM Hi,
I fully expect the answer is no, but I'll ask anyway!
We have a publisher (also distributor) server using SQL2000 SP4, which
utilises Snapshot and Transactional replication to a SQL2000 box at our
hosting site.
The hosting site box will soon be replaced by two SQL2005 boxes which wil...more >>
distributor error Posted by jullie at 9/12/2007 9:24:01 PM hi all,
i got this error when trying to set up publisher and distributor.
`Because SQL server agent on 'SERVER1' uses the system account, SQL Server
replication between servers will fail. To use the replication between
servers, select another server to be the Distributor for 'SERVER1'.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
transactional rep agent thinks Snapshot wasn't run Posted by Jon at 9/12/2007 3:10:02 PM Hi,
I get this "Action Message" when I look at the "View Details" for a
transactional replication agent:
The concurrent snapshot for the publication '[publication name]' is not
available because it has not fully generated or the Log Reader Agent is not
running to activate it. If generat...more >>
Cannot alter column '__COLUMN__' because it is 'REPLICATED'. Posted by Jay at 9/12/2007 12:22:57 PM When I try to alter a table with:
DECLARE @Beg datetime
DECLARE @End datetime
SET @Beg = getdate()
ALTER TABLE __TABLE__
ALTER COLUMN _COLUMN_ VARCHAR(250)
SET @End = getdate()
PRINT DATEDIFF(second, @Beg, @End)
I get the message:
Warning: The table '__TABLE__' has been created bu...more >>
SnapShot Agent Account privileges Posted by Peter Hartlén at 9/12/2007 12:00:00 AM Hi!
I'm struggeling on getting an Windows Server 2003/SQL 2005 publication up
and running.
I have created a windows account on the server, and I am not sure what
privileges I should grant this account to make it start.
Using this guide:
http://technet.microsoft.com/en-us/library/ms1723...more >>
merge replication - subscriber losing all data on failed sync Posted by Dave Abraham at 9/11/2007 2:38:09 AM We have a server set up using merge replication with 20 client subscriptions.
The publication is filtered with a very simple hostname filter. We are
experiencing some reliability issues that I would appreciate some feedback on.
Occasionally when synchronising the clients appears to lose conne...more >>
Delete the snapshot folder Posted by Singh at 9/11/2007 2:26:42 AM Guys,
I just setup a new transactional replication between two of our sql
boxes. As the db is quite large (80GB). The snapshot folder is about
80GB as well with the DB 80 GB as well. so in total i am using 160 GB
of space.
The replication is working fine.But i was just wondering if i can
d...more >>
sql server registration Posted by jullie at 9/10/2007 6:46:04 PM I knew that sql server replication does not support (local) as a server name.
The solution is to delete the current registration and create the new one
with the actual server name. But, i wonder if I delete the current server
registration, will all the jobs, DTS etc. that have been set up dele...more >>
Shrinking "Distribution" db log file in TR Posted by Suchi at 9/10/2007 3:12:01 PM Hi All,
Environment:SQL server2000 on Windows2003
We have few TRs set up on this server.The log size of distribution database
is around 4.5 GB. Shall i shrink it? If yes, please let me know the
precautions to be taken before shrinking it.
The recover model of Distribution db Simple and full...more >>
Transactional Consistency Posted by dlander525 NO[at]SPAM yahoo.com at 9/10/2007 12:13:23 PM I am just getting into replication for SQL 2005 after not touching it
since SQL 6.5 so the depth of my knowledge in this area is pretty
shallow at the moment. However, I have been asked in there is
transactional consistency between the publisher and subscriber.
If I have a series of DML statem...more >>
Replication Problem Posted by Mark at 9/8/2007 10:29:50 AM We have multiple SQL 2005 databases that do merge replication. One database
has now started giving the following error:
· The schema script '5090Mark_2.sch' could not be propagated to the
subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |