We wil be upgrading all of our sql servers to new hardware and from Windows
2000 to 2003. The servers are in a merge replication topology.
We hope to keep the server names the same.
It would be an extreme hardship to drop the publications and recreate them.
Given these parameters, what is the best approach?
Do one last sync. Take the publisher offline, back up all databases to tape,
restore on the new server. Reboot. It should come up automagically.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CHeineken" <CHeineken@.discussions.microsoft.com> wrote in message
news:AA8B3EBA-C4C7-468B-AB23-27CFC725DB48@.microsoft.com...
> We wil be upgrading all of our sql servers to new hardware and from
> Windows
> 2000 to 2003. The servers are in a merge replication topology.
> We hope to keep the server names the same.
> It would be an extreme hardship to drop the publications and recreate
> them.
> Given these parameters, what is the best approach?
>
|||Just to be clear...
When you take the publisher offline, do you mean stop all agents?
When restoring to new server, here is the plan:
Install SQLServer with same service packs and hotfixes as default instance
on server with the same name as original.
Start SQLServer in single user mode.
Restore master and msdb
Start SQLServer in normal mode.
Restore Distribution, model, tempdb and user databases.
Is this correct? Am I missing anything?
"Hilary Cotter" wrote:
> Do one last sync. Take the publisher offline, back up all databases to tape,
> restore on the new server. Reboot. It should come up automagically.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "CHeineken" <CHeineken@.discussions.microsoft.com> wrote in message
> news:AA8B3EBA-C4C7-468B-AB23-27CFC725DB48@.microsoft.com...
>
>
|||Forget what I said about restoring the tempdb...brain fart.
"CHeineken" wrote:
[vbcol=seagreen]
> Just to be clear...
> When you take the publisher offline, do you mean stop all agents?
> When restoring to new server, here is the plan:
> Install SQLServer with same service packs and hotfixes as default instance
> on server with the same name as original.
> Start SQLServer in single user mode.
> Restore master and msdb
> Start SQLServer in normal mode.
> Restore Distribution, model, tempdb and user databases.
> Is this correct? Am I missing anything?
> "Hilary Cotter" wrote:
|||Yes, run the agents one last time until they stop or report no replicated
data. Then follow your steps and in the final restore of the user database
use the keep_replication switch.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CHeineken" <CHeineken@.discussions.microsoft.com> wrote in message
news:81899ABF-321B-42E2-9370-5C7143B02E63@.microsoft.com...[vbcol=seagreen]
> Just to be clear...
> When you take the publisher offline, do you mean stop all agents?
> When restoring to new server, here is the plan:
> Install SQLServer with same service packs and hotfixes as default instance
> on server with the same name as original.
> Start SQLServer in single user mode.
> Restore master and msdb
> Start SQLServer in normal mode.
> Restore Distribution, model, tempdb and user databases.
> Is this correct? Am I missing anything?
> "Hilary Cotter" wrote:
Showing posts with label upgrading. Show all posts
Showing posts with label upgrading. Show all posts
Monday, March 26, 2012
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.
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.
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 20
00
> SP3 on WIN 2003 Server SP1. The restore says its successful but the servic
e
> 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.
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 20
00
> SP3 on WIN 2003 Server SP1. The restore says its successful but the servic
e
> 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.
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.
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.
Subscribe to:
Posts (Atom)