June 21, 2013 at 4:30 pm
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.
----------------------------------
Sourcespid10s
Message
Error: 823, Severity: 24, State: 3.
June 22, 2013 at 10:45 am
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.
---------------------------------------------------------------------
June 24, 2013 at 11:08 am
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.
June 25, 2013 at 7:27 am
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.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply