DATABASE Sanity check

Question

question

shamim007 asked Jan 9, '17

DATABASE Sanity check

HI GURUS , i have databases from 2010,2011,2012 .i restored them without error .how do i do sanity check? need scripts to run sanity check . thank you all in advanced

sql-server-2008 database-design

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Jan 09, 2017 at 07:01 PM

Can you define what a "sanity" check is to you?

2 ·

Answer 1 · 2017-01-10T09:54:56Z

David Wimbush answered Jan 10, '17

I think what you need is `dbcc checkdb` ( https://msdn.microsoft.com/query/dev14.query?appId=Dev14IDEF1&l=EN-US&k=k(dbcc_checkdb_TSQL);k(sql13.swb.tsqlresults.f1);k(sql13.swb.tsqlquery.f1);k(MiscellaneousFilesProject);k(DevLang-TSQL)&rd=true). This will do a pretty thorough check that you have an intact, consistent database after a restore: dbcc checkdb('YourDatabase') with all_errormsgs;

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton ♦♦ commented · Jan 10, 2017 at 03:49 PM

Better URL for DBCC CHECKDB: https://msdn.microsoft.com/en-us/library/ms176064.aspx

0 ·

Answer 2 · 2017-01-12T05:43:41Z

jason_clark03 answered Jan 12, '17

By using DBCC Checkdb command you may easily check this. Have a look on this blog of sqlservercentral explains how to run DBCC CHECKDB: http://www.sqlservercentral.com/blogs/zoras-sql-tips/2015/07/04/how-to-run-dbcc-checkdb-to-check-sql-database-integrity/

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2017-01-12T06:26:26Z

dumbdba answered Jan 12, '17

DBCC CHECKDB [YOUR DB NAME]

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question