Hacker News new | ask | show | jobs
by letstryagain 4238 days ago
A) Indexes do not just disappear. Someone dropped them or restored an older version of the DB.

B) What? That's not SQL Server's fault, it's either a broken third party package or the display settings on your UI chopped the data to fit on a screen or something.

C) Never heard about this. I even tried to google it but I can't find any information about this. Do you have a source?

D) Third party tool problem probably. Not SQL Server's fault. Did the BAK file restore normally using SQL Server?

1 comments

I wrote the "third party tool" actually. It was tested thoroughly but on the few records with non-ASCII characters, the data came out weird. It was only about 10 or so records so I just manually corrected it. (I don't recommend this approach, it was a "we're under the gun, just change history and don't fret" decision)