Search found 2 matches

by bruce.milne
Wed Jul 20, 2016 10:22 am
Forum: Memory Forum
Topic: SQL database in status SUSPECT
Replies: 3
Views: 14986

Re: SQL database in status SUSPECT

Also have a look this Recommended actions
http://www.techrepublic.com/forums/disc ... corrupted/
by bruce.milne
Wed Jul 20, 2016 10:11 am
Forum: Memory Forum
Topic: SQL database in status SUSPECT
Replies: 3
Views: 14986

Re: SQL database in status SUSPECT

If your database is marked suspect and you are desperate, then I'll advice you to set the status to that database, like: update master.dbo.sysdatabases set status = 20 where name = 'YourDatabaseName' Very sorry that you have no backup. So if that doesn't help, then the only thing I can advise is to ...