A botched update that failed halfway is causing issues, I was wondering how I could roll back an update for SQL Server? Secondly, I was wondering if there is any other place (aside from) **Setup Bootstrap\Log** where I could see which updates were installing and which one failed. I use SQL Server 2012
Sql-server – how to roll back SQL Server updates
sql serversql-server-2012
Related Question
- SQL Server 2012 Express – Fixing ‘Could Not Find Database Engine Startup Handle’ Error
- SQL Server 2012 – How to Fail Back After Log Shipping Failover
- SQL Server – How to Remove SQL Server 2012
- SQL Server 2012 Always On Setup – Two Nodes Configuration
- SQL Server 2012 – How to Resolve Installation Errors
- Sql-server – Cannot install database engine services, replication and SQL writer
- SQL Server Rollback – Why Did a SQL Server Restart Roll-Back Seemingly Committed Transactions?
Best Answer
That path is the full source of SQL installation info and is a goldmine.
The best way to deal with a failed patch is to find out what happened; either in those files or the SQL ERRORLOG. It's most commonly SSISDB in an availability group or a filestream error (fixable with add/remove programs on the instance to run a repair).
I'm not sure if you can rollback an unsuccessful patch but it's easy to reapply the patch and try again, they resume very very well. After its successfully installed then they're easy to uninstall with add/remove programs again.
There aren't many good reasons to uninstall an SP or CU for SQL though. They're pretty important.