Viewing 15 posts - 1,981 through 1,995 (of 9,244 total)
ramana3327 (6/25/2015)
Hi Perry,Is the passwords are same as the original passwords?
Yes, as I said above if you're moving between instances that sql server 2008 or lower your passwords are retained...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 5:48 am
the account sql server runs under will attempt to register and deregister the SPN each time it starts and stops. If the account hasn't been provided with the necessary AD...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 5:28 am
All AGs on the instance will use the same mirror endpoint but then the same is true if all the dbs are in the same group, they'll still use the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2015 at 5:25 am
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
Viewing 15 posts - 1,981 through 1,995 (of 9,244 total)