Downgrade from SQL 2008 to 2005

Hi there,

How effective is a downgrade of a SQL 2008 database to 2005, and what is the best process to achieve this?

Thanks
LVL 7
RomoloIT Professional ConsultantAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
>> Would we need to undertake this in 2008 first, or can we load it in 2005 and it will fix as it is loading?

Since you are not aware of the environment, Just install SQL Server 2005 at your machine using the Downgraded license and use it for your Backup Exec..
0
 
p_nutsCommented:
I don't know why you would want that.
I would first check what compatibility mode the database is in. before doing that.
With that you could run 2008 and service 2005 applications.
If you really want to downgrade I think the best approach would be to set all the compatibility's to 2005 or lower and migrate the db's to a new server or new service if it's on the same machine.
and if it works uninstall 2008
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
If your SQL Server 2008 purchase contains downgrade option to SQL Server 2005, then you can do it..
But My recommendation would be to use SQL Server 2008 since it contains many additional features compared to 2005.

Is there any specific reason you are thinking to downgrade to 2005, so that I can guide you accordingly..
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
RomoloIT Professional ConsultantAuthor Commented:
We have a client using Backup Exec 11d that we believe is not compatible with SQL 2008. They are unable to upgrade to 12.5 which supports SQL 2008 so we are examining possible work arounds, such as downgrading their SQL 2008 database to 2005 to allow Backup Exec 11d compatibility.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Kindly confirm whether you need SQL Server 2005 Engine and services or just SQL Server 2005 Databases because you can create a database in 2008 with compatibility mode set to 2005..

If not, then you can do the downgrade to 2005.
0
 
RomoloIT Professional ConsultantAuthor Commented:
We are unsure as we do not know if the issue is is the database or the installation.
Can we confirm the correct process for a downgrade from 2008 -> 2005. Would we need to undertake this in 2008 first, or can we load it in 2005 and it will fix as it is loading?
0
 
RomoloIT Professional ConsultantAuthor Commented:
OK,
Thank you and apologies for the late reply
 
R
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Kindly let me know whether this is resolved out or not..
If not let me know where you are exactly struck so that we can start from that..
0
 
RomoloIT Professional ConsultantAuthor Commented:
I think ths would be the best option

Thank you for your time
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.