Jeffrey - here's the output from one of the DBCC PAGE queries. Unfortunately I have no idea how to read this. Do you happen to see something that would identify...

Will try the page check option and see if that gets me any more info.

Regarding restoring from a previous backup - to clarify, I do have a working backup from...

Jeffrey - not sure exactly what you mean by review the storage system? We have regular maintenance being done on the server, is there something specific I should be telling...

Okay - differential is now working properly. I have no idea what the original problem was, but things seem to be resolved.

I do wonder whether I could have solved all...

Will let you know tonight when they run at their scheduled time. Hopefully yes 🙂

Hi again all,

Jeffrey your idea worked like a charm. Took a bit of finessing since I had about 270 transaction log backups to chain. Found a script online that let...

• This reply was modified 4 years, 1 month ago by  kramaswamy.
• This reply was modified 4 years, 1 month ago by  kramaswamy.

Hah - I hadn't thought of that. My normal backup routine involves clearing out the transaction log backups after the full backup is made, so I had just assumed I...

Okay - a few updates:

1. Running DBCC CheckDB on all the system databases resulted in no errors
2. No I/O problems are being reported. To note - the database is currently...

Hi all - thanks for the suggestions. Will try them out this evening and report back.

Another update. After thinking about this some more, I've realised that the problem boils down to taking a given node, and finding if the tree going upwards to the root...

After thinking it over, I've come up with one possible solution - though I'm certainly still open to others, as well as commentary on my proposed solution. Essentially what I'm...

Steve I'm not trying to criticize either you or Sean. I get your points, and I get that my explanation is not clear. But I'm just not sure how to...

I'm not still not totally following what you mean. Either way, the table name is being used:

June 21, 2018 at 11:40 am

#1994889