sql server data warehouse: 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

[quoted text, click to view]

See 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/


[quoted text, click to view]
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

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