SQL Server 2008 R2 couldn't be started
The SQL Server Service Couldn't be started and logs the below error in the event viewer
Log Name: Application
Source: MSSQLSERVER
Date: 4/9/2017 12:36:06 PM
Event ID: 9003
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: LUCAPP-PC
Description:
The log scan number (26:456:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">9003</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-04-09T09:36:06.000000000Z" />
<EventRecordID>10396724</EventRecordID>
<Channel>Application</Channel>
<Computer>LUCAPP-PC</Computer>
<Security />
</System>
<EventData>
<Data>(26:456:1)</Data>
<Data>model</Data>
<Binary>2B230000140000000A0000004C00550043004100500050002D0050004300000000000000</Binary>
</EventData>
</Event>
I solved this issue by replacing the Model.MDF and Model.LDF files with another files from another installation for SQL Server 2008 R2 Express.
My Question is; Why this error occurs repeatedly? and How to avoid this error?
Thanks IN Advance
sql-server sql-server-2008
edited Apr 27 '17 at 12:43
George K
1,224520
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Apr 27 '17 at 12:11
This question came from our site for professional and enthusiast programmers.
add a comment |
The SQL Server Service Couldn't be started and logs the below error in the event viewer
Log Name: Application
Source: MSSQLSERVER
Date: 4/9/2017 12:36:06 PM
Event ID: 9003
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: LUCAPP-PC
Description:
The log scan number (26:456:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">9003</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-04-09T09:36:06.000000000Z" />
<EventRecordID>10396724</EventRecordID>
<Channel>Application</Channel>
<Computer>LUCAPP-PC</Computer>
<Security />
</System>
<EventData>
<Data>(26:456:1)</Data>
<Data>model</Data>
<Binary>2B230000140000000A0000004C00550043004100500050002D0050004300000000000000</Binary>
</EventData>
</Event>
I solved this issue by replacing the Model.MDF and Model.LDF files with another files from another installation for SQL Server 2008 R2 Express.
My Question is; Why this error occurs repeatedly? and How to avoid this error?
Thanks IN Advance
sql-server sql-server-2008
edited Apr 27 '17 at 12:43
George K
1,224520
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Apr 27 '17 at 12:11
This question came from our site for professional and enthusiast programmers.
1
If this happens repeatedly - have you considered storage subsystem problems?
– George K
Apr 27 '17 at 12:35
add a comment |
The SQL Server Service Couldn't be started and logs the below error in the event viewer
Log Name: Application
Source: MSSQLSERVER
Date: 4/9/2017 12:36:06 PM
Event ID: 9003
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: LUCAPP-PC
Description:
The log scan number (26:456:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">9003</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-04-09T09:36:06.000000000Z" />
<EventRecordID>10396724</EventRecordID>
<Channel>Application</Channel>
<Computer>LUCAPP-PC</Computer>
<Security />
</System>
<EventData>
<Data>(26:456:1)</Data>
<Data>model</Data>
<Binary>2B230000140000000A0000004C00550043004100500050002D0050004300000000000000</Binary>
</EventData>
</Event>
I solved this issue by replacing the Model.MDF and Model.LDF files with another files from another installation for SQL Server 2008 R2 Express.
My Question is; Why this error occurs repeatedly? and How to avoid this error?
Thanks IN Advance
sql-server sql-server-2008
edited Apr 27 '17 at 12:43
George K
1,224520
The SQL Server Service Couldn't be started and logs the below error in the event viewer
Log Name: Application
Source: MSSQLSERVER
Date: 4/9/2017 12:36:06 PM
Event ID: 9003
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: LUCAPP-PC
Description:
The log scan number (26:456:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">9003</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-04-09T09:36:06.000000000Z" />
<EventRecordID>10396724</EventRecordID>
<Channel>Application</Channel>
<Computer>LUCAPP-PC</Computer>
<Security />
</System>
<EventData>
<Data>(26:456:1)</Data>
<Data>model</Data>
<Binary>2B230000140000000A0000004C00550043004100500050002D0050004300000000000000</Binary>
</EventData>
</Event>
I solved this issue by replacing the Model.MDF and Model.LDF files with another files from another installation for SQL Server 2008 R2 Express.
My Question is; Why this error occurs repeatedly? and How to avoid this error?
Thanks IN Advance
sql-server sql-server-2008
sql-server sql-server-2008
edited Apr 27 '17 at 12:43
George K
1,224520
edited Apr 27 '17 at 12:43
George K
1,224520
edited Apr 27 '17 at 12:43
George K
1,224520
edited Apr 27 '17 at 12:43
George K
1,224520
edited Apr 27 '17 at 12:43
George K
1,224520
1,224520
asked Apr 9 '17 at 10:33
Abdelrahman
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from stackoverflow.com Apr 27 '17 at 12:11
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Apr 27 '17 at 12:11
This question came from our site for professional and enthusiast programmers.
1
If this happens repeatedly - have you considered storage subsystem problems?
– George K
Apr 27 '17 at 12:35
add a comment |
1
If this happens repeatedly - have you considered storage subsystem problems?
– George K
Apr 27 '17 at 12:35
1
1
If this happens repeatedly - have you considered storage subsystem problems?
– George K
Apr 27 '17 at 12:35
If this happens repeatedly - have you considered storage subsystem problems?
– George K
Apr 27 '17 at 12:35
add a comment |
1 Answer
1
active
oldest
votes
The procreation of the error 9003 Here may be caused due to inconsistency, corruption, or replication issues taking place between the MDF files and the LDF files. The error message might also occurred due to misconfigured system files or registry issues of files.
answered Apr 27 '17 at 13:36
Md Haidar Ali KhanMd Haidar Ali Khan
3,62062340
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f172154%2fsql-server-2008-r2-couldnt-be-started%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The procreation of the error 9003 Here may be caused due to inconsistency, corruption, or replication issues taking place between the MDF files and the LDF files. The error message might also occurred due to misconfigured system files or registry issues of files.
answered Apr 27 '17 at 13:36
Md Haidar Ali KhanMd Haidar Ali Khan
3,62062340
add a comment |
The procreation of the error 9003 Here may be caused due to inconsistency, corruption, or replication issues taking place between the MDF files and the LDF files. The error message might also occurred due to misconfigured system files or registry issues of files.
answered Apr 27 '17 at 13:36
Md Haidar Ali KhanMd Haidar Ali Khan
3,62062340
add a comment |
The procreation of the error 9003 Here may be caused due to inconsistency, corruption, or replication issues taking place between the MDF files and the LDF files. The error message might also occurred due to misconfigured system files or registry issues of files.
answered Apr 27 '17 at 13:36
Md Haidar Ali KhanMd Haidar Ali Khan
3,62062340
The procreation of the error 9003 Here may be caused due to inconsistency, corruption, or replication issues taking place between the MDF files and the LDF files. The error message might also occurred due to misconfigured system files or registry issues of files.
answered Apr 27 '17 at 13:36
Md Haidar Ali KhanMd Haidar Ali Khan
3,62062340
answered Apr 27 '17 at 13:36
Md Haidar Ali KhanMd Haidar Ali Khan
3,62062340
answered Apr 27 '17 at 13:36
Md Haidar Ali KhanMd Haidar Ali Khan
3,62062340
answered Apr 27 '17 at 13:36
Md Haidar Ali KhanMd Haidar Ali Khan
3,62062340
3,62062340
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f172154%2fsql-server-2008-r2-couldnt-be-started%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
If this happens repeatedly - have you considered storage subsystem problems?
– George K
Apr 27 '17 at 12:35