editied

Yes, as I said above if you're moving between instances that sql server 2008 or lower your passwords are retained...

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...

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...

Arthur.Bojilov 1605 (6/26/2015)

---

Hi there,

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...

Gordon Feeney (6/16/2015)

---

Also, what might be the meaning of the 'script upgrade mode' errors? Does this indeed sound like a failed SP1 upgrade or is something else at play here?...

andrew_king (6/27/2015)

---

I am wondering what would be the best disk/RAID setup for a Windows server 2008 R2 OS and SQL Server 2012 database that has heavy read/write. I have the...

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...

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...

Tush (6/27/2015)

---

Secondary replica database(setup in async mode) of AlwaysON went in "restricted mode" during weekly reindex operation.

So I have tried below steps

1) Executed following statement on the same secondary replica...

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

sreenubabu.s (6/26/2015)

---

1) For testing before implementing in Production, Can we create Always on High Availability Group with 2 nodes (Active to Passive) on Windows 2012 Hyper-V virtual machines ? we...

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?

To add to what's already been said

Yes, furthermore all nodes must be part of the same Windows Server Failover Cluster

sreenubabu.s (6/25/2015)

---

4) in Always...

Guras (6/25/2015)

---

We are running into the following error while changing a column data type from nvarchar (1200) to varchar(8000)

"Msg 1105, Level 17, State 2, Line 1

Could not allocate space...