Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2009-12-03 : 11:44:31
|
| we have a corrupted master database. I try to open the instance in single user mode so that I can restore the database (sqlservr.exe -m on command line in binn folder), when when i do, I get Server Error: 17058. Severity: 16, State: 1. Server initerrlog: could not open error log file ' '. Operating system error = 3(the system cannot find the path specified.).Can anyone shed any light on this? |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-12-03 : 16:46:18
|
| have the permissions changed on the physical sql files? Perhaps your datafolder has gone missing, or the sql service account does not have permissions for the folder you are attempting to use in your restore. |
 |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2009-12-03 : 17:30:31
|
| I wasn't getting to the restore part, it wasn't letting me start the db in single user mode. I was in a time crunch, so I wound up restoring the software and then restoring the other databases (except master). |
|
|
|
|
|
|
restore master database