Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-23 : 09:56:54
|
| Ettore writes "Hi! We have db backup made on MSSQLServer2000 and we need to restore it on MSSQLServer70. We tried to set the db compatibility level to 70 both via Ent. Manager 2000 (db properties, options tab) and'EXEC sp_dbcmptlevel 'our_db_on_2000', 70' before backing it up but when we attempted to restore the backup on 70 it generates the error:"SQL-DMO (ODBC SQLState: 42000) Error 3169: The backed-up db has on-disk structure version 539. The server supports 515..."Could you help, please?" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-08-23 : 10:20:02
|
| You cannot do this.*************************Someone done told you wrong! |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-23 : 13:32:40
|
| You will need to use DTS or bcp to move it to SQL 7.HTHJasper Smith |
|
|
|
|
|
|
need to restore a 2000 backup on 7.0 for testing purposes