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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Check DB integrity maintainence task

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 lot


rajsin

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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.

Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

rajsin
Starting Member

4 Posts

Posted - 2014-04-10 : 04:41:31
thank you tkizer and prett this is very helpful

rajsin
Go to Top of Page
   

- Advertisement -