Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-07-05 : 08:34:44
|
| my database went in suspect mode.now what can i do for this.after detaching and renaming the lig file and after attaching also giving |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-05 : 09:58:35
|
| Check the SQL error log. There should be some error messages there that state why the DB was marked suspect. Look for those and post them here.Do you have a backup of this database.p.s. you should never detach a suspect database as it usually won't reattach.--Gail ShawSQL Server MVP |
 |
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2009-07-05 : 10:05:52
|
| Msg 945, Level 14, State 2, Line 1Database 'ezEMRxClinical' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.hi that is the message iam having mdf and ldf files also but i cannot connect to this |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-05 : 12:15:03
|
| Ok. What does the SQL error log say? There should be more detailed messages in there.Specifically there should be messages about the specific files that are inaccessible and the details of the errors.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
database in suspect mode