New Server

I have a win2000 server that is in need of replacement, we
have built a new server and now need to configure sql 2000.
From backups I retored all the databases including msdb.
How do I restore the Master database, as this has lots of
extra system SP that need on the new server.
I tried putting the Instance in single user mode and doing
a restore, which said it worked OK but when trying to
restart SQL it fail to start. Any ideas what I am doing
wrongWhat's the error in the SQL Server error log?
See if this helps too: http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
I have a win2000 server that is in need of replacement, we
have built a new server and now need to configure sql 2000.
From backups I retored all the databases including msdb.
How do I restore the Master database, as this has lots of
extra system SP that need on the new server.
I tried putting the Instance in single user mode and doing
a restore, which said it worked OK but when trying to
restart SQL it fail to start. Any ideas what I am doing
wrong|||What was the reason to backup/restore the system DB instead of generating
the script for the SPs (extra system SP)
and running the script on the new server ?
If they are system SPs they should be common across all master DBs, right ?
Gopi
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
>I have a win2000 server that is in need of replacement, we
> have built a new server and now need to configure sql 2000.
> From backups I retored all the databases including msdb.
> How do I restore the Master database, as this has lots of
> extra system SP that need on the new server.
> I tried putting the Instance in single user mode and doing
> a restore, which said it worked OK but when trying to
> restart SQL it fail to start. Any ideas what I am doing
> wrong
>|||Allan
From my experience i have learned that first of all script out all logins
(there are two SP provided by MS) and then jobs as well
There is no need to restore master,msdb databases , instead restore all user
databases and run the script generated by these SP's.
In the same way you can move all DTS packages (to save the as files). You
will not lost anything.
"Allan" <asql@.penstonall.co.uk> wrote in message
news:714601c52622$882fe170$a601280a@.phx.gbl...
> I have a win2000 server that is in need of replacement, we
> have built a new server and now need to configure sql 2000.
> From backups I retored all the databases including msdb.
> How do I restore the Master database, as this has lots of
> extra system SP that need on the new server.
> I tried putting the Instance in single user mode and doing
> a restore, which said it worked OK but when trying to
> restart SQL it fail to start. Any ideas what I am doing
> wrong
>