Viewing 15 posts - 46 through 60 (of 313 total)
pietlinden (1/29/2015)
I think you can create a stored procedure to join the two tables and flatten the data and then just group...
January 29, 2015 at 11:53 am
How did you make out?
January 29, 2015 at 11:02 am
Anyone have any suggestions? I suppose I could get this built if I collect the data and report off of that, but I was trying to have a live...
January 29, 2015 at 9:39 am
To further this discussion about trying to use a snapshot, you cannot recover the database if a snapshot exists of the DB while it is in mirroring mode. You...
January 29, 2015 at 9:37 am
S. Kusen (1/28/2015)
I will stand by the 3-node WSFC, two FCI's of SQL Server within that cluster, and then you can establish an availability group between the two FCI's.
This won't...
January 28, 2015 at 11:09 am
So, as a final response ( I hope). My goal is not to reduce shared storage. In fact, my goal is to decrease redundant storage (In this case only). Also,...
January 28, 2015 at 8:33 am
Perry Whittle (1/28/2015)
S. Kusen (1/27/2015)
The storage for each FCI would be presented to each node of the cluster.
No, see above. To recap, you'll only usually unmask the shared storage to...
January 28, 2015 at 7:29 am
5. Restore the DB from the snapshot with recovery (not sure if this is even possible)
You can restore the database from snapshot with recovery only. Although you can include the...
January 27, 2015 at 2:24 pm
If you break the mirror and set partner off, the LSN needs to get back into sequence for mirroring to pick back up. We've always just done the full...
January 27, 2015 at 12:35 pm
does anyone see any issues with the quorum disk moving between nodes of this 4 node cluster where only nodes A and B will house InstanceA and only nodes C...
January 27, 2015 at 12:06 pm
I will chime in with my thoughts here to add to what Perry has said... If you need three instances of SQL (one for the newApp OLTP, one for...
January 27, 2015 at 11:59 am
Silly, but obvious question- is the Extended Event session running? Sometimes when they are created, they are disabled by default. Are you able to view live data and...
January 27, 2015 at 11:44 am
It sounds like you are changing the data type in the database, but not updating it in the SSIS data flow task. Since you seem to know what the...
January 27, 2015 at 11:40 am
mhorner 67968 (11/24/2014)
November 24, 2014 at 12:26 pm
Thanks for sharing. That's a relatively quick and dirty way to get the error log entries from multiple systems. I don't yet have PS3 installed, so I modified...
August 26, 2014 at 1:46 pm
Viewing 15 posts - 46 through 60 (of 313 total)