No announcements
Found 2536895 threads
-
0 Votes
transaction log backups
btw with mirrored or replicated dbs, since there is an active standby present, is it necessary to backup log files or backup with truncate_only is the ...Answered | 11 Replies | 1255 Views | Created by vtpcnk - Thursday, October 9, 2014 1:26 AM | Last reply by Shanky_621 - Friday, October 10, 2014 8:41 AM -
2 Votes
Difference between Transactional Replication and AlwaysOn Replication
Replication is a distinct technology that includes transaction, merge and snapshot models.Answered | 2 Replies | 11796 Views | Created by ITBobbyP - Thursday, September 1, 2016 7:15 PM | Last reply by Martin.Cairney - Thursday, September 1, 2016 11:32 PM -
2 Votes
Peer-to-peer publications only support a '@sync_type' parameter value of 'replication support only', 'initialize with backup' or 'initialize from lsn'.
I have a similar problem with my replication.Answered | 8 Replies | 14058 Views | Created by Crakdkorn - Tuesday, December 21, 2010 1:22 PM | Last reply by kindnesshelps - Friday, January 3, 2014 7:14 PM -
0 Votes
Transactional replication
Can we able to setup transactional replication for the tables without a primary key?Answered | 1 Replies | 746 Views | Created by vinodh k - Wednesday, November 28, 2018 1:34 PM | Last reply by Shanky_621 - Wednesday, November 28, 2018 2:22 PM -
0 Votes
Transactional Replication - Not replicating
Thank you very much Ashwin, I regenerated the snapshot and it's now replicating.Answered | 6 Replies | 1339 Views | Created by Mohan Chhapadia - Wednesday, August 20, 2014 10:28 AM | Last reply by Mohan Chhapadia - Wednesday, August 20, 2014 1:50 PM -
0 Votes
SQL 2005 Transactional Replication
When you initially create the publication, you can specify this through GUI or through TSQL.Answered | 5 Replies | 6992 Views | Created by Matt Beach - Monday, July 26, 2010 10:00 PM | Last reply by Wissam Kosseifi - Wednesday, July 28, 2010 6:49 PM -
5 Votes
Can replication cause transaction log to grow unchecked?
Internally what happens log reader agent marks what are the transactions are not replicated from publisher to subscriber.Answered | 14 Replies | 22292 Views | Created by JM6 - Thursday, April 14, 2011 1:23 AM | Last reply by JM6 - Tuesday, May 10, 2011 8:47 PM -
2 Votes
Peer to Peer transactional replication
Hi, The way to initialize the new peer databases is to restore the backups (making sure they are not changed before setting up peer-to-peer ...Answered | 3 Replies | 8444 Views | Created by Dhanalakshmi Periasamy - Tuesday, July 26, 2011 9:52 AM | Last reply by Mr. Wharty - Tuesday, August 9, 2011 10:53 PM -
0 Votes
Transactional Replication - SQL Server 2012
You need to determine why it is taking so long to replicate.Answered | 5 Replies | 2025 Views | Created by vensyd - Thursday, February 27, 2014 2:40 AM | Last reply by Hilary Cotter - Thursday, February 27, 2014 2:37 PM -
0 Votes
Transactional Replication-Publisher offline
Besides, SQL Server replication supports the automatic failover of the publisher, the automatic failover of transactional subscribers, and the ...Answered | 4 Replies | 1305 Views | Created by juniorkiran - Friday, December 25, 2015 5:55 PM | Last reply by Ice Fan - Tuesday, January 12, 2016 8:09 AM -
0 Votes
Shutdown Time-Out Interval for Transactional Replication
If you need to reinit your subscription, you only have 2 choices, snapshot or restore from backup.Answered | 6 Replies | 1057 Views | Created by BogdanU - Thursday, October 10, 2019 1:04 PM | Last reply by BogdanU - Tuesday, October 15, 2019 1:20 PM -
0 Votes
Transactional Replication Question
As mentioned in the two previous posts there is no concern buy your policy raises a question; If you already do take log backups then why not take them every 5 or 10 minutes?Answered | 3 Replies | 6096 Views | Created by LOSTCAUSE - Monday, May 2, 2011 5:46 PM | Last reply by Yaniv Etrogi - Tuesday, May 3, 2011 8:20 AM -
0 Votes
Remove article from transactional replication
However, please note that once you remove the articles from publication, replication will stop replicating the changes in schema/data ...Answered | 2 Replies | 5851 Views | Created by Zeal DBA - Thursday, May 21, 2015 5:43 AM | Last reply by Lydia Zhang - Friday, May 22, 2015 2:27 AM -
0 Votes
transaction log restore with external replication
We then stand up server from the 01:30 replication recovery point.Answered | 2 Replies | 6895 Views | Created by td3201 - Friday, May 6, 2011 7:41 PM | Last reply by Ashwin Menon - Wednesday, May 11, 2011 2:59 AM -
0 Votes
Is it possible to converting Snapshot replication to Transactional replication
No, there is no way to convert Snapshot Replication to Transactional Replication on the fly.Answered | 5 Replies | 2453 Views | Created by Ali_Hum - Friday, February 7, 2014 9:09 PM | Last reply by Ali_Hum - Monday, February 10, 2014 3:11 PM -
0 Votes
Replicating Views In Transactional Replication
It would be preferable, just from the perspective of having the different articles such as tables, views, etc in their own respective sub folders on the subscriber.Answered | 3 Replies | 7297 Views | Created by Roger9955 - Friday, July 23, 2010 3:04 PM | Last reply by sap99 - Saturday, July 24, 2010 10:19 PM -
0 Votes
transactional replication question
Why does the backup file need to be left on disk after the DB has been restored and replication has started?Answered | 3 Replies | 6537 Views | Created by Suri6012 - Thursday, May 5, 2011 9:27 AM | Last reply by kashif412 - Sunday, May 8, 2011 4:19 PM -
0 Votes
Transactional Replication Not replicating non-clustered Indexes
But the problem is solved.I had to wait until the Initialize process get completed.Answered | 4 Replies | 2357 Views | Created by ArashMasroor - Sunday, April 5, 2015 8:05 PM | Last reply by Lydia Zhang - Wednesday, April 8, 2015 3:33 AM -
0 Votes
Transactional Replication
More information can be found in Making Schema Changes on Publication Databases and How to: Replicate Schema Changes (Replication ...Answered | 2 Replies | 3901 Views | Created by Shree.Khanal - Sunday, September 18, 2011 10:55 PM | Last reply by Brandon Williams - Sunday, September 18, 2011 11:27 PM -
0 Votes
Transactional replication - log reader is down
Yes transactions in your publisher log file cannot be marked as sent through replication if the log reader is down.Answered | 2 Replies | 3723 Views | Created by Asi Pesa - Wednesday, April 25, 2012 8:05 AM | Last reply by Chad Churchwell - Thursday, April 26, 2012 2:10 AM
No announcements