Migrating a SQL 2000 DB to a SQL 2005 DB

I would like to find out what the steps are to migrate a 2000 database up to 2005?

Either BACKUP the SQL 2000, and RESTORE to the SQL 2005

OR

DETACH the database file and ATTACH it to SQL 2005

In both situation, you will then want to rebuild the indexes and update the statistics.

|||

what steps do I take to rebuild the indexes and update stats?

Is the option to select within sql server to rebuild the indexes and update the stats?

|||

Look in Books Online about how to use:

DBCC dbreindex DBCC updateusage UPDATE STATISTICS

migrate sql 2000 to a new sql 2000 server

Does anyone have some simple steps I can follow, I did some reading and
discovered that database backup and recovery is the best way, also recoving
the master, msdb, and the model then the rest of the databases is a good
solution? Please help from a sql2000 server to a another sql2000 serverPerhaps below?
http://vyaskn.tripod.com/moving_sql_server.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mac54" <u43153@.uwe> wrote in message news:832c32f8c50df@.uwe...
> Does anyone have some simple steps I can follow, I did some reading and
> discovered that database backup and recovery is the best way, also recoving
> the master, msdb, and the model then the rest of the databases is a good
> solution? Please help from a sql2000 server to a another sql2000 server
>|||On Apr 25, 1:58=A0am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Perhaps below?
> http://vyaskn.tripod.com/moving_sql_server.htm
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph=
ttp://sqlblog.com/blogs/tibor_karaszi
>
> "mac54" <u43153@.uwe> wrote in messagenews:832c32f8c50df@.uwe...
> > Does anyone have some simple steps I can follow, I did some reading and
> > discovered that database backup and recovery is the best way, also recov=ing
> > the master, msdb, and the model then the rest of the databases is a good=
> > solution? Please help from a sql2000 server to a another sql2000 server-= Hide quoted text -
> - Show quoted text -
You can also refer belo link
http://support.microsoft.com/kb/224071
Thanks
Ajay Rengunthwar
MCTS,MCDBA,MCAD|||maybe this can help you...
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
bye
"Tibor Karaszi" wrote:
> Perhaps below?
> http://vyaskn.tripod.com/moving_sql_server.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "mac54" <u43153@.uwe> wrote in message news:832c32f8c50df@.uwe...
> > Does anyone have some simple steps I can follow, I did some reading and
> > discovered that database backup and recovery is the best way, also recoving
> > the master, msdb, and the model then the rest of the databases is a good
> > solution? Please help from a sql2000 server to a another sql2000 server
> >
>