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
 SQL Server Development (2000)
 Transferring Databases

Author  Topic 

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2000-12-07 : 21:42:30
Hi there,

I want to transfer all my databases from one server to another. Im looking at the best way to do this and have been experimenting with the the Transfer SQL Server Objects task under DTS services in Enterprize manager.

I have found though that this method does not transfer FULL TEXT CATALOGS. Is there possibly something I am doing wrong? or is this not possible?

Any other suggestions as to the best procedure to transfer databases from one server to another (a one off event in this case) would be appreciated

Thanks - matt

   

- Advertisement -