Solved

Convert SQL 2005 Databsase back to SQL 2000 database??

Posted on 2007-12-04
5
2,137 Views
Last Modified: 2012-05-05
Long story short, we have an SQL 2000 database that we converted to an SQL 2005 database for use with an unreliable yet extremely necessary third party software. after the convert and install, software developer now says SQL 2005 is not compatible. IF IF IF they are correct (and that is a BIG BIG BIG IF, they have not yet provided any reliable information) is there a way to roll back the converted SQL 2005 database to a 2000 SQL database. Don't know if it matters but the thrid party software uses an MS Access front end.  

Again, is there a way to convert an SQL 2005 database back to an SQL 2000 database?


0
Comment
Question by:shmedlick
  • 3
  • 2
5 Comments
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 20403742
Put the database back into 8.0 compatibility mode, after doing a backup, of course.

It will function exactly like a database on a 2000 server would.  I run many of them this way with no issues.
0
 

Author Comment

by:shmedlick
ID: 20403861
i put it back into 8.0 compatibility mode, install SQL 2000 server and it'll run as if nothing ever happened?
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 20403960
No, just put it in 8.0 compatibility mode.  There is no need to reinstall SQL 2000.  

Even in a SQL 2005 instance, a database in 8.0 compatibility mode will work just as if it's on a 2000 server.
0
 

Author Comment

by:shmedlick
ID: 20404156
NO. Third party won't support it unless its on 2000 SQL. so if it doesnt work i'll have to uninstall 2005 and reinstall 2000. will the database open and run properly if it's installed on a 2000 SQL if its been put in 8.0 compatibility mode?
0
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 125 total points
ID: 20404518
No, the database won't convert downward to something you can simply attach to SQL 2000.

Your best bet at this point is to try and use the copy database wizard to put it all back on a 2000 instance.

It amazes me that vendors won't work with SQL 2005 servers in 8.0 compatibility mode.  I feel your pain.  I have 130+ SQL Servers and have a couple vendors who do this too.  Even though we've demonstrated to them that everything works, they want to blame their coding problems on SQL Server.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question