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 (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

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

Group: General Forum Members
Points: 5461 Visits: 8666
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 (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16701 Visits: 2103
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 (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)

Group: General Forum Members
Points: 902660 Visits: 48733
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 (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)

Group: General Forum Members
Points: 82084 Visits: 21014
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
SSC Eights!
SSC Eights! (873 reputation)SSC Eights! (873 reputation)SSC Eights! (873 reputation)SSC Eights! (873 reputation)SSC Eights! (873 reputation)SSC Eights! (873 reputation)SSC Eights! (873 reputation)SSC Eights! (873 reputation)

Group: General Forum Members
Points: 873 Visits: 1075
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 (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)SSC Guru (902K reputation)

Group: General Forum Members
Points: 902660 Visits: 48733
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