March 25, 2014 at 9:46 am
Hello,
I am planning to upgrade my database from Sql Server 2012 standard edition to SP1. What is the step by step procedure to do this job? How to rollback it if SP1 upgrade has issues? I only have database engine installed not other features like report ,analysis etc.
Thanks for your input!
March 25, 2014 at 9:51 am
Backup all your databases and install SP1
If you don't like it remove it via Add\Remove programs 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 25, 2014 at 10:10 am
Hello,
I want to upgrade SP1 under the same software root with Sql Server 2012 and if I want to remove it, can I only remove SP1 software but keep sql server 2012 using Windows Add/Remove program? For database part do I need to restore all databases including system database like master etc and user databases if I do rollback? I cannot find this related procedure in Microsoft website.
Thanks for your input!
March 25, 2014 at 10:36 am
You remove just the SP via add/remove programs it rollback for you. The backups are for if anything goes bang! !
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2014 at 9:49 am
Hello,
I have upgraded my database to sql server 2012 SP1, now I need to test remove SP1 part only but still keep sql server 2012.
From Windows add/remove program I have the screen in attached file. There are a lot of sql server 2012 programs like
1.Sql server 2012 (64-bit)
2. Sql server 2012 set up
3. Sql server 2012 native client
4.Sql server broswer for 2012
etc. The versions are all 11.1.3000.0 which is SP1
Which program I will need to remove first or I only need to remove one? Do I start with number 2(Set up program)? My OS is Windows Server 2008 R2 64-bit.
Thanks for your input!
April 2, 2014 at 1:49 pm
I have figured it out that remove SP1 is not from the screen in attachment. It is in View Update screen section in add/remove program part and choose only sql server 2012 SP1 is good which will automatically remove other two SP1 like Sql Server Browser 2012 SP1 etc.
I have done it succeesfully and checked the DB version is rollbacked to 11.0.2100.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply