Sunday, February 19, 2012

event id 17055

Hi,
I having a problem starting sql server in a cluster. The error has the
description;
17113:
initconfig: Error 2(the system cannot find the file specified.) opening
'master.mdf' for configuration information
did you check if the file master.mdf exist?
first check in cluster administrator if the configuration is ok and the
resources are available.
If the master.mdf is corrupt, you can't start sqlserver.
So you have to do a restore.
Start up SQL server in single user mode:
check this ARTICLE!
http://articles.techrepublic.com.com/5100-1035_11-5025441.html
GOOD LUCK!
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
"snazzy" wrote:

> Hi,
> I having a problem starting sql server in a cluster. The error has the
> description;
> 17113:
> initconfig: Error 2(the system cannot find the file specified.) opening
> 'master.mdf' for configuration information
|||Hi,
I am able to start the SQL server manually through a command line. The
error occurs when I try to start SQL server through the Cluster
Administrator. Does this mean the master.mdf is still corrupt?
Thanks
"Hate_orphaned_users" wrote:
[vbcol=seagreen]
> did you check if the file master.mdf exist?
> first check in cluster administrator if the configuration is ok and the
> resources are available.
> If the master.mdf is corrupt, you can't start sqlserver.
> So you have to do a restore.
> Start up SQL server in single user mode:
> check this ARTICLE!
> http://articles.techrepublic.com.com/5100-1035_11-5025441.html
> GOOD LUCK!
> --
> I drank alot of beer and ended up in the police department database.
> Drank more beer and learned SQL in the dark hours.
> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
> I love SQL
>
>
> "snazzy" wrote:
|||More likely that the quorum registry entries that locate the master database
are corrupt or the installation is not properly configured for failover
clustering.
Can you provide some historical context?
If it is registry keys, then you will need to perform a cluster recovery
scenario:
http://support.microsoft.com/kb/258078
http://support.microsoft.com/kb/266274
Good luck.
Sincerely,
Anthony Thomas

"snazzy" <snazzy@.discussions.microsoft.com> wrote in message
news:9F443B16-693C-4F52-B204-4C7E96A539B7@.microsoft.com...[vbcol=seagreen]
> Hi,
> I am able to start the SQL server manually through a command line. The
> error occurs when I try to start SQL server through the Cluster
> Administrator. Does this mean the master.mdf is still corrupt?
> Thanks
> "Hate_orphaned_users" wrote:
the[vbcol=seagreen]
opening[vbcol=seagreen]

No comments:

Post a Comment