Hi All,

I know it’s an old thread but seemed a right place to ask this question. I want to confirm that what databases I need to restore back if we decide to rollback an upgrade.

For example:

1. We took backup of all the databases.

2. We installed SQL Server 2008 R2 Service Pack 2.

In case we want to rollback this upgrade we can use “Add or Remove Programs” to uninstall this upgrade.

I want to confirm that, once we have uninstalled the SP2 successfully using control panel, do we need to restore the backups of system databases master, model, msdb & mssqlsystemresource again? Or is it not required & it is done by the uninstall process itself?

Any insight on this is appreciated 🙂

PS: I can create a new thread if you think that would be more appropriate.