Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The operating system returned error 5(Access is denied.) message in sql error log Expand / Collapse
Author
Message
Posted Friday, June 21, 2013 4:30 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 1:47 PM
Points: 52, Visits: 276
Can somebody explain what this error message means? I currently brought a customer .bak file over restored it fine. But when I try and back it up or restore it I get below messages. I also try and run an in house unit test application against this db and I get the same errors. But, when I run a simple select statement against the db in management studio it returns fine, but I get the below error message as well. Any help is much appreciated. Thanks.

----------------------------------
The operating system returned error 5(Access is denied.) to SQL Server during a write at offset 0x0000027f7f6000 in file 'D:\MAJIQ\Elixir\MSSQL_2005_Data\snnb_5_4_data.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
----------------------------------
Source spid10s

Message
Error: 823, Severity: 24, State: 3.
Post #1466421
Posted Saturday, June 22, 2013 10:45 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 5,849, Visits: 12,584
either that .bak file you bought over had a corruption in it or you have an underlying system problem (disk or driver)

Have you run the dbcc checkdb? thats the first thing to do.

Look for any other errors in the server event logs.


---------------------------------------------------------------------

Post #1466473
Posted Monday, June 24, 2013 11:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 1:47 PM
Points: 52, Visits: 276
Thanks George, I ran dbcc checkdb turned out fine. Funny thing though is it forced me to turn the db into single user mode which I thought was odd because usually the db doesn't need to be in single user mode. The server event log only shows the same error message we get in sql server error log. We dropped all users on db and recreated them and now the back up works fine. Weird stuff. I'm leaning towards an OS/ drive or driver issue? Appreciate the help.
Post #1466843
Posted Tuesday, June 25, 2013 7:27 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 5,849, Visits: 12,584
the error could be transient or sporadic. definitely get the disks checked and make sure all drivers up to date.

Very odd dropping and recreating users should apparently resolve this, makes no sense. I have not seen this error linked to OS error 5 (permissions) before either.

Can you restore the backup to a different server and see if the problem is replicated.


---------------------------------------------------------------------

Post #1467138
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse