SQL Server Replication | Forum profile

Allright!!! After carrying our SEVERAL test scenarios....i come to a conclusion that we CANNOT have ORACLE Publisher and Subscriber on the SAME SQL server. You could have a server configured either as an ORACLE Subscriber or an ORACLE Publisher....! Marked As Answer by RubSay 6 hours 52 minutes ago  

merge replication will prune its own metadata (the data in these tables). Under most circumstances you will not have to clean up these tables. If you are exceeding the size limit of sql server express you may need to reinitialize to get back to a smaller sized database.

Hello, You could find the MSLogreader_history for the last time the log reader agent run. Also, MSdistribution_history for the last time distribution agent run. distribution agent says the last run & how much data is copied in the last run. Its says like "1 transaction(s) with 1 command(s) were delivered"   or "No replicated transactions are available"  etc in its...

Hi Cotter, As per my knowledge, when we consolidate all the data into a single database then the database would become huge and then there would be some problems...... while taking backup of the database(Which takes huge time)  or re-indexing or even while restoring.. Please clarify me on this....Thanks in advance Cheers, Sridhar -------------- Please Mark it as Answer if it helps u so that it will be useful to other forum guys

Hi, As hilary suggested u can do the same , in SQL Server 2008 user will face little performance issues but will not result into downtime.SQL Server 2008 is really too fast in generating the snasphot. We have 800 GB of OLTP DB  and done the same as hilary has siggested we did not face any issues , except few tickets of application slowness.

Alex's query is good You can combine it with Sp_msforeachdb to run against all published databases in instance create table #re (db sysname ,pub varchar (50) , article varchar (50) , sub varchar (50) , dest_db varchar (50) ) insert into #re Exec sp_msforeachdb 'IF ' '?' ' IN (select name from master.sys.databases where is_published = 1) BEGIN use ? SELECT ' '?' ' [db], pub.name AS...

Hi Hilary , I agree about the ENT edition note but we don't know yet what he is using . It even looks like the thread owner may have abandoned it . Prdon me but this is not clear to me " With the initialize from backup option if I mess with the table on the subscriber before the snapshot is applied, the data in the backup does not get restored. " As far as I know , we restore the backup only once and then  we...

My Application are bild using Delphi, the insert command like INSERT INTO TABLE1 (COLUMN1, COLUMN 2) VALUES (123, 'TEST') The problem is intermittent, don't have a periodicity, that the main problem That data inserted are messages, to view if I have new messages I click on a button "refresh", this button reload all data. []s

Create audit triggers to capture insert , update and delete on the table. when the issue had occurred again, query the audit table to see what deleted the missing row.

Thanks, I already tested @@SERVERNAME is showing different name ,but the server is exist as replicate distributor when i used sp_helpserver stored procedure.