Thanks Bob, especially for the second nugget! That was really bothering me (that 'files' seemed to just disappear).
I think I have a reasonable chance to get done what is needed now.
Cheers,
JimN
>Hi Jim,
>
>John has an excellent suggestion in using DTS to move your databases, but you can also do it manually if you don't have access to DTS. Take a look in SQL Books on Line under "Attaching and Detaching Databases". What you basically do is detach the database from the server using stored procedure sp_detach_db, copy the database and log files to the new server, and the attach them using sp_attach_db.
>
>It has been a while, but I remember trying this (successfully) when MSDE first came out just to make sure it would work.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement