Viewing 15 posts - 1,981 through 1,995 (of 9,241 total)
Arthur.Bojilov 1605 (6/26/2015)
Thank you for your replies, and apologies for my late reply.
I will try to clarify.
I have created two VMs (Server 2012) on two ESXi v.6 hosts. the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 28, 2015 at 1:51 am
Gordon Feeney (6/16/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 28, 2015 at 1:45 am
andrew_king (6/27/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 28, 2015 at 1:32 am
Of course licencing the hyperv host CPUs with suitable windows and sql server editions will enable you to run multiple vms without issue.
If it truly is a test server then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 28, 2015 at 1:07 am
The following script will transfer logins and roles
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL OFF
DECLARE @uid INT
DECLARE @sql NVARCHAR(MAX)
SELECT @sql = ''
--=============================================
--First get the SQL logins
--=============================================
SELECT principal_id, [type] INTO #sqlusers FROM sys.server_principals WHERE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2015 at 6:45 am
Tush (6/27/2015)
So I have tried below steps
1) Executed following statement on the same secondary replica...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2015 at 6:37 am
I'll need to test to confirm but if you suspend data movement at the primary you should be able to set the RCSI option on the primary database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2015 at 6:31 am
sreenubabu.s (6/26/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2015 at 6:23 am
What have you defined as the secondary role options for the secondary database?
You have setup the listener but have you setup read only routing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2015 at 6:13 am
To add to what's already been said
sreenubabu.s (6/25/2015)
1) Windows Clusters Needed or not ?
Yes, furthermore all nodes must be part of the same Windows Server Failover Cluster
sreenubabu.s (6/25/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 26, 2015 at 3:41 am
Guras (6/25/2015)
"Msg 1105, Level 17, State 2, Line 1
Could not allocate space...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 10:21 am
ramana3327 (6/25/2015)
Thank you.When you execute Revlogin
How to get all logins @ same time. Looks we need each login name as parameter
you'll find my script a lot easier 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:19 am
Joy Smith San (6/24/2015)
setspn -S MSSQLSvc/[sqlinstance] [domain]\[svcaccount]
I was running exactly the same command. Then it gave the message "Updated SPN...." but still logging this error in errorlog and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:15 am
Arthur.Bojilov 1605 (6/24/2015)
I hope you can help with the installation of SQL Server 2008R2 on Server 2012.
Here is my setup.
I am migrating a SQL 2008R2 two node physical cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:11 am
nzone7x (6/24/2015)
Our environment has 4 nodes clustered, I do not know what you call the topology.
the technology is known as Failover Clustering
nzone7x (6/24/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:08 am
Viewing 15 posts - 1,981 through 1,995 (of 9,241 total)