new hardware - sqlserver 2000 transfer

Hi!
I have a sqlserver 2000 (windows 2000 server) running and my machine is now
too slow.
So I want to buy a new one (dualprocessor) and transfer my database to that
server.
I have a lot of dts jobs, user, roles, rights, cubes, dimensions how could I
get that all to my new server?
my main sqlserver database is 120 GB is on a 136 GB drive f in windows.
how could I get all these things to my new server?
Who can me say the steps?
ThanksSee if this helps:
How to move SQL Server to a new computer?
http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hubert Mayr" <huma1@.gmx.net> wrote in message
news:1091784043.72762@.news.liwest.at...
Hi!
I have a sqlserver 2000 (windows 2000 server) running and my machine is now
too slow.
So I want to buy a new one (dualprocessor) and transfer my database to that
server.
I have a lot of dts jobs, user, roles, rights, cubes, dimensions how could I
get that all to my new server?
my main sqlserver database is 120 GB is on a 136 GB drive f in windows.
how could I get all these things to my new server?
Who can me say the steps?
Thanks|||If you have cubes, you'll have to back them up using the cube backup
program..
additionally you may have to change the datasource property in Analysis
services ( if you are changing the server name.)
You may also have to change the client connectivity stuff for people who
connect to the server ( if the server name is changing..)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hubert Mayr" <huma1@.gmx.net> wrote in message
news:1091784043.72762@.news.liwest.at...
> Hi!
> I have a sqlserver 2000 (windows 2000 server) running and my machine is
now
> too slow.
> So I want to buy a new one (dualprocessor) and transfer my database to
that
> server.
> I have a lot of dts jobs, user, roles, rights, cubes, dimensions how could
I
> get that all to my new server?
> my main sqlserver database is 120 GB is on a 136 GB drive f in windows.
> how could I get all these things to my new server?
> Who can me say the steps?
> Thanks
>