Browse by Tags

Site sponsored by:

The gold standard of SQL Server performance monitoring & diagnostics

RSS Feeds

Replication (RSS)

Re: which is best replication or log shipping

[quote user="Mahmoud_H"] It is required that new three remote branch sites will connect to the SQL server and do update/insert/delete and reporting. [/quote] IMO Snapshot replication and logshipping both are ruled out as you would required your subscribers to update/insert/delete records. The...

Posted to SQL Server 2005 Performance Tuning for DBAs (Forum) by ghemant on 11-25-2008
which is best replication or log shipping

I have OLTP central database sql standard 2005 that is currently working within LAN. It is required that new three remote branch sites will connect to the SQL server and do update/insert/delete and reporting. The four sites are connected with frame relay WAN. The main site is 512 kbps and has the database...

Posted to SQL Server 2005 Performance Tuning for DBAs (Forum) by Mahmoud_H on 11-18-2008
Merge Replication Web Sync: A security error occurred

I am getting error message: A security error occurred Server, Publisher, Distributer same comp. Win 2003, IIS 6, SQL 2005 Standard. Dont have static IP yet, using no-ip service. Tried security certificate using selfSSL, got error, tried thwart trial certificate valid for 20 days, still gives warning...

Posted to SQL Server 2005 Replication (Forum) by aman77 on 10-19-2008
Replication Monitor enhancements in SQL Server 2008

Replication Monitor is an useful tool that gives information about publisher view of all replication activity including status information for publications and subscriptions. When you load the replication monitor by default it will display warnings only for uninitialized subscriptions, you need to enable...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 10-17-2008
Re: The initial snapshot for publication xxxxx is not yet available

see if the snapshot folder is their and by any chance not deleted by anybody and it has a proper NT permission for the SQLServer Agent account....also check the snapshot agent job history for the exact error message which will help u rectify this issue

Posted to Performance Tuning for SQL Server Replication (Forum) by ghemant on 08-27-2008
Steps to be followed when SQL server 2000 Cluster (Active-Passive) manual Fail over occurs in perspective of Transcational replication

Hi All, The other day we had a patch to be applied on a boxes holding cluster, we had a plan of first applying the patch on passive then on active by failovering the cluster manually. But i was confused about any special steps or anything which should be followed when a cluster is faild over Our cluster...

Posted to General DBA Questions (Forum) by shashank sharma on 08-25-2008
Re: Subscription not accessible

yes both the domains are trusted.

Posted to Performance Tuning for SQL Server Replication (Forum) by Punyabrata on 08-06-2008
Subscription not accessible

Scenario: Two domains : 1) Domain\SQL1 and DOMAIN\SQL2 I am in the \SQL2 users group. \SQL1 users group have created one PUSH subscription.But when I log-on to this server and check, I am not able to see that push subscription listed. (both the groups have sysadmin rights). addtion to that I have checked...

Posted to Performance Tuning for SQL Server Replication (Forum) by Punyabrata on 08-04-2008
Re: Replication Error

Add this to your agent job step and restart agent.

Posted to SQL Server 2005 General DBA Questions (Forum) by Anoop on 07-03-2008
Duplicate GUID on Different sites

I have setup a merge replication and many push subscriptions. The issue i am facing right now is the generation of same GUID on more than one sites when inserting a record. this thing causes conflicts at the time of synchronization and to resolve them record from one site is deleted. This thing is happening...

Posted to SQL Server 2005 Replication (Forum) by m_salman786 on 06-10-2008