How to get a database that is in recovery/pending back online without any data loss?
I was hoping someone (preferbly a fully fledged dba) could help me with a dba corruption issue. My first bit is the database is in a recovery/pending state and needs to be taken off the production live server to my local machine and i need it online so i can check for what is corrupting the database. I have found a few articles online but they involve data loss. I am trying to do this without any data loss. How can i get this online?
P.s. i have been given a full backup of it before it went corrupt so im sure i have to do something with that backup but im just stuck with this.
Please can anyone help?!?!?
Kind regards
sql-server
asked 4 hours ago
UjjiUjji
1
New contributor
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
|
show 2 more comments
I was hoping someone (preferbly a fully fledged dba) could help me with a dba corruption issue. My first bit is the database is in a recovery/pending state and needs to be taken off the production live server to my local machine and i need it online so i can check for what is corrupting the database. I have found a few articles online but they involve data loss. I am trying to do this without any data loss. How can i get this online?
P.s. i have been given a full backup of it before it went corrupt so im sure i have to do something with that backup but im just stuck with this.
Please can anyone help?!?!?
Kind regards
sql-server
asked 4 hours ago
UjjiUjji
1
New contributor
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
First of all you should check SQL Server errorlog to find out the cause of recovery pending state
– sepupic
3 hours ago
Hi thanks for the reply but this occurred due to hardware failure on the node and the node got replaced. Soon as the node got replaced by the hardware team, it was noticed there was multiple databases offline. We have a full backup before the node went down and it contains multiple files within it
– Ujji
1 hour ago
It's not the answer on my question. SQL Server error log has clear error description, and it's not "hardware fail". You can get the answer to your question based on the exact cause of recovery pending state
– sepupic
1 hour ago
>>>im sure i have to do something with that backup<<< So your question is how to restore from a backup???
– sepupic
1 hour ago
We want to take the database to a local server and fix it there, to find out what caused the corruption and what pages have been affected etc. When we have an issue with a live server, we are not allowed to fix this on the live production itself and have to take to a local server first. The database is corrupted but currently in a recovery/pending state...so the question is, how do i take that to a local server and get it online there in order for me to find out what caused the corruption?
– Ujji
1 hour ago
|
show 2 more comments
I was hoping someone (preferbly a fully fledged dba) could help me with a dba corruption issue. My first bit is the database is in a recovery/pending state and needs to be taken off the production live server to my local machine and i need it online so i can check for what is corrupting the database. I have found a few articles online but they involve data loss. I am trying to do this without any data loss. How can i get this online?
P.s. i have been given a full backup of it before it went corrupt so im sure i have to do something with that backup but im just stuck with this.
Please can anyone help?!?!?
Kind regards
sql-server
asked 4 hours ago
UjjiUjji
1
New contributor
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I was hoping someone (preferbly a fully fledged dba) could help me with a dba corruption issue. My first bit is the database is in a recovery/pending state and needs to be taken off the production live server to my local machine and i need it online so i can check for what is corrupting the database. I have found a few articles online but they involve data loss. I am trying to do this without any data loss. How can i get this online?
P.s. i have been given a full backup of it before it went corrupt so im sure i have to do something with that backup but im just stuck with this.
Please can anyone help?!?!?
Kind regards
sql-server
sql-server
asked 4 hours ago
UjjiUjji
1
New contributor
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
UjjiUjji
1
New contributor
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
UjjiUjji
1
New contributor
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
UjjiUjji
1
asked 4 hours ago
UjjiUjji
1
1
New contributor
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Ujji is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
First of all you should check SQL Server errorlog to find out the cause of recovery pending state
– sepupic
3 hours ago
Hi thanks for the reply but this occurred due to hardware failure on the node and the node got replaced. Soon as the node got replaced by the hardware team, it was noticed there was multiple databases offline. We have a full backup before the node went down and it contains multiple files within it
– Ujji
1 hour ago
It's not the answer on my question. SQL Server error log has clear error description, and it's not "hardware fail". You can get the answer to your question based on the exact cause of recovery pending state
– sepupic
1 hour ago
>>>im sure i have to do something with that backup<<< So your question is how to restore from a backup???
– sepupic
1 hour ago
We want to take the database to a local server and fix it there, to find out what caused the corruption and what pages have been affected etc. When we have an issue with a live server, we are not allowed to fix this on the live production itself and have to take to a local server first. The database is corrupted but currently in a recovery/pending state...so the question is, how do i take that to a local server and get it online there in order for me to find out what caused the corruption?
– Ujji
1 hour ago
|
show 2 more comments
First of all you should check SQL Server errorlog to find out the cause of recovery pending state
– sepupic
3 hours ago
Hi thanks for the reply but this occurred due to hardware failure on the node and the node got replaced. Soon as the node got replaced by the hardware team, it was noticed there was multiple databases offline. We have a full backup before the node went down and it contains multiple files within it
– Ujji
1 hour ago
It's not the answer on my question. SQL Server error log has clear error description, and it's not "hardware fail". You can get the answer to your question based on the exact cause of recovery pending state
– sepupic
1 hour ago
>>>im sure i have to do something with that backup<<< So your question is how to restore from a backup???
– sepupic
1 hour ago
We want to take the database to a local server and fix it there, to find out what caused the corruption and what pages have been affected etc. When we have an issue with a live server, we are not allowed to fix this on the live production itself and have to take to a local server first. The database is corrupted but currently in a recovery/pending state...so the question is, how do i take that to a local server and get it online there in order for me to find out what caused the corruption?
– Ujji
1 hour ago
First of all you should check SQL Server errorlog to find out the cause of recovery pending state
– sepupic
3 hours ago
First of all you should check SQL Server errorlog to find out the cause of recovery pending state
– sepupic
3 hours ago
Hi thanks for the reply but this occurred due to hardware failure on the node and the node got replaced. Soon as the node got replaced by the hardware team, it was noticed there was multiple databases offline. We have a full backup before the node went down and it contains multiple files within it
– Ujji
1 hour ago
Hi thanks for the reply but this occurred due to hardware failure on the node and the node got replaced. Soon as the node got replaced by the hardware team, it was noticed there was multiple databases offline. We have a full backup before the node went down and it contains multiple files within it
– Ujji
1 hour ago
It's not the answer on my question. SQL Server error log has clear error description, and it's not "hardware fail". You can get the answer to your question based on the exact cause of recovery pending state
– sepupic
1 hour ago
It's not the answer on my question. SQL Server error log has clear error description, and it's not "hardware fail". You can get the answer to your question based on the exact cause of recovery pending state
– sepupic
1 hour ago
>>>im sure i have to do something with that backup<<< So your question is how to restore from a backup???
– sepupic
1 hour ago
>>>im sure i have to do something with that backup<<< So your question is how to restore from a backup???
– sepupic
1 hour ago
We want to take the database to a local server and fix it there, to find out what caused the corruption and what pages have been affected etc. When we have an issue with a live server, we are not allowed to fix this on the live production itself and have to take to a local server first. The database is corrupted but currently in a recovery/pending state...so the question is, how do i take that to a local server and get it online there in order for me to find out what caused the corruption?
– Ujji
1 hour ago
We want to take the database to a local server and fix it there, to find out what caused the corruption and what pages have been affected etc. When we have an issue with a live server, we are not allowed to fix this on the live production itself and have to take to a local server first. The database is corrupted but currently in a recovery/pending state...so the question is, how do i take that to a local server and get it online there in order for me to find out what caused the corruption?
– Ujji
1 hour ago
|
show 2 more comments
0
active
oldest
votes
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
});
}
});
Ujji is a new contributor. Be nice, and check out our Code of Conduct.
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%2f226677%2fhow-to-get-a-database-that-is-in-recovery-pending-back-online-without-any-data-l%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Ujji is a new contributor. Be nice, and check out our Code of Conduct.
Ujji is a new contributor. Be nice, and check out our Code of Conduct.
Ujji is a new contributor. Be nice, and check out our Code of Conduct.
Ujji is a new contributor. Be nice, and check out our Code of Conduct.
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f226677%2fhow-to-get-a-database-that-is-in-recovery-pending-back-online-without-any-data-l%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
First of all you should check SQL Server errorlog to find out the cause of recovery pending state
– sepupic
3 hours ago
Hi thanks for the reply but this occurred due to hardware failure on the node and the node got replaced. Soon as the node got replaced by the hardware team, it was noticed there was multiple databases offline. We have a full backup before the node went down and it contains multiple files within it
– Ujji
1 hour ago
It's not the answer on my question. SQL Server error log has clear error description, and it's not "hardware fail". You can get the answer to your question based on the exact cause of recovery pending state
– sepupic
1 hour ago
>>>im sure i have to do something with that backup<<< So your question is how to restore from a backup???
– sepupic
1 hour ago
We want to take the database to a local server and fix it there, to find out what caused the corruption and what pages have been affected etc. When we have an issue with a live server, we are not allowed to fix this on the live production itself and have to take to a local server first. The database is corrupted but currently in a recovery/pending state...so the question is, how do i take that to a local server and get it online there in order for me to find out what caused the corruption?
– Ujji
1 hour ago