VLDB is stuck in recovery state. It's a permission issue, now what should I do?Backup failure in SQL Server...
Information to fellow intern about hiring?
I see my dog run
Was there ever an axiom rendered a theorem?
I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine
Eliminate empty elements from a list with a specific pattern
What does 'script /dev/null' do?
How many letters suffice to construct words with no repetition?
Add an angle to a sphere
Is this homebrew feat, Beast of Burden, balanced?
aging parents with no investments
Is it true that "The augmented fourth (A4) and the diminished fifth (d5) are the only aug and dim intervals that appear in diatonic scales"
When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?
Manga about a female worker who got dragged into another world together with this high school girl and she was just told she's not needed anymore
Could a US political party gain complete control over the government by removing checks & balances?
How to create a consistant feel for character names in a fantasy setting?
How to move the player while also allowing forces to affect it
How to answer pointed "are you quitting" questioning when I don't want them to suspect
How to manage monthly salary
Is this food a bread or a loaf?
Doomsday-clock for my fantasy planet
My colleague's body is amazing
What is GPS' 19 year rollover and does it present a cybersecurity issue?
LM317 - Calculate dissipation due to voltage drop
How can I fix this gap between bookcases I made?
VLDB is stuck in recovery state. It's a permission issue, now what should I do?
Backup failure in SQL Server 2005unable to bring database online from recovery pendingWhy do the databases go into the “recovery pending” state when the share permissions are changed from “everyone”?SQL Server data folder access rightsSQL Server Management Studio crashes when attaching an mdf filePermission error when executing a 5.6 GB sqlcmd fileSuddenly cannot access SQL Server databasewhen running SSMS “as Administrator” whose rights are used for physical file permissions when creating a databaseBULK INSERT getting “Cannot bulk load because … Access is denied” on a file I have access toRestore database - Operating system error 5(Access is denied.) on Linux
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
SQL Server database which is very large (4TB) is stuck in recovery state. Reason: Data center had a planned downtime and we had to turn the physical machine off and when it turned on, as I read in error logs, SQL Server couldn't access the files, because files were on a SAN machine, and probably things didn't went smooth.
FCB::Open failed: Could not open file E:SomeFolderSomeDatabase.mdf for file
number 1. OS error: 5(Access is denied.).
Now that I've made sure that SAN is up and running, and permission are OK, how can I tell SQL Server to continue recovering? Since this database is very large, I don't want to interrupt the course of recovering and start from the beginning. And also, any backup would take hours to complete.
sql-server recovery
asked Jan 16 '16 at 4:55
Saeed NeamatiSaeed Neamati
5501618
add a comment |
SQL Server database which is very large (4TB) is stuck in recovery state. Reason: Data center had a planned downtime and we had to turn the physical machine off and when it turned on, as I read in error logs, SQL Server couldn't access the files, because files were on a SAN machine, and probably things didn't went smooth.
FCB::Open failed: Could not open file E:SomeFolderSomeDatabase.mdf for file
number 1. OS error: 5(Access is denied.).
Now that I've made sure that SAN is up and running, and permission are OK, how can I tell SQL Server to continue recovering? Since this database is very large, I don't want to interrupt the course of recovering and start from the beginning. And also, any backup would take hours to complete.
sql-server recovery
asked Jan 16 '16 at 4:55
Saeed NeamatiSaeed Neamati
5501618
This is an OS-level error. SQL Server cannot just decide to continue. You can't tell it to continue. You need to ensure OS-level permissions. Grand full control to Everyone to test this. Then revert to saner permissions.
– usr
Jan 17 '16 at 13:10
If the permissions are ok, then try doing DB OFFLINE and DB ONLINE.
– SQLPRODDBA
May 20 '16 at 7:51
add a comment |
SQL Server database which is very large (4TB) is stuck in recovery state. Reason: Data center had a planned downtime and we had to turn the physical machine off and when it turned on, as I read in error logs, SQL Server couldn't access the files, because files were on a SAN machine, and probably things didn't went smooth.
FCB::Open failed: Could not open file E:SomeFolderSomeDatabase.mdf for file
number 1. OS error: 5(Access is denied.).
Now that I've made sure that SAN is up and running, and permission are OK, how can I tell SQL Server to continue recovering? Since this database is very large, I don't want to interrupt the course of recovering and start from the beginning. And also, any backup would take hours to complete.
sql-server recovery
asked Jan 16 '16 at 4:55
Saeed NeamatiSaeed Neamati
5501618
SQL Server database which is very large (4TB) is stuck in recovery state. Reason: Data center had a planned downtime and we had to turn the physical machine off and when it turned on, as I read in error logs, SQL Server couldn't access the files, because files were on a SAN machine, and probably things didn't went smooth.
FCB::Open failed: Could not open file E:SomeFolderSomeDatabase.mdf for file
number 1. OS error: 5(Access is denied.).
Now that I've made sure that SAN is up and running, and permission are OK, how can I tell SQL Server to continue recovering? Since this database is very large, I don't want to interrupt the course of recovering and start from the beginning. And also, any backup would take hours to complete.
sql-server recovery
sql-server recovery
asked Jan 16 '16 at 4:55
Saeed NeamatiSaeed Neamati
5501618
asked Jan 16 '16 at 4:55
Saeed NeamatiSaeed Neamati
5501618
edited Jan 17 '16 at 7:24
Saeed Neamati
asked Jan 16 '16 at 4:55
Saeed NeamatiSaeed Neamati
5501618
asked Jan 16 '16 at 4:55
Saeed NeamatiSaeed Neamati
5501618
asked Jan 16 '16 at 4:55
Saeed NeamatiSaeed Neamati
5501618
5501618
This is an OS-level error. SQL Server cannot just decide to continue. You can't tell it to continue. You need to ensure OS-level permissions. Grand full control to Everyone to test this. Then revert to saner permissions.
– usr
Jan 17 '16 at 13:10
If the permissions are ok, then try doing DB OFFLINE and DB ONLINE.
– SQLPRODDBA
May 20 '16 at 7:51
add a comment |
This is an OS-level error. SQL Server cannot just decide to continue. You can't tell it to continue. You need to ensure OS-level permissions. Grand full control to Everyone to test this. Then revert to saner permissions.
– usr
Jan 17 '16 at 13:10
If the permissions are ok, then try doing DB OFFLINE and DB ONLINE.
– SQLPRODDBA
May 20 '16 at 7:51
This is an OS-level error. SQL Server cannot just decide to continue. You can't tell it to continue. You need to ensure OS-level permissions. Grand full control to Everyone to test this. Then revert to saner permissions.
– usr
Jan 17 '16 at 13:10
This is an OS-level error. SQL Server cannot just decide to continue. You can't tell it to continue. You need to ensure OS-level permissions. Grand full control to Everyone to test this. Then revert to saner permissions.
– usr
Jan 17 '16 at 13:10
If the permissions are ok, then try doing DB OFFLINE and DB ONLINE.
– SQLPRODDBA
May 20 '16 at 7:51
If the permissions are ok, then try doing DB OFFLINE and DB ONLINE.
– SQLPRODDBA
May 20 '16 at 7:51
add a comment |
2 Answers
2
active
oldest
votes
SQL server service account does not have permission to access the file.
- Navigate to the folder in which this file is residing
- Grant Full control privilege on this folder to the SQL server service account.
- Bring the DB Offline - Online or Restart SQL server services.
answered Sep 13 '16 at 7:28
Midhun C NMidhun C N
155113
add a comment |
I'm not an SQL internals expert, but I highly suspect that there will be nothing you can do to gently prompt SQL to re-check the files and continue database recovery where it left off; it will have abandoned the recovery effort when encountering that error.
As the other answer suggests, you'll have to either restart the SQL instance entirely, or take the database offline and back online to start recovery over.
answered 24 mins ago
BradCBradC
6,64263462
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%2f126419%2fvldb-is-stuck-in-recovery-state-its-a-permission-issue-now-what-should-i-do%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
SQL server service account does not have permission to access the file.
- Navigate to the folder in which this file is residing
- Grant Full control privilege on this folder to the SQL server service account.
- Bring the DB Offline - Online or Restart SQL server services.
answered Sep 13 '16 at 7:28
Midhun C NMidhun C N
155113
add a comment |
SQL server service account does not have permission to access the file.
- Navigate to the folder in which this file is residing
- Grant Full control privilege on this folder to the SQL server service account.
- Bring the DB Offline - Online or Restart SQL server services.
answered Sep 13 '16 at 7:28
Midhun C NMidhun C N
155113
add a comment |
SQL server service account does not have permission to access the file.
- Navigate to the folder in which this file is residing
- Grant Full control privilege on this folder to the SQL server service account.
- Bring the DB Offline - Online or Restart SQL server services.
answered Sep 13 '16 at 7:28
Midhun C NMidhun C N
155113
SQL server service account does not have permission to access the file.
- Navigate to the folder in which this file is residing
- Grant Full control privilege on this folder to the SQL server service account.
- Bring the DB Offline - Online or Restart SQL server services.
answered Sep 13 '16 at 7:28
Midhun C NMidhun C N
155113
answered Sep 13 '16 at 7:28
Midhun C NMidhun C N
155113
answered Sep 13 '16 at 7:28
Midhun C NMidhun C N
155113
answered Sep 13 '16 at 7:28
Midhun C NMidhun C N
155113
155113
add a comment |
add a comment |
I'm not an SQL internals expert, but I highly suspect that there will be nothing you can do to gently prompt SQL to re-check the files and continue database recovery where it left off; it will have abandoned the recovery effort when encountering that error.
As the other answer suggests, you'll have to either restart the SQL instance entirely, or take the database offline and back online to start recovery over.
answered 24 mins ago
BradCBradC
6,64263462
add a comment |
I'm not an SQL internals expert, but I highly suspect that there will be nothing you can do to gently prompt SQL to re-check the files and continue database recovery where it left off; it will have abandoned the recovery effort when encountering that error.
As the other answer suggests, you'll have to either restart the SQL instance entirely, or take the database offline and back online to start recovery over.
answered 24 mins ago
BradCBradC
6,64263462
add a comment |
I'm not an SQL internals expert, but I highly suspect that there will be nothing you can do to gently prompt SQL to re-check the files and continue database recovery where it left off; it will have abandoned the recovery effort when encountering that error.
As the other answer suggests, you'll have to either restart the SQL instance entirely, or take the database offline and back online to start recovery over.
answered 24 mins ago
BradCBradC
6,64263462
I'm not an SQL internals expert, but I highly suspect that there will be nothing you can do to gently prompt SQL to re-check the files and continue database recovery where it left off; it will have abandoned the recovery effort when encountering that error.
As the other answer suggests, you'll have to either restart the SQL instance entirely, or take the database offline and back online to start recovery over.
answered 24 mins ago
BradCBradC
6,64263462
answered 24 mins ago
BradCBradC
6,64263462
answered 24 mins ago
BradCBradC
6,64263462
answered 24 mins ago
BradCBradC
6,64263462
6,64263462
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%2f126419%2fvldb-is-stuck-in-recovery-state-its-a-permission-issue-now-what-should-i-do%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
This is an OS-level error. SQL Server cannot just decide to continue. You can't tell it to continue. You need to ensure OS-level permissions. Grand full control to Everyone to test this. Then revert to saner permissions.
– usr
Jan 17 '16 at 13:10
If the permissions are ok, then try doing DB OFFLINE and DB ONLINE.
– SQLPRODDBA
May 20 '16 at 7:51