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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-02-28 : 00:26:58
|
| What all are the command , or what for should one look out to confirm if nothing is wrong with the DB & its the application that is creating a prob..I mean command for checking the health of the DB.Thanks, |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-28 : 05:49:22
|
| dbcc checkdb() |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-28 : 13:41:42
|
| DBCC CHECKDB will check for database corruption. That's a very important step in determing the health of the database. There are other things that can be done, but we'll need to know what you are after in order to help you further.Tara Kizeraka tduggan |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-02-28 : 22:30:05
|
| Tara,I need to knw some of the regular things , basic is what i mean that needs to be checked , for eg. dbcc checkdb what else is there ???????Thanks |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-01 : 01:55:18
|
| kid, be specific. There could be a million things.It wouldn't be very helpful for me to suggest you check that the power is connected to your server, so be more specific with your question. -ec |
|
|
|
|
|
|
Database health