Viewing 15 posts - 1 through 15 (of 162 total)
Thanks for the response,I have been preaching this gospel that this failback is manual and is recommended practise for it to be manual but i SQL is being compared...
November 14, 2018 at 6:13 am
the order of etl should then be in sequence with the foreign keys. by comparing it's key to the table which holds the same key as primary key.
May 11, 2016 at 2:24 am
If this tables are linked to an application or applications, the application process flow should guide you on what gets captured first. So perhaps if you enable a profiler and...
May 11, 2016 at 2:08 am
That part I understand, but can I upgrade sql without using slipstream option if I have SQL 2014 SP1 image?
July 31, 2015 at 12:34 am
Thanks, and is it true that upgrading SQL 2008 R2 to SQL 2014 on windows 2008 R2 SP1 can only be done the Slipstream way?
July 30, 2015 at 4:40 am
Also supply us with error logs from cluster manager, look for the option called critical events.
July 30, 2015 at 4:30 am
Any maintenance plans for reindexing or index reorg schedules?
July 28, 2015 at 4:20 am
Try using a different SQL install media or re-downloading a fresh copy, your install file could be corrupt especially when there's no thread in the internet of such. If you...
July 28, 2015 at 3:44 am
Thanks i'll keep that in mind.
Any thing I should look up for when upgrading the OS to SP1?
does it have any impact on my current SQL 2008 R2 SP2 enterprise?
July 27, 2015 at 2:48 am
SQL 2008 R2 enterprise with SP2 and CU.
the current environment is running Windows 2008 R2 enterprise.
One more thing, ALWAYSON availability groups are only available on windows 2012 or can I...
July 27, 2015 at 2:33 am
July 26, 2015 at 9:17 am
I have attached the snapshot of Ip configuration of Node1 , Node2 and DC.
Node1 and Node2 has both private and Public ip.
Now i have recreated cluster and reinstalled...
July 24, 2015 at 9:11 am
May I ask if you can use different IP ranges as well, it shouldn't have any impact to your underlying problem but it's recommended
to have public IPs on 192.***.*** range...
July 24, 2015 at 9:04 am
Thanks for the feedback.
I see your subnet mask configurations are different for public and private IP are different, can you please use the same subnet mask IP for both...
July 24, 2015 at 9:00 am
You need to restart the SQL Server browser service if it's already running otherwise start it if it's not running.
July 24, 2015 at 6:46 am