SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Recovery of database


Recovery of database

Author
Message
ramyours2003
ramyours2003
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11585 Visits: 3409
How can we check the corruption of database with out running dbcc check db
NorthernSoul
NorthernSoul
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6467 Visits: 9746
You could try and restore it and see if it fails.
Why don't you want to run DBCC CHECKDB? it is the best way of checking for corruption.

Thanks
Lincoln Burrows
Lincoln Burrows
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18545 Visits: 2671
DBCC CHECKDB command is the main command to detect the inconsistency in the database. It is an amalgamation of other DBCC CHECKDB command, CHECK CATALOG, CHECKALLOC and DBCC CHECKTABLE. Running CHECKDB includes all these commands so you don't need to run these commands separately. If the corruption is in indexes then you need to run other DBCC CHECKDB undocumented command ie DBCC INDID. The root of finding the database corruption is DBCC CHECKDB only.
Go through this link:
https://www.red-gate.com/simple-talk/sql/database-administration/finding-data-corruption/
GilaMonster
GilaMonster
SSC Guru
SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)

Group: General Forum Members
Points: 992604 Visits: 48920
You don't. Run CheckDB.



NorthernSoul - Thursday, October 11, 2018 6:43 AM
You could try and restore it and see if it fails.


Nah, I've seen enough corrupt DBs restore fine (with corruption in them)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Thom A
Thom A
SSC Guru
SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)

Group: General Forum Members
Points: 96235 Visits: 23412
GilaMonster - Monday, October 15, 2018 1:25 AM
You don't. Run CheckDB.
NorthernSoul - Thursday, October 11, 2018 6:43 AM
You could try and restore it and see if it fails.
Nah, I've seen enough corrupt DBs restore fine (with corruption in them)

Never truer words have been said. You can even download some sample backups of corrupted databases here: https://www.sqlskills.com/sql-server-resources/sql-server-demos/

If a database is corrupted that doesn't mean it can't still successfully be backed up and restored; and if it is (corrupted) then the corruption will be in both the backup and the restored database.



Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
Alejandro Santana
Alejandro Santana
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1230 Visits: 1200
I have seen people having software that integrates with the SAN for taking database snapshots/backups at the block level, should the user still run checkdb at the main database or is it enough to run checkdb from the snapshot/database restore with the software?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)SSC Guru (992K reputation)

Group: General Forum Members
Points: 992604 Visits: 48920
Depends on how that snapshot is taken. Is it a block-by-block copy it's fine to checkDB.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search