Fcb Open Operating System Error 32
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums operating system error 32 the process cannot access the file Asked by: FCB::Open: Operating system error 32(The process cannot access operating system error 32 sql server the file because it is being used by another process.) occurred w SQL Server > sql server unable to open the physical file operating system error 32 SQL Server Database Engine Question 0 Sign in to vote Hello all,I am running into an interesting scenario on my desktop. I'm running developer edition on Windows XP Professional (9.00.3042.00 operating system error 32(failed to retrieve text for this error. reason 15105) SP2 Developer Edition). OS is autopatched via corporate policy and I saw some patches go in last week. This machine is also a hand-me-down so I don't have a clean install of the databases on the machine but I am local admin.So, starting last week after a forced remote
Cannot Open Backup Device Operating System Error 32
reboot (also a policy) I noticed a few of the databases didn't start back up. I chalked it up to the hard shutdown and went along my merry way. Friday however I know I shut my machine down nicely and this morning when I booted up, I was in the same state I was last Wenesday. 7 of the 18 databases on my machine came up withFCB:pen: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf'. Diagnose and correct the operating system error, and retry the operation.and it also logs FCB:pen failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).I've caught references to the auto close feature being a possible culprit, no dice as the databases in question are set to False. Recovery mode varies on the databases from Simple to Full. If I cycle the SQL Server service, whatever transient issue it was having with those files is gone. As much as I'd love to disable the virus scanner, network security would not be amused. The data and log files appear to have the same permissions as unaffected database files. Not
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting
Fcb::open Failed: Could Not Open File
ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is error 17204 severity 16 state 1 a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can process explorer download ask a question Anybody can answer The best answers are voted up and rise to the top Why is my database not available? up vote 3 down vote favorite 1 I have one database on my server that constantly becomes unavailable. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1a3df77b-9ce5-473a-8126-2e2b3fb73c2a/fcbopen-operating-system-error-32the-process-cannot-access-the-file-because-it-is-being-used-by?forum=sqldatabaseengine To fix, I take it offline, then back online. Looking at the event viewer there are three errors in quick succession: FCB::Open failed: Could not open file C:...\MyDatabase.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.). FCB::Open failed: Could not open file C:...\MyDatabase_1.ldf for file number 2. OS error: 32(The process cannot access the file because it is being used by another process.). A file activation error occurred. The physical file http://serverfault.com/questions/241257/why-is-my-database-not-available name 'C:...\MyDatabase_1.ldf' may be incorrect. Diagnose and correct additional errors, and retry the operation. Looking at the database properties, the log file path looks correct. I'm not really a DBA but play one out of necessity. What else should I be looking for here? (SQL Server 2008 Express SP1) sql-server sql-server-2008 database-administration share|improve this question asked Feb 28 '11 at 17:53 Michael Itzoe 17549 1 Looks like you have an antivirus that is locking the file. Add an exclusion. –user3914 Feb 28 '11 at 18:07 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted As Randolph said, you likely have an AV process holding onto the files in question. To confirm this, get Process Explorer or handle.exe (or both!) from the Sysinternals at Microsoft. Learn and love all of of their tools. If it's not AV, but something else that has those files locked, then fix whatever it is. Also, as an aside, you don't want data or log files on your system volume (typically the C:\ drive). If they fill the disk, you've taken your server down. You probably want them on a different volume. Caveat - with SQL Express, your max DB size may be lower than the amount of free space you'll ever have on the disk, but do you want to count on that always being true? share|improve this answer answered Feb 28 '11 at 18:38 mfinni 31.2k33474 1 SQL Server itself was locki
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home http://www.sqlservercentral.com/Forums/Topic1247182-391-1.aspx » SQL Server 2008 » SQL Server 2008 - General » http://www.bigresource.com/MS_SQL-FCB-Open-Operating-system-error-32-The-process-cannot-access-the-file-because-it-is-being-used-by-another-process-occurred-w-78xM2dkJ.html FCB::Open Failed Error FCB::Open Failed Error Rate Topic Display Mode Topic Options Author Message DuranDuran Posted Monday, February 6, 2012 3:46 AM Mr or Mrs. 500 Group: General Forum Members Last Login: Wednesday, September 28, 2016 5:43 PM Points: 532, Visits: 1,685 Hello, I hope someone can help operating system me out of a spot.We had some maintenance done on our building at the weekend and everything was powered down. Looking at the logs I now have trouble with a number of errors, this only applies to some of the user databases in the instance, not all of them.FCB::Open Failed: Could not open file E:\Data\Databasename.MDF for file number 1. OS operating system error error: 5(failed to retrieve text for this error. Reason 15100.Error: 17204, Severity: 16. State 1.Then further on...FileMGR::StartLogFiles: Operating system error 2(failed to retrieve text for this error. Reason: 15105)occured while creating or opening file F:\Logs\DatabaseName.LDF'. Diagnose and correct the operating system error, and retry the operation.Error: 17207, Severity: 16, State: 1.I have SQL 2008 R2 RTM on Windows 2008 R2.I have found similar errors online, but none that match mine exactly, some of the databases are functioning ok, I have not tried restarting the services yet, I can see the databases in SSMS, but of course I can not access any properties. Any help most appreciated.Kind Regards,D. Post #1247182 John Mitchell-245523John Mitchell-245523 Posted Monday, February 6, 2012 3:57 AM SSCertifiable Group: General Forum Members Last Login: Yesterday @ 9:53 AM Points: 6,902, Visits: 14,350 OS error 5 means access denied, while OS error 2 means the file could not be found. Looks like permissions have been changed in one place and elsewhere, one of your files has been moved or deleted.John Post #1247185 DuranDuran Posted Monday, February
on my desktop. I'm running developer edition on Windows XP Professional (9.00.3042.00 SP2 Developer Edition). OS is autopatched via corporate policy and I saw some patches go in last week. This machine is also a hand-me-down so I don't have a clean install of the databases on the machine but I am local admin. So, starting last week after a forced remote reboot (also a policy) I noticed a few of the databases didn't start back up. I chalked it up to the hard shutdown and went along my merry way. Friday however I know I shut my machine down nicely and this morning when I booted up, I was in the same state I was last Wenesday. 7 of the 18 databases on my machine came up with FCB:pen: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf'. Diagnose and correct the operating system error, and retry the operation. and it also logs FCB:pen failed: Could not open file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.). I've caught references to the auto close feature being a possible culprit, no dice as the databases in question are set to False. Recovery mode varies on the databases from Simple to Full. If I cycle the SQL Server service, whatever transient issue it was having with those files is gone. As much as I'd love to disable the virus scanner, network security would not be amused. The data and log files appear to have the same permissions as unaffected database files. Nothing's set to read only or archive as I've caught on other forums as possible gremlins. I have sufficient disk space and the databases are set for unrestricted growth. Any thoughts on what I could look at? If it was everything coming up in RECOVERY_PENDING it's make more