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
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