Saturday, February 25, 2012

Restore Master Problem

We are in the process of upgrading our servers. We tried to Restore Master
Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
SP3 on WIN 2003 Server SP1. The restore says its successful but the service
doesn't start after restoring. I am using local system account on both the
machines.
Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
same problem.
I would really appreciate if you could give me some suggestions.
on the original server do you have anything unusual like
- tempdb in ram
- max server memory greater than what is available on new server.
- additional tempdb on drive which does not exist etc . .
- what errors do you get in error log?
- did sql start with -m option?
- if all fails you may have to try -f option - see BOL for more details
HTH
"Pradip" wrote:

> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.
|||1. Start SQL from the console ( command prompt) ie sqlservr.exe -m
2. Then do the restore from the database backup.
3. thern Ctrl-C the console, and restart SQL Serve..
What error messages are you getting?
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:C4E333AA-055D-4EDC-8271-9DF88AF68B9C@.microsoft.com...
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL
2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the
service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.

No comments:

Post a Comment