Viewing 15 posts - 1,351 through 1,365 (of 9,253 total)
davidku (2/22/2016)
Just wonder anyone tried to use Log Shipping on MSSQL 2012 collecting data from MSSQL 2008R2 and MSSQL 2005 databases ?
If you do, what's the challenges you encounter...
February 23, 2016 at 5:30 am
muth_51 (2/23/2016)
Perry Whittle (2/23/2016)
February 23, 2016 at 5:28 am
The cluster Client access point is not required for the AG, however for cluster management purposes you will need to ensure you have an IP assignment for each subnet
February 23, 2016 at 5:00 am
I'm based in the UK and can offer remote working, if that's any help please feel free to message me
February 19, 2016 at 4:18 am
Maxer (2/18/2016)
Long story short the infrastructure group seems to think that VM snapshots are all we need for SQL backups.
Theyre good for the OS drives but not for sql server...
February 18, 2016 at 2:51 pm
the upgrade advisor is letting you know you have a query that contains the hint FASTFIRSTROW, support for this has been dropped since sql server 2012. You'll need to rewrite...
February 18, 2016 at 12:53 pm
are you trying to test the process required to recover from a complete server failure, one that's completely lost?
Are you testing other more realistic DR scenarios too, don't just concentrate...
February 18, 2016 at 12:42 pm
Maxer (2/17/2016)
We have two nodes, Red and Blue.
Red was primary, died (and we then failed...
February 18, 2016 at 10:45 am
nikhil.desai1 (2/18/2016)
We have 3 Node cluster (Active-Active-Active) at DC and 2 node cluster (Active-Active) at DR. We want to setup SQL Server 2014 AlwaysOn between DC and DR in a...
February 18, 2016 at 10:39 am
sri2015 (2/18/2016)
as regular practice, SQL Server will load the data in Main memory to...
February 18, 2016 at 10:35 am
Satish Nagaraja (2/16/2016)
His understanding is as follows :A snapshot when created only holds physical database pages that have been updated since the snapshot has been created.
This is not entirely correct....
February 17, 2016 at 10:57 am
curious_sqldba (2/17/2016)
February 17, 2016 at 10:34 am
muthyala_51 (2/16/2016)
Will moving cluster group from node1 to node2 break anything?
Depends if it's been configured correctly?
Moving a cluster role between nodes should otherwise be trouble free apart from the obvious...
February 17, 2016 at 10:29 am
kmounkhaty (2/16/2016)
Our current AlwaysOn design is two nodes in primary DC and one replica in DR DC. We want to move the DR node to new data center and...
February 17, 2016 at 10:28 am
Viewing 15 posts - 1,351 through 1,365 (of 9,253 total)