Restoring Master Database

Hi !
I'm about to move a SQL Server installation to a new server. Is using
backup/restore to move all databases. Both servers is SQL Server 2000 with
SP4.
I have read all books online topics about this (and I have done this kind of
operation before) but somehow I'm missing out on something, hope you can see
what I'm missing =)
This will descibe the actions I have taken
1. Full backup of all databases on server1.
2. Copy all backupfiles to server2.
3. Starting SQL Server with the -c -m switch for Single mode on server2
4. Restoring master database on server2 with the following syntax
RESTORE DATABASE master FROM disk='E:\MSSQL\backup\master.bak'
WITH MOVE 'master' to 'E:\mssql\data\master.mdf',
MOVE 'mastlog' to 'E:\mssql\data\mastlog.ldf',
REPLACE
go
5. Message from QU says that restore worked fine and that SQL Server will be
shut down.
Then the problem starts! I can't get SQL Server to start again... The
service goes to "starting" mode and the directly to "stopping". Of cource
there are several messages in logs saying that the "user" databases can't be
recovered. But that's "normal" right? Since the Master database is pointing
out database that I havn't restored yet.
But what do I need to do more to be able to restore user databases and get
server up and running'
Regards FredrikThe problem is probably that you also have file references for model and tem
pdb in the restored
master database. I think you have some good info about thin is KB 224071.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:D484D6E7-6627-47E2-A070-95E969267BC1@.microsoft.com...
> Hi !
> I'm about to move a SQL Server installation to a new server. Is using
> backup/restore to move all databases. Both servers is SQL Server 2000 with
> SP4.
> I have read all books online topics about this (and I have done this kind
of
> operation before) but somehow I'm missing out on something, hope you can s
ee
> what I'm missing =)
> This will descibe the actions I have taken
> 1. Full backup of all databases on server1.
> 2. Copy all backupfiles to server2.
> 3. Starting SQL Server with the -c -m switch for Single mode on server2
> 4. Restoring master database on server2 with the following syntax
> RESTORE DATABASE master FROM disk='E:\MSSQL\backup\master.bak'
> WITH MOVE 'master' to 'E:\mssql\data\master.mdf',
> MOVE 'mastlog' to 'E:\mssql\data\mastlog.ldf',
> REPLACE
> go
> 5. Message from QU says that restore worked fine and that SQL Server will
be
> shut down.
> Then the problem starts! I can't get SQL Server to start again... The
> service goes to "starting" mode and the directly to "stopping". Of cource
> there are several messages in logs saying that the "user" databases can't
be
> recovered. But that's "normal" right? Since the Master database is pointin
g
> out database that I havn't restored yet.
> But what do I need to do more to be able to restore user databases and get
> server up and running'
> Regards Fredrik
>
>|||Thanx Tibor. That really pointed me in the right direction and saved me a lo
t
of time!
Thanks again!
/Fredrik
"Tibor Karaszi" wrote:

> The problem is probably that you also have file references for model and t
empdb in the restored
> master database. I think you have some good info about thin is KB 224071.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
> news:D484D6E7-6627-47E2-A070-95E969267BC1@.microsoft.com...
>
>