Viewing 10 posts - 1 through 10 (of 10 total)
Does anyone know why the initial insert into TableC in Primary which gets replicated to Subscriber doesn't trigger the log reader agent on Subscriber to send the transaction back to...
January 17, 2020 at 1:59 pm
Thanks @jeff. I didn't receive a notification from your reply for some reason.
For clarification, at what point do i take the "DIF" or "FULL" backup, right...
November 8, 2018 at 10:06 pm
For the record, I ran in to a couple of issues executing the plan above:
- Backing up the (now) 300GB log file requires the same amount of space;...
November 1, 2018 at 11:43 pm
Cool, sounds like a plan.
Thank you!
October 31, 2018 at 8:26 am
Bart,
Right now, log_reuse_wait says "Nothing". I do recall after the first Backup Log, I was not able to shrink the log because of the error i posted earlier. ...
October 31, 2018 at 7:53 am
I did a dry run restoring a backup to another instance. Backup Logs went fine but DBCC Shrinkfile threw an error:
Cannot shrink log file 2 (xxxxxxx_log) because the...
October 30, 2018 at 12:45 pm
Great and thank you!
October 29, 2018 at 9:39 am
Bart,
Yes, I am running in full recovery model. I did create the new DB from scratch and then it became the subscriber of the old instance. After the cutover,...
October 29, 2018 at 8:55 am
Hi Bart,
The log_reuse_wait says "LOG BACKUP".
The log reader is running as I am seeing data replicated to the subscriber pretty much in real-time.
The recovery model is...
October 29, 2018 at 7:53 am
Viewing 10 posts - 1 through 10 (of 10 total)