Viewing 15 posts - 1 through 15 (of 90 total)
Has anyone gone through this procedure or have any thoughts?
October 17, 2017 at 9:34 am
Updating stats using exec sp_updatestats on the subscriber seems to cause the issue, it doesn't happen when I run that command on the publisher.
February 29, 2016 at 9:35 am
When you guys mean data transfer, that's from the application end correct?
November 12, 2015 at 8:48 am
Yes it needs to be at a moment in time, hopefully copy-only backups.
October 15, 2015 at 8:12 am
Thanks Lowell, I'm looking for the actual script itself though.
To clarify: the procedure would only backup from production, thinking only would need db_backupoperator permissions for the databases, and restore in...
October 15, 2015 at 8:06 am
Jeff I don't like the idea because of security and other implications of permissions but am exploring all options.
October 14, 2015 at 3:49 pm
Could you please share the details of this stored proc?
October 14, 2015 at 2:51 pm
The backup preference is set to primary, so whatever node is primary will run the jobs. This is also so that true full backups can be taken, can only...
September 25, 2015 at 8:17 am
@Jackin, how do you force a checkpoint?
@perry, 4 databases, one large one is causing the errors.
Full and log backups are set to primary, nightly fulls, 30 min tran...
September 24, 2015 at 11:46 am
Bumping this. I am still receiving the 'availability_replica' errors and backups do not resolve this, I need to remove the database from the availability group first and re-add it...
September 23, 2015 at 8:41 am
Thanks, does the location of the mdf file need to be the same as the original or can it also be moved?
September 15, 2015 at 12:48 pm
SERVER-ADBAVAILABILITY_REPLICANULLNULL
SERVER-BDBAVAILABILITY_REPLICA00
August 24, 2015 at 12:23 pm
The database on both servers for 'log_reuse_wait_desc' is showing 'AVAILABILITY_REPLICA'. I have already tried removing the database from the Availablity Group, readding it but then it goes back to...
August 24, 2015 at 12:14 pm
Viewing 15 posts - 1 through 15 (of 90 total)