| Author |
Topic |
|
jeb0323
Starting Member
26 Posts |
 Posted - 2006-01-27 : 11:18:58
|
| Hi,I was trying to restore a master database. This is what I did:1. rebuild the master database and it was successful2. restart server in single mode with sqlservr.exe -c -mand I got the following window:**********************************************************2006-01-27 10:30:01.49 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)2006-01-27 10:30:01.52 server Copyright (C) 1988-2002 Microsoft Corporation.2006-01-27 10:30:01.52 server All rights reserved.2006-01-27 10:30:01.52 server Server Process ID is 600.2006-01-27 10:30:01.52 server Logging SQL Server messages in file 'e:\Microsoft SQL Server\MSSQL\log\ERRORLOG'.2006-01-27 10:30:01.54 server SQL Server is starting at priority class 'normal'(4 CPUs detected).2006-01-27 10:30:01.71 server SQL Server configured for thread mode processing.2006-01-27 10:30:01.74 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.2006-01-27 10:30:01.99 server Attempting to initialize Distributed Transaction Coordinator.2006-01-27 10:30:04.04 spid3 Warning ******************2006-01-27 10:30:04.04 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.2006-01-27 10:30:04.04 spid3 Starting up database 'master'.2006-01-27 10:30:04.29 server Using 'SSNETLIB.DLL' version '8.0.2039'.2006-01-27 10:30:04.29 spid5 Starting up database 'model'.2006-01-27 10:30:04.29 spid3 Server name is 'SQLTEST1'.2006-01-27 10:30:04.31 spid7 Starting up database 'msdb'.2006-01-27 10:30:04.31 spid8 Starting up database 'pubs'.2006-01-27 10:30:04.31 spid9 Starting up database 'Northwind'.2006-01-27 10:30:04.31 server SQL server listening on 10.10.4.17: 1433.2006-01-27 10:30:04.33 server SQL server listening on 127.0.0.1: 1433.2006-01-27 10:30:04.34 server SQL server listening on TCP, Shared Memory, Named Pipes.2006-01-27 10:30:04.36 server SQL Server is ready for client connections2006-01-27 10:30:04.67 spid5 Clearing tempdb database.2006-01-27 10:30:05.54 spid5 Starting up database 'tempdb'.2006-01-27 10:30:05.70 spid3 Recovery complete.2006-01-27 10:30:05.70 spid3 SQL global counter collection task is created.****************************************************Now is 17 minutes after 11:00:00Am and the window is still there. My questions are how do I know the process is done? What is the next step after SQL global counter collection task? Where can I find more information?Thanks a lot.Jeb |
|
|
jeb0323
Starting Member
26 Posts |
Posted - 2006-01-27 : 12:44:31
|
| Is my question too stupid? Why no one wants to help me? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-27 : 13:31:04
|
| That window means SQL Server is running. You can now use Enterprise Manager to restore the database.Tara Kizeraka tduggan |
|
|
|
jeb0323
Starting Member
26 Posts |
Posted - 2006-01-27 : 13:34:54
|
| But why the sql service manager on the toolbars still has a red icon instead of a green? Thanks again |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-27 : 13:38:54
|
| Because the service isn't started. SQL Server is running in a window and not as a service.Tara Kizeraka tduggan |
|
|
|
jeb0323
Starting Member
26 Posts |
Posted - 2006-01-27 : 13:49:46
|
| Thanks tkizer.I was able to login to Query Analyzer using sa account. But when I tried to restore the master database and was told that backup version is different from the current server. I did not know that. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-27 : 13:51:56
|
| Your SQL Server version that is installed on this server is different than the version when you performed the backup of the master database. This is why you need to perform regular backups of your databases, especially the system ones. So you'll need to figure out what version of SQL Server you were using when the master database was backed up.Do you really need to restore the master database? What's in there that you need? Logins?Tara Kizeraka tduggan |
|
|
|
jeb0323
Starting Member
26 Posts |
Posted - 2006-01-27 : 13:57:55
|
| Yes, the backup is from SQL 7.0 and the current server is SQL 2000. I want to recover the logins, jobs, maintenance plans, etc. All in one, everything was in the old system. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-27 : 15:02:35
|
| You can't restore from 7.0 to 2000 with the master database. Jobs and maintenance plans are stored in the msdb database. I'm pretty sure you won't be able to restore it to 2000 either. When we've performed an upgrade such as this, we've scripted the logins from 7.0 and ran the script on 2000. For everything else, we manually add them.Tara Kizeraka tduggan |
|
|
|
jeb0323
Starting Member
26 Posts |
Posted - 2006-01-27 : 15:59:20
|
| You are right. I am not able to restore the master database from 7.0 to 2000. Even both are 2000 server but the service pack is different, for instance, one is sp3 and the other sp4, I still cannot restore the master database. Am I right? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-27 : 16:04:21
|
| Yes you are right.Tara Kizeraka tduggan |
|
|
|
jeb0323
Starting Member
26 Posts |
Posted - 2006-01-30 : 09:37:37
|
| I managed to restore the master database on a different server that has 7.0 version but I cannot modify the jobs I created before on the new server because the server name gets changed. Should I change the server name in the master and msdb databases? Will sp_dropserver old_server_name and sp_addserver new_server_name work?Thanks a lot. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-30 : 12:24:52
|
| I don't know.Tara Kizeraka tduggan |
|
|
|
|
Help Please - Is it done?