I have a sql 2k sp3 db server that isn't starting. It's giving an error message that says "Errror: 9003 Severity 20, State 1. The LSN (626:44:1) passed to log scan in database model is invalid."
I tried starting the server in single user mode (sqlservr.exe -c -m) hoping to just restore the model database.
However, I am still unable to connect to the database using Ent Mgr or SQL Query Analyzer. Both applications give me a "SQL Server does not exist or access is denied" message.
I've got a few questions:
- Based on the error message, #9003, am I right in thinking that I can restore a good backup of my model db to fix my problem?
- Should I be able to connect to my server using SQL Ent Mgr or SQL Query Analyzer when it is started in single user mode? If not, do I need to use OSQL?
- Am I wasting my time with this approach and should I just rebuild my master db? <groan>
TIA,
-StuartYou should be able to restore the model database with either Enterprise
Manager or Query Analyzer. Make sure that SQL Server Agent is not running.
Make sure that SQL Server is listening on named pipes and try to connect to
SQL Server using a "." from Query Analyser.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment