|
Replication Issue on SQL 2005 sp3 64bit win2k r2 sp2 I'd check a couple of things: 1) Does the stored procedure exist at the publisher? If not, something turned replication off in that database. 2) Does whatever account you're using for the logreader to connect to the publisher have db_owner at the publisher database? According to BOL, that's what it needs (sad,... 13 Aug 2010 17:58
Subscription marked inactive in SQL 2008 We are using SQL 2008 std with push transactional publishation to a SQL 2005 subscriber. The publisher and distributor are on the same server. Out of nowhere, I received the following message. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped ... 12 Aug 2010 23:32
Replication Issue on SQL 2005 sp3 64bit win2k r2 sp2 Looking at the log below, why would I get this error? I found that bunch of stored procedures were invalidated at around the same time. Could this have something to do with it? Thanks in advance 2010-08-12 00:00:35.78 spid17s This instance of SQL Server has been using a process ID of 1592 since 8/1... 12 Aug 2010 16:59
MSSQL log shrink I don't have much experience with replicated databases, but I wrote this script that I run on test databases to shrink the logs. Hope it helps. (I use the variables so I don't have to modified it, just change the database which the query is running against) DECLARE @logname NVARCHAR(50) DECLARE @name NVARCHAR(50)... 11 Aug 2010 12:33
Large Log File Hello, i have a merge replicated database (3 GB) with a log file that grown to 38 GB. The recovery Model is simple. DBCC Shrinkfile doesnt works. DBCC OPENTRAN say: Replizierte Transaktionsinformationen: Oldest distributed : (0:0:0) Oldest non-distributed LSN : (297400:25:1) What can... 11 Aug 2010 08:11
MBT shoes – excellent barefoot healthy shoes MBT shoes are a kind of excellent barefoot healthy shoes. Due to MBT shoes are slightly weighted and spread weight evenly across the entire foot and as your body reacts to the weight and instability of the MBT shoes sole, muscles, often the neglected muscles, are forced to work to put right this instability. M... 9 Aug 2010 02:31
is a subscriber We have customers that don't use replication, and some that use merge replication. I need a command able to be executed in a stored procedure that will tell me is this SQL Server is a subscriber in a replication environment. that is all i need to know. Something like: if issubscriber(SQL_SERVER_NAME)=1 begin ... 8 Aug 2010 18:55
The Agent is Suspect. No Response within the last 10 Minutes Sri, That is great advice. Can you tell me how the same thing is accomplished in SQL 2005. I am having the same problem but am working with 2005 not 2000 and I can't find the inactivity threshold anywhere. Thanks in advance for your help. From http://www.developmentnow.com/g/114_2003_11_0_0_443381/The-Agent-is-Sus... 2 Aug 2010 20:15
replication databases and reporting - best practices? We're a small SQL Server 2005 shop. We don't use Reporting Services, and we do very little OLAP, and quite simple OLAP at that. Instead we've got a set of OLTP databases on our production server, and a distantly-located set of reporting databases, which include databases replicated from the OLTP databases. We c... 26 Jul 2010 20:29
jameelmossly@yahoo.com ���� ������ mahmdyosef35 Skype ����� ���� ������ ���� �� ���� ... 24 Jul 2010 13:24
Merge Replication: access right issue Hello all, We have merge replication up and running. But we have used admin rights at subscriber/publisher/distributer because we were testing. Publisher: SQL Server 2008 Subscriber: SQL Server Express Edition We use pull subscription and for running merge agent at subscriber, we run a batch file which do... 23 Jul 2010 09:11
Merge Replication: subscription problem Hello all, We have a merge replication set up and we are facing problem with a subscriber. Publisher: SQL SERVER 2008 Standard Edition. Instance Name: Lapi1/Comp Subscriber: SQL SERVER Express Edition. Instance Name: Pup/Num Note: Subscription is not on same server as publisher We have built a pull sub... 20 Jul 2010 10:15
Snapshot Agent not Starting Currently trying to replicate between two servers. The publication database on one server was recently restored from a copy of the database, but a copy in which the database wasn't set as a publication. well, I wanted to try starting from scratch so disabled the distributor and re-created everything (distribut... 16 Jul 2010 18:47
Replication between SQL Servers 2003 and 2008 I have a push merge replication running well on 2003 and we're trying to migrate to a 'cloud' server running 2008. Before we switch all sites to 2008, I need to replicate from 2003 to 2008 and I can't register the 2008 instance in SQL Enterprise Manager and can't seem to find any way of replicating to the new ... 16 Jul 2010 17:40
Transactional replication I have to create a replication between three SQL Server where each one is the main server of three different stores. Each store have its own number. This number is what identify data to each one inside the tables. Which type of Transactional replication best fit this project? Updatable Subscriber or peer-to-p... 16 Jul 2010 13:14
merge replication: suggestion on deploying my application Hello all, We have an aplication in .net which we are planning to deploy on our workers laptop so that they can work offline with their own copy of database. We planned to do merge replication and have database replicated across workers machine. We have tables, procedures and triggers to be replicated. Ta... 16 Jul 2010 09:54
Merge Replication: user trigger issuu Hello all, We have a trigger defined on table x which gets executed when an update is on a column. The trigger is executing properly on publisher side. But when we do update on subscriber side to that particular column, trigger doesnt execute. While publishing I had user defined triggers true for the table... 15 Jul 2010 15:25
Snapshot agent error the process is running and is waiting for a response from t I am using transactional replication on 2 test instances MS SQL 2005 9.0.4035 SP3 after starting snapshot agent it stops on 99% with message the process is running and is waiting for a response from the server . I Used sp_who2 and dbcc inputbuffer and tried to increase timeouts but it didn't help. the process ... 15 Jul 2010 07:41
Transaction replication with Updatable Subscription I have two servers that will replicate to eache other. I have to decide which type of replication I will use. The replication that best fits is the Transaction Replication with Updatable Subscriptions. I have read that Updatable Subscriptions for Transactional Replications will be removed from the future versi... 14 Jul 2010 13:12 |