No announcements
Found 123161 threads
-
0 VotesTransactional replication from backup
No, if you restore the backup into a publication database from a previous version of that publication database and use the keep replication switch, the log reader will fail.Answered | 2 Replies | 6488 Views | Created by Ilik - Friday, July 23, 2010 9:48 AM | Last reply by Hilary Cotter - Friday, July 23, 2010 2:26 PM
-
0 Votes
Azure Backup Geo-replication
You can replicate Azure VMs between regions with Azure Site Recovery.Answered | 8 Replies | 1503 Views | Created by Akihiro Kaneko - Friday, July 28, 2017 10:33 AM | Last reply by vikranth s - Monday, July 31, 2017 3:35 PM -
2 Votes
Veeam Backup & Replication version 8
It looks like you need to be running the Enterprise version of Veeam Backup & Replication v8 in order to perform the snapshot using SQL Server ...Answered | 3 Replies | 1808 Views | Created by Tinker_B - Wednesday, October 14, 2015 4:36 PM | Last reply by Tinker_B - Friday, October 16, 2015 2:41 PM -
0 Votes
Peer-Peer replication - log backup ?
If you do not perform log backups, a backup should be performed whenever a setting relevant to replication is changed.Answered | 4 Replies | 918 Views | Created by Kalaikarthik - Wednesday, December 30, 2015 12:48 AM | Last reply by Ashwin Menon - Wednesday, December 30, 2015 3:29 PM -
0 Votes
replication 'Initialize with backup' option
Yes if you use the option then after the publication is created it will keep track of the changed transactions and you dont need a log back just a full backup/restore will ...Answered | 2 Replies | 2406 Views | Created by Ocean Deep - Friday, May 31, 2013 4:56 PM | Last reply by Adminanup - Tuesday, June 4, 2013 12:00 AM -
0 Votes
Azure Backup of ASR Replicated VM
Currently, backing up a replicated VM using Azure backup is not an option.Answered | 3 Replies | 2245 Views | Created by Mick_J - Friday, November 29, 2019 12:31 AM | Last reply by SadiqhAhmed-MSFT - Wednesday, December 4, 2019 10:48 AM -
0 Votes
Transactional Replication Initialized from Backup
Initializing from a backup definitely works.Answered | 6 Replies | 2506 Views | Created by nwharris74 - Friday, November 16, 2012 7:40 PM | Last reply by Hilary Cotter - Tuesday, November 20, 2012 11:46 PM -
0 Votes
Snapshot Replication versus backup and restore
Yes, Transactional Replication is typically used to off-load reporting to another server/instance.Answered | 2 Replies | 1406 Views | Created by Ray1127 - Thursday, October 24, 2013 3:28 PM | Last reply by Brandon Williams - Thursday, October 24, 2013 4:05 PM -
0 Votes
Mirrored backup files or using File Replication
When setting up backups on a SQL Server I have been told that I can either mirror the process to 2nd server (to store a copy of the backup file) or using a File ...Answered | 1 Replies | 1943 Views | Created by Mr Shaw - Wednesday, July 10, 2013 4:30 PM | Last reply by Shanky_621 - Wednesday, July 10, 2013 5:32 PM -
0 Votes
Transactional replication is not syncing during full backup
Could you explain in more details why the backup is impacting the replication?Answered | 4 Replies | 5819 Views | Created by Nik_DBA - Friday, March 12, 2010 10:39 AM | Last reply by Nik_DBA - Saturday, March 27, 2010 7:30 AM -
0 Votes
Backup Replication Scripts using SSIS
Hi Monkey14, According to your description, you want to generate the script of replication using SSIS running in SQL Server job.Answered | 2 Replies | 1041 Views | Created by Bob_010 - Friday, January 23, 2015 3:30 PM | Last reply by Michelle Li - Tuesday, January 27, 2015 8:20 AM -
0 Votes
Replication subscription with manual backup restore without snapshot
4) backup database from Y location prod server to Y location backup server 5) run below command for every article in ...Answered | 4 Replies | 1049 Views | Created by SQLServerDBA007 - Wednesday, August 31, 2016 10:19 PM | Last reply by chaitanya konduri - Thursday, September 8, 2016 12:27 AM -
0 Votes
Transactional Replication re-initialize from backup
Firstly, use T-SQL replication stored procedures to delete the subscription.Answered | 1 Replies | 881 Views | Created by archie_tech_ - Thursday, June 25, 2015 7:25 PM | Last reply by Lydia Zhang - Friday, June 26, 2015 7:08 AM -
0 Votes
Can I backup a Hyper-V-replicating VM in Azure?
A possible second option would be to right a function to copy the VHD that is replicated to the ASR storage account to another location.Answered | 2 Replies | 805 Views | Created by tFable - Sunday, October 21, 2018 4:18 AM | Last reply by tFable - Monday, October 22, 2018 10:24 PM -
0 Votes
Database backup without Replication objects (for schema comparison purpose)
A SQL Server backup backs up all tables in the database.Answered | 3 Replies | 2446 Views | Created by Hichem Chekebkeb - Wednesday, December 5, 2012 10:27 AM | Last reply by Tom Phillips - Wednesday, December 5, 2012 9:15 PM -
0 Votes
SQL Server 2008 R2: Backup and Restore Database Replication
For this situation, you must backup the whole database and restore it and reconfigure the replication once more.Answered | 4 Replies | 2296 Views | Created by khemarin Set - Wednesday, March 26, 2014 3:49 AM | Last reply by tracycai - Monday, March 31, 2014 3:22 AM -
1 Votes
Sql server 2012 to 2008 Replication with backup initialization is possible
Because, I was restoring same sqlserver 2005 backup on to my publisher & subscriber servers.Answered | 3 Replies | 1391 Views | Created by velraj - Thursday, January 30, 2014 2:56 AM | Last reply by velraj - Thursday, January 30, 2014 6:45 PM -
0 Votes
Do full backup affect log-shipping, replication or cdc
It should (does) not affect restore-ability of log backups.Answered | 3 Replies | 3248 Views | Created by Harvinder Singh - Friday, October 19, 2012 7:32 PM | Last reply by TiborK - Monday, October 22, 2012 11:53 AM -
0 Votes
Replication performance issue -Transactional replication
As Hilary suggested, you really must take log backups of your database so your log file doesn't grow as that would have a huge impact on performance.Answered | 8 Replies | 1375 Views | Created by SSQLL - Wednesday, June 4, 2014 10:50 AM | Last reply by SSQLL - Thursday, June 12, 2014 8:47 AM -
1 Votes
Replication with Allow Initialization From Backup Files option enable
, Even I had the same problem but I created a new simple replication for that particular article and generated a snapshot.Answered | 3 Replies | 1090 Views | Created by s331246 - Monday, July 28, 2014 12:05 AM | Last reply by Moug45 - Monday, August 18, 2014 3:37 AM - Items 1 to 20 of 123161 Next ›
No announcements
