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 |
|
rajsin
Starting Member
4 Posts |
 Posted - 2014-04-03 : 06:56:35
|
| dear friends,i have a database which is 500GB in size. there has never been a integrity check done on this DB till date. this is a production DB. could you let me know if it is a good practice to run a DB integrity check? any pre requisites i must know before scheduling the maintenance task?its sql server 2008 standard edition, 8CPU, 24GB RAM.thanks a lotrajsin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-04-03 : 12:42:37
|
| The best practice is to do the checkdb on a test system. Copy the prod backup to a test server, restore it and run checkdb there. This should be automated. Many people don't have the storage or servers to automate this, but this is the only way to protect production. Checkdb is a very IO intensive task. If your system is 24x7 like mine, it will be noticed when checkdb is running unless you have very fast disks. Our SAN admins can pinpoint exactly when all of our checkdb jobs run. We do have some of them automated for the backup/restore, but we have too many databases to do that for all of them.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2014-04-04 : 01:31:27
|
| In addition to the tkizer suggestion,It is a good practice to run this process table by table as time permits for the extremely large database like yours. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-04-04 : 16:29:19
|
| Extremely large? 500GB would me a large database. Get into the terabytes and then you can call it a VLDB (very large database size. I'd reserve "extremely" for 10s of terabytes such as 50TB.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
rajsin
Starting Member
4 Posts |
Posted - 2014-04-10 : 04:41:31
|
| thank you tkizer and prett this is very helpfulrajsin |
|
|
|
|
|
|
Check DB integrity maintainence task