Restoring SQL 7 backup to 2000

[Phil99]

Hi,

We want to swap our production server which is currently running SQL 7 with another server which runs SQL 2000. To move the data we were going to backup the production server and then restore the database to our new SQL 2000 server.

I gave it a try but received the following error msg:

Microsoft SQL-DMO(ODBC SQLState:42S22)
Invalid column name 'enabled_for_syncmgr'
Could not adjust the replication state of database 'Database name'. The database was successfully restored, however its replication state is indeterminate.

Is there a straight forward fix for this issue?

Is this restoration technique advisable or am I going to run into lots of issues.

Thanks

Phil

 

[ukflix]

Hi
I have a similar problem facing me. Did you find a good solution for this? Thanks ukflix.

 

[Phil99]

The issue about was cause by a couple of old subscriptions which weren't working. After I removed them everything was fine.

After you have restored the database you just need to reset the db owner. This can be done by first change the dbowner to sa and then changing it to the orignal owner. For example:

sp_changedbowner 'sa'

then

sp_changedbowner 'ARAdmin'

You then update any database logins which may not automatically map across.

Use sp_change_users_login 'report' to pick these up.

Good luck

Cheers

Phil