lin2world(suspect) - no items found

[Calynx]

I had this problem just earlier and it started with my L2NPC crashing then my L2server crashing and then the CacheD crashed.

Does anyone know how to recover from a (suspect) database? This is starting to be a really large problem for me, if anyone could help that would be great.

[MentaL]

[~Nyx~]

I had the same thing happen, theres ways to try to restore the db, but for me they didnt work. Your best bet is to restore a backup, I make a backup every hour after learning the hard way

[kev]

u moved the database ? i only get that error when sql cant find the db files

[Calynx]

I haven't moved the database at all, I'm wondering are there ways to detach and restore the database?

Nyx how do you make backup databases with yours?

would you recommend using bypass mode or emergancy mode?

[~Nyx~]

I could only get access to it in emergency mode

and this happened to me when system reset with server running

(I set backing up DB's as a job in Enterprise Manager, and set it for every hour)

[Calynx]

I found out the problem, and it was traced to the user_items, says something about a duplicate item.

Does anyone know about this? Hmmmmm....

[kev]

I haven't moved the database at all, I'm wondering are there ways to detach and restore the database?

Nyx how do you make backup databases with yours?

would you recommend using bypass mode or emergancy mode?

well u did something cas that means that sql cant find the db's