juliandormon
asked on
Can I restore a MS SQL 2005 DB to a MS SQL 2000 DB using built-in restore (downgrade)?
I just moved over my DB from MS SQL 200 to MS SQL 2005 and now I'm getting the odd error;
Brief Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I was wondering if it's possible to backup the 2005 DB and restore back on my 2000 machine?
Brief Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I was wondering if it's possible to backup the 2005 DB and restore back on my 2000 machine?
If you set the database compatibility down to 80 (SQL 2000), you should be able to easily downgrade the database and restore it on the 2000 machine. Provided you haven't used any 2005 specific features yet.
ASKER CERTIFIED 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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.