Viewing 15 posts - 1 through 15 (of 15 total)
Found it: Thanks for information
Primary Replica RCSI or SI Enabled, Secondary Replica Not Read Enabled
In this instance, SI and/or RCSI are enabled on the primary replica but the secondary replica...
November 14, 2014 at 9:27 am
Woah! That is worrying. Part of the over all solution is to off load your backups, DBCC work, and reporting. So if I am reading you correctly, what you are...
November 14, 2014 at 8:15 am
(log shipping ref:) sync set up, every replica needs to have access to a shared location to access the database backups created and used for synchronising the secondary databases. The...
November 14, 2014 at 7:49 am
That's an interesting read. Thanks for this.
November 14, 2014 at 7:43 am
Understood. I'm still finding my feet with this. I was referring to AlwaysOn using SQL Server’s existing mirroring technology, and therefor I need a location for the initial full syn...
November 14, 2014 at 6:41 am
HI Gianluca, This is what I was hoping to here. Thanks for your comment.
November 14, 2014 at 5:46 am
Your dead right about the licensing Andrew.
November 14, 2014 at 5:45 am
I agree with you regarding the convoluted approach to this. As the operating system and SQL install are not replicated via the SAN...so there is no other option...at least in...
July 8, 2010 at 4:39 am
Sure, if every thing is the same it should work. The only difference here is the SQL install of the system databases will not be on the SAN on the...
July 8, 2010 at 4:24 am
restoring the master and MSDB from one SQL Instance to another with the same name will work? What about the pointers of the user database location...orphaned users etc (SQL2000/SQL2005)...i don't...
July 8, 2010 at 3:59 am
Thanks for responding,
DNS aliasing is not an option due to inflexible application...there's a lot of cool stuff I want to use however there are tight constraints such as SPs referring...
July 8, 2010 at 3:14 am
Yes, on the secondary - for want of better word - the virtual server will be renamed to match the primary machine's name (this is because of application connectivity) in...
July 8, 2010 at 12:49 am
If it helps, I had firstly "TESTED" my approach and it did work. The primary and the remote databases were shrunk and log shipping restores to the secondary continued. The...
October 5, 2009 at 8:43 am
Viewing 15 posts - 1 through 15 (of 15 total)