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 |
cddot
Starting Member
37 Posts |
Posted - 2009-02-16 : 20:09:16
|
SQLServer 2005.Is setting up a Check Database Integrity Task 1) recommended? 2) optional/depends?3) not required?Having heard some "things", but having no direct experience at all, your general feedback/comments are appreciated. |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-16 : 20:10:25
|
It is required. We do it every day through jobs.It is important to check health of databases. |
|
|
cddot
Starting Member
37 Posts |
Posted - 2009-02-16 : 20:20:02
|
What does "health" mean?If the DB is not "healthy", does it mean1) not efficient? 2) corrupted? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-16 : 23:42:01
|
quote: Originally posted by cddot What does "health" mean?If the DB is not "healthy", does it mean1) not efficient? 2) corrupted?
Means it has failed in structural integrity of database(tables,index,data-pages). |
|
|
|
|
|