Moving servers

I am planing to build a new sql 2000 serevr on a new
server machine, so that I can upgrade the existing servers
to a new spec and have failover clustering.
I plan to copy all the database to the new server using
the copy wizard, this will copy all the SP etc from the
origal server to the new server, but how can you copy 200+
dts packages to this new server without going into each
package and saving it to the new locationHow about this
Transferring DTS Packages
(http://www.sqldts.com/Default.aspx?204)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Allan" <penstona@.sitel.co.uk> wrote in message
news:067501c39c73$881c8b50$a101280a@.phx.gbl...
> I am planing to build a new sql 2000 serevr on a new
> server machine, so that I can upgrade the existing servers
> to a new spec and have failover clustering.
> I plan to copy all the database to the new server using
> the copy wizard, this will copy all the SP etc from the
> origal server to the new server, but how can you copy 200+
> dts packages to this new server without going into each
> package and saving it to the new location
>|||Try the DTSBackup tool that is available on SQLDTS.com.
--
Jacco Schalkwijk
SQL Server MVP
"Allan" <penstona@.sitel.co.uk> wrote in message
news:067501c39c73$881c8b50$a101280a@.phx.gbl...
> I am planing to build a new sql 2000 serevr on a new
> server machine, so that I can upgrade the existing servers
> to a new spec and have failover clustering.
> I plan to copy all the database to the new server using
> the copy wizard, this will copy all the SP etc from the
> origal server to the new server, but how can you copy 200+
> dts packages to this new server without going into each
> package and saving it to the new location
>|||SQL Server store DTS packages in MSDB database.
So, if you are going to transfer your DBs from old 2K to a
new 2K Server, you can just make backup/restore operation.
Make sure you transfer MSDB database for the DTS packages.
You also can have a problem with system logins.
Take a look at this article about this issue:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;246133&Product=sql
Regards.
---
All information provided above AS IS.
>--Original Message--
>I am planing to build a new sql 2000 serevr on a new
>server machine, so that I can upgrade the existing
servers
>to a new spec and have failover clustering.
>I plan to copy all the database to the new server using
>the copy wizard, this will copy all the SP etc from the
>origal server to the new server, but how can you copy
200+
>dts packages to this new server without going into each
>package and saving it to the new location
>.
>