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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  replication state is indeterminant

Author  Topic  robman Starting Member 6 Posts Posted - 2005-08-19 : 15:53:57 Hi I am trying to restore the data from sandbox machine to production machine . On executing the script on production machine ------- restore database SM from disk='\\relfile2\PRDBAKD\SMPDATA1.BAK', disk='\\relfile2PRDBAKD\SMPDATA2.BAK' with recovery, replace, move 'SMPDATA1' to 'G:\SMDATA1\SMDATA1.mdf', move 'SMPDATA2' to 'G:\SMDATA2\SMDATA2.ndf', move 'SMPDATA3' to 'G:\SMDATA3\SMDATA3.ndf', move 'SMPLOG1' to 'G:\SMLOG1\SMLOG1.ldf' ------ it throws the following error " Invalid object name 'sysobjects'. Server: Msg 3165, Level 16, State 1, Line 1 Could not adjust the replication state of database 'SM'. The database was successfully restored, however its replication state is indeterminate. See the Troubleshooting Replication section in SQL Server Books Online. RESTORE DATABASE successfully processed 980857 pages in 509.612 seconds (15.767 MB/sec)." To rectify this i have run the query 'EXECUTE sp_removedbreplication SM' on the sandbox machine and took a fresh full backup and tried to run the script again on the producition machine. But this time it gives the error " Processed 330200 pages for database 'SM', file 'SMPDATA1' on file 1. Processed 322560 pages for database 'SM', file 'SMPDATA2' on file 1. Processed 328944 pages for database 'SM', file 'SMPDATA3' on file 1. Processed 8 pages for database 'SM', file 'SMPLOG1' on file 1. Server: Msg 208, Level 16, State 1, Procedure sp_restoredbreplication, Line 89 Invalid object name 'sysobjects'. Server: Msg 208, Level 16, State 1, Procedure sp_restoredbreplication, Line 89 Invalid object name 'sysobjects'. Server: Msg 208, Level 16, State 1, Procedure sp_restoredbreplication, Line 89 Invalid object name 'sysobjects'. Server: Msg 208, Level 16, State 1, Procedure sp_restoredbreplication, Line 89 Invalid object name 'sysobjects'. Server: Msg 3165, Level 16, State 1, Line 1 Could not adjust the replication state of database 'SM'. The database was successfully restored, however its replication state is indeterminate. See the Troubleshooting Replication section in SQL Server Books Online. RESTORE DATABASE successfully processed 981712 pages in 1009.143 seconds (7.969 MB/sec)." How do i rectify this error? Thanks Rob