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)  restore script

Author  Topic  robman Starting Member 6 Posts Posted - 2005-08-17 : 21:06:13 I am using sql server 2000 database. I have run the following script to do homogeneous system copy from Production to Sandbox machine. --------- restore database SM from disk='D:\solman\SMPDATA1.BAK', disk='D:\solman\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' -------- but 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). " Could you please let me know how to adjust the replication state of database. Thanks