SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Check DB integrity maintainence task
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rajsin
Starting Member

United Kingdom
4 Posts

Posted - 04/03/2014 :  06:56:35  Show Profile  Reply with Quote
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

USA
36599 Posts

Posted - 04/03/2014 :  12:42:37  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
192 Posts

Posted - 04/04/2014 :  01:31:27  Show Profile  Visit prett's Homepage  Reply with Quote
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

USA
36599 Posts

Posted - 04/04/2014 :  16:29:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

United Kingdom
4 Posts

Posted - 04/10/2014 :  04:41:31  Show Profile  Reply with Quote
thank you tkizer and prett this is very helpful

rajsin
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000