migrate existing sql database to cluster

We are in the process of putting together a Windows 2000
distributed failover cluster. We have numerous SQL 2000
servers functioning as DB servers for a few different
departments. What we would like to do is eventually
migrate theses databases off of the stand alone servers to
the clustered servers.
Few questions:
Are there any major things to look out for when migrating
the databases? Or is it basically using the migration
wizard thats built into SQL server and dumping the
databases to one of the new installs of SQL on the cluster?
What about transaction and data files? Do these need to
be migrated as well?
Anything major I should be on the lookout for?
Any documentation about this on MS site? I couldnt find
any.
TIA!
Jeff BaileyYou should read on "moving databases between servers".
One Issue that often comes is security (logins/users).
"JBailey" <abc@.123.com> wrote in message
news:096701c34afd$255562c0$a001280a@.phx.gbl...
> We are in the process of putting together a Windows 2000
> distributed failover cluster. We have numerous SQL 2000
> servers functioning as DB servers for a few different
> departments. What we would like to do is eventually
> migrate theses databases off of the stand alone servers to
> the clustered servers.
> Few questions:
> Are there any major things to look out for when migrating
> the databases? Or is it basically using the migration
> wizard thats built into SQL server and dumping the
> databases to one of the new installs of SQL on the cluster?
> What about transaction and data files? Do these need to
> be migrated as well?
> Anything major I should be on the lookout for?
> Any documentation about this on MS site? I couldnt find
> any.
> TIA!
> Jeff Bailey
>|||Easiest way is probably to restore a backup to the other server
or detach/attach
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
or use the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JBailey" <abc@.123.com> wrote in message
news:096701c34afd$255562c0$a001280a@.phx.gbl...
We are in the process of putting together a Windows 2000
distributed failover cluster. We have numerous SQL 2000
servers functioning as DB servers for a few different
departments. What we would like to do is eventually
migrate theses databases off of the stand alone servers to
the clustered servers.
Few questions:
Are there any major things to look out for when migrating
the databases? Or is it basically using the migration
wizard thats built into SQL server and dumping the
databases to one of the new installs of SQL on the cluster?
What about transaction and data files? Do these need to
be migrated as well?
Anything major I should be on the lookout for?
Any documentation about this on MS site? I couldnt find
any.
TIA!
Jeff Bailey