June 24, 2002 at 12:33 pm
SQL Server 2000 Enterprise Editions
Server 1: Production
Server name: SQL3
Server 2: Off-site Standby
Server name: BUSQL3
I took a master backup from production and restored it to standby. Now standby MSSQLServer service won't start. There is an error message in Services:
"Could not start the MSSQLServer service on the local computer...."
HELP!!!!!!!!
What do I do???
June 24, 2002 at 12:48 pm
The Production is a SQL Server "Named Instance".
Standby is a "Default Instance". Just one instance on this box.
So I used a named instance master backup and restored it to a default instance.
How can I get my standby server back???
June 24, 2002 at 1:25 pm
Why? I think you need to restore the standby back to what it was. I didn't think that the master database went in a restore (in general). The server name will be wrong and it may be attempting to start using the original database files (which would be in use).
Steve Jones
June 24, 2002 at 1:30 pm
I restored the master to get all my logins over.
Steps I did on Standby Server:
1. Single-User mode.
2. Restored Master.
Now SQL Server won't start.
How can I get my standby server back?
June 24, 2002 at 1:40 pm
If they are the same server, then you have a problem. The SQL3 server sees master as c:\mssql\data\master.mdf (or something like this). If you then restored this master on the same server as a different instance, it is trying to start the same master database.
You should be using a 2nd server, or using another method to move logins.
Steve Jones
June 24, 2002 at 2:00 pm
They are 2 different servers. The Standby is off-site as I stated above.
Is there a way to recover the standby server?
I have restored a production master over my standby master. Not standby server will not start.
June 24, 2002 at 2:28 pm
Sorry, I midread. the instances threw me.
Try running SQL Setup and choosing "Rebuild master"
Steve Jones
June 24, 2002 at 2:43 pm
yep. I just tried the Rebuild.exe and it failed. I am in the process of re-installing SQL Server now.
Why would the sever not start? (It restored fine.)
What is the usual process for off-site recovery? (Databases + logins)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply