Wednesday, March 21, 2012

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

No comments:

Post a Comment