Adding Databases to an existing SQL Cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian - 29 Aug 2006 14:31 GMT

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.

Reply to this Message

Chris - 29 Aug 2006 14:54 GMT

> 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

Reply to this Message

Brian - 29 Aug 2006 15:17 GMT

Chris,

Thanks for the response. Is there pertinent data in the system databases on
the original sql server that would need to be migrated to the cluster along
with the database?

> > 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
[quoted text clipped - 15 lines]
> Chris
> cfrank@investorforce.com

Reply to this Message

Arnie Rowland - 29 Aug 2006 15:18 GMT

Restoring a Backup to the cluster will be relatively painless -use the MOVE
TO option.

Be sure that all logins are correctly added to the cluster.

Any automation will also have to be moved. Script out jobs, etc, and change
the scripts for the cluster and run them on the cluster. Any DTS packages
will also have to be moved, using DTS designer, save a job on the cluster.
You may have some corrections or alterations necessary for jobs and DTS
packages.

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

>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.

Reply to this Message