June 23, 2004 at 11:38 am
Hey guys -
Very much a SQL newbie here, aside from doing basic stuff maintaining my SMS database...
We have a SQL Server 7 database that we wanted to move over to a new SQL Server 2000 box, but when we tried to use the Copy DB wizard in SQL2000, we couldn't see the db that we wanted to copy over.
Doing some digging around, it looks like that database we want to move over is involved in replication.
Is there an easy way to move this database and it's replication items over to the new machine?
Thanks,
Lester
June 24, 2004 at 1:31 am
I'm new enough myself to SQL Server, however try... do a full backup of your database and move the .BAK file to the new server. Also script the Publication/Subscription and save. On the new server run a filelistonly of the .BAK file to get your logical names and the using these do a restore Database with move. That will restore the database on the new server. Then modify the server names ( if required ) in your saved script and create your publication/subscription on the new server. You may need to drop/create the publication/subscription again. Hope I haven't totally confused you now.
Rgds, Derek. (Limerick, Ireland).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply