This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi guys,
I have a server where SQL Server 2012 Express was installed.
Yesterday, I upgraded to 2017 version.
Now I need to roll back.
Can I uninstall SQL Server 2017 without affecting 2012 installation?
Additional SQL Server features and topics not covered by specific categories
In addition to other posts:
If you want to revert to SQL 2012, you uninstall SQL 2017, install SQL 2012, apply service packs. You would then have to restore backups taken with SQL 2012 - I hope you took backups before the upgrade!
You cannot restore backups from SQL 2017, nor can you cannot attach the database files to SQL 2012.
work with a new database they get an error message.
Which exact error message do they get? Is SQL Server service up & running?
Please review installation log for more details for what went wrong during installation: View and Read SQL Server Setup Log Files
Review also SQL Server ErrorLog file to see if there are errors noted: Viewing the SQL Server Error Log
> Can I uninstall SQL Server 2017 without affecting 2012 installation?
No. SQL server 2012 becomes to SQL server 2017, when doing an in-place upgrade for SQL server 2012. When you uninstalling SQL server 2017, the SQL server instance will be removed. So there is no SQL server 2012 existed. In another word, you can not roll back SQL 2017 to SQL 2012, after you doing an in-place upgrade for SQL 2012.
If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Hi @Olaf Helper ,
Yes it was.
When software vendor support tried to create a database or work with a new database they get an error message.
Was that an in-place migration? Why do you need to rollback?