July 10, 2008 at 1:26 pm
I’m having a problem when I restore a SQL 2000 backup on a SQL 2005 server. The SQL 2000 backup was backed up with transactional replication configured. This is a prod server so I can’t drop replication to do the backup.
When I restore the backup and try to create the publication it fails because the SYNC_ and FLTR_ objects are still in sysobjects. I know in SQL 2005 I can’t delete from sysobjects directly like I could in SQL 2000. These objects are orphaned and I don’t know how to get rid of them so I can configure replication.
I appreciate the help!
July 10, 2008 at 4:23 pm
did you try:
exec sp_removedbreplication
right after the restore ?
* Noel
July 14, 2008 at 12:08 pm
Thanks for the reply, I tried exec sp_removedbreplication but it won't remove the SYNC_ objects from sysobjects. Even weirder, I can't restore any SQL 2000 backup that was backed up with replication configured on our SQL 2005 server. I first have to restore the production SQL 2000 bak on a dev SQL 2000 server, then back it up again and restore that bak on our dev SQL 2005 server. I've been doing the deletes from sysobjects when I restore on the dev SQL 2000 server.
If I restore the origional production SQL 2000 bak (the one make with repl configured) on our dev SQL 2005 server without the interium dev SQL 2000 restore I get the following error:
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The statistics 'columns' is dependent on column 'columns'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
October 4, 2009 at 12:30 pm
I was able to resolve this by running sp_updatestats on the database before I made the final bak in SQL 2000.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply