August 6, 2017 at 11:26 pm
Hello all,
I ran a flashcopy on Friday and everything went fine. The users ended up having an issue and needed the test database refreshed again. Re-ran the flashcopy process and now I am getting an Error 824, SEV 24 about a logical consistency-based error. The next 2 errors are 3313 and 3314. This is for a single database that is over 1TB in size so any recommendations? Not sure if there is a backup of Test from Friday to attempt a restore ( I don't manage backups a different group does). All other databases are fine and are located in the same directory as the suspect database.
The Flashcopy is supposed to be a clone of the production system, ran a checkdb on production and it came back with no errors. So my guess is it may be an issue with the drive the file is on but wondering if there are any other items to look at or possibly try.
Thank you,
August 7, 2017 at 6:55 am
You will need to run CHECKDB on the restored database on the TEST environment. First indications would point to some sort of corruption. I will look for any I/O related problems that in that environment while the Checkdb is running.
If the file or drive is missing from my memory of a couple years back I would get 823 maybe 824. I'm going back 5 years here when I last had this issue.
August 7, 2017 at 2:36 pm
Usually it's hardware related. I would check through the Windows event logs. You may want to refer to this for other troubleshooting you can do:
How to troubleshoot Msg 824 in SQL Server
Sue
August 8, 2017 at 5:36 am
Well I ran a chkdsk on the target volume and there was corruption in the bitmap of drive. I fix the corruption, re-run the flashcopy process and the corruption returns. The source volume is fine, no corruption so the only thing I can think of is the flashcopy process is causing the corruption. Will contact the vendor support for the SAN to determine if there is anyway around this besides running a restore from a SQL backup, as that would take a few days due to the size of the DB.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply