Hi,

You can use the MAP tool

https://technet.microsoft.com/en-us/solutionaccelerators/dd537566

Here is almost all you need to know

SQL Server 2012 Upgrade Technical Guide

https://msdn.microsoft.com/en-us/library/dn144931.aspx

Hi,

There should be no problems moving DBs to a different path location. Only if you have read-only databases or read-only filegroups you may find some issues. Maybe if you are...

Hi Ricardo,

I would try the sort in tempdb option as you pointed. Maybe if the index rebuilt is clustered, system my be also rebuilding the non-clustered indexes for this table...

Hi,

Remember that SQL Server service user account must be always changed using the SQL Server configuration console, not the Windows service console.

Gazareth (8/4/2015)

JManuelN (8/4/2015)

If a restart is not possible try cleaning some buffer elements that may be using the tempdb and preventing the shrink operation. Please, let us no if it...

Hi,

If a restart is not possible try cleaning some buffer elements that may be using the tempdb and preventing the shrink operation. Please, let us no if it worked.

DBCC FREEPROCCACHE

DBCC...

Hi,

I think that depends if the patch also affect database engine binaries and/or AG database data or metadata. If only affects middleware (SharePoint binaries for example) or database engine binaries,...

Hi did you get the same error if you try to open de SSISDB master key manually?

USE SSISDB

OPEN master Key decryption by password...

Hi,

Yes you can do it. Indeed SSMS 2016 can be downloaded and installed separately.

Download SQL Server Management Studio

https://msdn.microsoft.com/en-us/library/mt238290.aspx

Hi,

PID_REVNUMBER references to some installer software properties so maybe the installation binaries are corrupt o not accessible. In the other hand, error usually points to a registry misconfiguration after a...

Hi,

If you are referring to an AlwaysOn Availability Group, once you perform an index operation in the primary databases, this is also applied to the secondary replicas. If you ask...

Try this query to identify the problem

TempDB usage per active session

http://www.sqlservercentral.com/scripts/tempdb/72007/[/url]

You can install MSDTC before or after SQL Server installation. If your Windows cluster is going to host a single SQL Server instance you can set up MSDTC resource...

This is normal. SQL Server AG "Cluster group" and "OS Cluster Group" are separated entities.

Think as if you have two AG groups and one of them goes down because its...