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


CHKDSK on a SAN Volume


CHKDSK on a SAN Volume

Author
Message
rothj
rothj
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1691 Visits: 3763
I need a little direction.
I have a clustered SQL db (Sql 2000 / Win2k).
I have errors in the log for corruption on drive S:\.
This is my backup volume (data and tx logs are on separate vols).
I attempted to run chkdsk but it said it needed to dismount because another process had it in use.
Can I dismount this without taking SQL server down or do I need to stop the SQL server? Just trying to determine if I need to sched a downtime. Thank you.

I was thinking if I shut down SQL Server Agent...nothing would try to use Drive S:\. There are tx log backups happening every 15 mins. ??
Thanks for helping the rookie. Hehe
rothj
rothj
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1691 Visits: 3763
Ok, I've pretty much determined I have to set CHKDSK to run at reboot to get exclusive access. Anyone know how long CHKDSK will take (approx) on a 700 GB volume?
Thanks again
Mohit K. Gupta
Mohit K. Gupta
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4838 Visits: 1089
A long time; the Disk management guys at work told me it is usually a good idea to keep disks in chucks of 250GB .. easier to manage and scan and such.

Thanks.

---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. Smooooth


How to ask for help .. Read Best Practices here.
Paul Randal
Paul Randal
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12666 Visits: 1721
Also consider that if you let chkdsk do any repairs, and it touches anything in the database files, it will most-likely result in database corruption.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
rothj
rothj
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1691 Visits: 3763
YIKES!
Luckily, it is just a volume where backups are stored.
I'll likely move a copy of the backups to another volume and on tape.
I'll verify there is nothing else on this Volume other than backups.
Thanks guys!
NMHDBA
NMHDBA
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 12
I know that this topic is a bit old, but I have a very similar question.

Every two weeks we perform server/database maintenance; altering indexes, Windows updates and a server reboot. My issue periodically appears between maintenance weeks with a System error Event ID 55 in the event viewer: "The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume XDATA."

This volume is on our SAN and I've determined that I need to perform a CHKDSK since the volume is marked as dirty.

I understand the differences between CHKDSK /F & CHKDSK /R. My question is since I'm not performing a CHKDSK /R should I be worried about database files on this volume if I perform a CHKDSK /F?
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (339K reputation)SSC Guru (339K reputation)SSC Guru (339K reputation)SSC Guru (339K reputation)SSC Guru (339K reputation)SSC Guru (339K reputation)SSC Guru (339K reputation)SSC Guru (339K reputation)

Group: General Forum Members
Points: 339620 Visits: 42623
NMHDBA (12/13/2012)
I know that this topic is a bit old, but I have a very similar question.

Every two weeks we perform server/database maintenance; altering indexes, Windows updates and a server reboot. My issue periodically appears between maintenance weeks with a System error Event ID 55 in the event viewer: "The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume XDATA."

This volume is on our SAN and I've determined that I need to perform a CHKDSK since the volume is marked as dirty.

I understand the differences between CHKDSK /F & CHKDSK /R. My question is since I'm not performing a CHKDSK /R should I be worried about database files on this volume if I perform a CHKDSK /F?


Call the SAN vendor and tell them to come fix it or replace it! That kind of corruption should only happen about once every hudred years or so on a SAN.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
NMHDBA
NMHDBA
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 12
I've talked with the administrator of the SAN and I have asked if there was anything that needed to be done. Although he mentioned that he could update drivers and test various items, he strongly suggested that my issue is with the volume on the SAN and that this would be a job for CHKDSK. He cited that many systems are hosted by the SAN and that they are not experience issues.

I'm not as knowledgeable about the SAN as this person, so I'm not sure what to ask if he insists that I should try a CHKDSK first. What would be your suggestion?
Satish Nagaraja
Satish Nagaraja
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1032 Visits: 308
Best thing is build standy by server on same domain, migrate the databases and check for consistency after migration, usually you should have DR solution for critical production databases for covering these kind of issues.

Run checkdsk on original server.

Cheer Satish :-)
NMHDBA
NMHDBA
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 12
Thank you for your reply. This production database performs a FULL back up daily and is restored daily to a separate reporting server. The integrity of the database is OK. I'm confident that this is strictly a issue with my SAN volume.
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