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.