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 |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2004-08-12 : 16:29:37
|
| all of a sudden i see a database with suspect marked on it.why would that be and what should i do? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-12 : 16:36:54
|
| Usually caused by disk problems. Errors should be in the SQL Server Error log and/or in the App Log in Event Viewer. You need to fix the problems first.You can try sp_resetstatus if the initial problem is gone such as lack of free disk space on the driver where the MDF and LDF is located. Look it up BOL for details.Tara |
 |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-08-13 : 08:48:04
|
| before posting this, i had done what BOL had suggested and didnt work |
|
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-08-13 : 08:49:00
|
| there are a lot of database with mdf files on the same drive but different folders.None of the others are showing it as suspect |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-08-13 : 11:12:41
|
| Did you check the SQL Server Log? Why did it say the DB came up as suspect? |
|
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-08-13 : 11:38:09
|
| 1 udopen: Operating system error 5(Access is denied.) during the creation/opening of physical device D:\DBFILES\Manage\Data\MangeTest_Data.MDF.2 FCB::Open failed: Could not open device D:\ananths\Manageability\Data\MangeTest_Data.MDF for virtual device number (VDN) 1. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-13 : 11:57:30
|
| So is that a valid path and file?D:\ananths\Manageability\Data\MangeTest_Data.MDFTara |
|
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-08-13 : 13:55:45
|
| yes.i just detatched and reattached and everything is fine now.Dont know if i did the right thing though? |
|
|
|
|
|
|
suspect