sql server suspect
Posted on 2000-02-24
after reboot server , a database in sql server 6.5 suspect. we try to turn it to emergency mode to made it available again . But we still can't access the database.
And in the event log ,error logged as follow:
The description for Event ID ( 17060 ) in Source ( MSSQLServer ) could
not be found. It contains the following insertion string(s): Error : 605,
Severity: 21, State: 1, Attempt to fetch logical page 1160 in database
'RERS_WS' belongs to object '1490104349', not to object 'ItemCategory'..
Any method to repair the database so we can access it again?
As I known , we can use 'bcp' program to
copy out the data from the database ,
how to use this command?