Steps for updating SQL server version

[former_member230931]

Hi All,

I just want to clarify the steps you will need to upgrade the sql server (same server and instance) from 2008 to 2012 version for SAP V9.

1. Take backups of all databases

2. Upgrade SQL server from software download

3. Connect SAP client and test

I'm assuming there is no need to repoint SAP client etc. since its the same instance and automatically client connection will be upgraded? Also SQL native client gets upgraded automatically?

Thanks in advance

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check this link:

Upgrading SQL Server 2008R2 to SQL Server 2012 in 5 minutes - YouTube

Thanks & Regards,

Nagarajan