Changed the password of distributor_admin account manually and …
Jul 29, 2013 · Do not change the password for the distributor_admin manually. Always use the sp_changedistributor_password stored procedure, or the Distributor Properties or Update …
how to turn the sync with backup option on distribution database ...
Nov 26, 2012 · I have the transactional replication enabled for the reporting purpose.I need to plan for the disaster recovery also.I came across the strategy for backing up the distribution …
Replicating Views In Transactional Replication
Jul 23, 2010 · 2.When replicating Views, is there a way to have them replicated to the views sub folder under the database ( to have all the articles placed in their own respective sub-folders …
Sql server 2008 r2 replication -Overwrite a publisher/subscriber …
Jan 3, 2017 · I need migrate a sql 2008 r2 databases to sql 2012 . I have done it using scripts . Can you help me with query. If we overwrite a database (publisher/subscriber) with latest …
A failure was detected for a previous installation, patch, or repair ...
Mar 4, 2013 · Sql Server 2005 NSWORKS MSSQL.1 SQL Server Replication 1033 Enterprise Edition (64-bit) 9.4.5057 No
What is the difference between distributed and replicated database?
Aug 5, 2011 · A replicated database is a destination database which a source database copies all or part of its objects and data to. This can be a one time copy, or a continuous copy, and in …
How do you calculate the space required for snapshot
Sep 6, 2016 · There is no way your snapshot should be this large. For snapshots this large you should be using the initialize from backup option.
An invalid datetime value was encountered. Value exceeds the …
Feb 7, 2017 · An invalid datetime value was encountered. Value exceeds the year 9999 Archived Forums 381-400 > SQL Server Replication
can we setup transnational replication for servers in two different ...
May 22, 2019 · Can we setup transaction replication for servers in two different time zone. We recently had an issue with replication and was able to find that the primary and the replication …
Snapshot availability and subscription options. Please enlighten!
May 25, 2009 · Determines whether snapshot files are created every time the Snapshot Agent runs (requires Independent Distribution Agent). This option is read-only; it is set to True if you …