Is there any way to identify the object name (table/index etc) that a suspect page entry has flagged up given the file_id and page_id in sys.suspect_pages?
The database (TBytes in size) has flagged a couple of torn pages after a iScsi SAN unit had a minor hardware failure due to a badly written driver version (the third party company has now fixed it).
Due to the database size and 24/7 up time the usual procedures for recovery are not possible so a manual look is needed at the tables/indexes damaged to draw up a plan for fixing the issues.
Thanks in advance guys.