HI All,

we are planning to upgrade sql server 2008 R2 to SQL Server 2012 sp2.  We had decided to go for in-place upgrade.  We wanted to know post upgrade steps that we need to take care.

we have pointed out 2 things:

1)  changing db compatability

2)dbcc checkdb (dbanme) with data_purity.  Apart from these two please let us know if we need to take care of anything else.

Regards,

Varun

Hello Varun,

please have a look at:

http://thomaslarock.com/2014/06/upgrading-to-sql-server-2014-a-dozen-things-to-check/
https://www.mssqltips.com/sqlservertip/1936/sql-server-database-migration-checklist/