Brian wrote:
> I need to move SQL 2000 databases from existing stand-alone servers to an
> already established SQL 2000 Cluster. What is the best way to do this
> without losing permissions, jobs, stored procedures, etc? The drive letters
> in which SQL is installed will likely be different as their are multiple
> servers that were configured differently.

"Chris" wrote:

>
> Brian wrote:
> > I need to move SQL 2000 databases from existing stand-alone servers to an
> > already established SQL 2000 Cluster. What is the best way to do this
> > without losing permissions, jobs, stored procedures, etc? The drive letters
> > in which SQL is installed will likely be different as their are multiple
> > servers that were configured differently.
>
> Brian,
>
> In this case I would use sp_detach_db and then use the sp_attach_db
> which would probably be the easiest method for you. Once the database
> is detached you will be able to just copy and paste the data and log
> files to the new SQL Server and then do the attach to that drive
> location. If you have jobs either DTS or SQL Scheduler jobs you will
> need to move them seperatly. Please let me know if you have any further
> questions.
>
> thanks
> Chris
> cfrank@investorforce.com
>