February 18, 2008 at 6:38 am
Hello,
i have a database-backup from a server version 8 and i want to restore it on a server version 7.0.
Is there a possibility to do that?
thank you very much
kg
February 18, 2008 at 7:56 am
kgache (2/18/2008)
Hello,i have a database-backup from a server version 8 and i want to restore it on a server version 7.0.
Is there a possibility to do that?
thank you very much
kg
Unfortunately this is not possible. You could restore it onto a 2000 server, and then use DTS to transfer the data. Alternatively you could use bcp for the data, or third party migration tools.
Regards,
Andras
February 18, 2008 at 9:10 am
Make sure this is SQL Server. We do get people thinking that MySQL or Sybase are handled here.
As Dr. Andras mentioned, you cannot restore a backup to a lower version. you can restore to 2000 and transfer the schema and data or you can restore and set the compatibility mode to 7.
February 18, 2008 at 9:27 am
hello,
i am quite sure it is a mssql server..
please tell me if i understood correctly
- i have the database on a mssqlserver version 2000
- i go to the properties of the database and set in the options "database compatibility level 70"
- i backup the database
- i send the backup to my user
- my user can restore on sqlserver version 7
i ask because i do not have a server version 7 or i would test
so thank you very much for info
kg
February 18, 2008 at 9:37 am
hello,
i am quite sure it is a mssql server..
please tell me if i understood correctly
- i have the database on a mssqlserver version 2000
- i go to the properties of the database and set in the options "database compatibility level 70"
- i backup the database
- i send the backup to my user
- my user can restore on sqlserver version 7
i ask because i do not have a server version 7 or i would test
so thank you very much for info
kg
February 18, 2008 at 9:39 am
kgache (2/18/2008)
hello,i am quite sure it is a mssql server..
please tell me if i understood correctly
- i have the database on a mssqlserver version 2000
- i go to the properties of the database and set in the options "database compatibility level 70"
- i backup the database
- i send the backup to my user
- my user can restore on sqlserver version 7
i ask because i do not have a server version 7 or i would test
so thank you very much for info
kg
Unfortunately this will not work 🙁 You cannot create a backup on SQL Server 2000 that you would be able to restore onto a SQL Server 7.
What you could do it so script the objects and the data, (make sure that it does not have 2000 syntax), and create the same database and data using the scripts. This is of course a tedious process and possible error prone. Or you, could use DTS to migrate the database data to a live SQL Server 7 database, but you need to be able to access the SQL Server 7 database.
The compatibility mode Steve mentioned, is for SQL Server 2000. (you could access your database as if it were a 7 database, but the backup would still be relying on SQL Server 2000 internals, so you will not be able to transfer the database using a backup).
Regards,
Andras
February 18, 2008 at 9:54 am
Dr. Andras is correct. You cannot restore this on SQL 7. The compatibility mode just determines how object names, keywords, and other structures are handled by SQL Server 2000. It allows valid 7.0 keywords that would be invalid in 2000, to work. The structure of the file is SQL Server 7.
Your client needs to upgrade to 2000 (7.0 is unsupported right now) or you need to build a 7.0 server that you can use to work on.
February 19, 2008 at 2:05 am
thank you for the very speedy and clear answers
i am already installing 7 ...
katherine gache
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply