Best practice to downgrade a Ms Sql Server to a previous version
We need to downgrade ms sql server from 2014 back to 2008 and wanted EE advice if we are doint it correctly. We plan to first uninstall sql 2014, then reinstall sql 2008, finally restore the sql2008 databases (note when we installed sql2014, we didn't uninstall sql2008). Please advice if we need to consider any steps omitted. Thank you in advance.
Obadiah Christopher
What happens to the new data that was created as part of Sql 2014
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if SQL 2008 wasn't uninstalled, was it stopped after 2014 installed and started? did 2014 manage any data previously managed by 2008?
BTW, can you please let us know why you need or have to downgrade SQL from 14 to 08?
BTW, can you please let us know why you need or have to downgrade SQL from 14 to 08?
Are your databases restored to SQL 2014? Then you cant downgrade at all.
You cant restore a database backup from SQL 2014 to SQL 2008 at all.
You cant restore a database backup from SQL 2014 to SQL 2008 at all.
ASKER
Obadiah,
The new data as part of sql2014 is not important since we have copies of the same database in thier sql version (the version we need to downgrade).
ste5an,
Why you emphazie in "I really hope you mean 2008 R2"?
For restoreing the database, we dopn;t need to do anything the DB, we have the originasl in the sql2008 version we need to downgrade to. As soon as we have sql2008, we "attached" the DBs (yes, we are going to do a clean uninstall of sql2014. Question, if we have the original sql2008 database we dont need to "script out all objects"?
bbao,
no, 2014 didn't manage any data previously managed by 2008. We need to downgrade to start a process of reinstallation of series of apps that has an upgrade path.
bharat,
Yes, our DB was restores to 2014, but we can delete them, we have 2008 versions.
As to "doangrade" we just want to have sql2008 back in the computer.
The new data as part of sql2014 is not important since we have copies of the same database in thier sql version (the version we need to downgrade).
ste5an,
Why you emphazie in "I really hope you mean 2008 R2"?
For restoreing the database, we dopn;t need to do anything the DB, we have the originasl in the sql2008 version we need to downgrade to. As soon as we have sql2008, we "attached" the DBs (yes, we are going to do a clean uninstall of sql2014. Question, if we have the original sql2008 database we dont need to "script out all objects"?
bbao,
no, 2014 didn't manage any data previously managed by 2008. We need to downgrade to start a process of reinstallation of series of apps that has an upgrade path.
bharat,
Yes, our DB was restores to 2014, but we can delete them, we have 2008 versions.
As to "doangrade" we just want to have sql2008 back in the computer.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ste5an,
Understood; does seem complicated "clean uninstall", but we will uninstall an install with you guys advice (we want to downgrade the sql server back to sql2008 because to restart a process of installs sql and other apps all the way to sql2017 latest version)
Got it Vitor.
Understood; does seem complicated "clean uninstall", but we will uninstall an install with you guys advice (we want to downgrade the sql server back to sql2008 because to restart a process of installs sql and other apps all the way to sql2017 latest version)
Got it Vitor.
ASKER
Thank you guys!
> no, 2014 didn't manage any data previously managed by 2008.
then i don't think any technical problem or difficulty to reuse 2008 for managing 2008's data. there is NO database convertion or platform migration issue here.
then i don't think any technical problem or difficulty to reuse 2008 for managing 2008's data. there is NO database convertion or platform migration issue here.
ASKER
Exactly. Thank you.