• subscribe
August 30, 2004 12:00 AM

Troubleshooter: Using Eseutil Switches to Verify Database Integrity

Windows IT Pro
InstantDoc ID #43616

What Eseutil switch should I use to verify the integrity of a database?

That depends on exactly what you want to verify. The /g switch (which the Eseutil documentation refers to as integrity check mode) scans the database header for consistency and performs some other basic checks. The /k switch (which the Eseutil documentation calls checksum mode) walks the database and computes the checksum for each page, comparing that checksum with the stored value. The latter check occurs automatically during an online backup but doesn't happen during a Microsoft Volume Shadow Copy Service (VSS) backup. To verify the quality of a VSS snapshot, use Eseutil's /k switch.



ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...