Ask the Expert

Unknown cause of SQL Server 2000 corruption

We have a non-default instance of SQL Server 2000 running on Windows Server 2003. In the past few months we have experienced a number of database corruptions. We managed to restore data from backups and Microsoft Support attempted to diagnose the corruptions without a successful conclusion. We now think the corruptions could have been caused by one of two things: It could be that the 2003 automated disk defragmenter was running against disks containing SQL Server database files and transaction logs while the SQL Server application processes and backups were running. Or, a third-party backup utility (Tivoli Storage Manager) attempted to back up the disks containing the database files and transaction logs again while the application processes and other SQL Server backups were running. Are either of these likely causes for corruption and would you advise on a complete reinstall of the SQL Server instance?

    Requires Free Membership to View

It is entirely possible that any combination of these items could have caused corruption. Without additional information I could not give you a definitive answer. I would research the individual items further and contact the vendors to find out the implications of using the applications with SQL Server. I have had corruption experience with another client and the bottom line came down to hardware issues. From working with SQL Server in the past, I would say hardware can be a common issue. With that being said, I would ensure your hardware, operating system, SQL Server and server-based applications have no issues. As far as a reinstallation is concerned, I would say based on the information that it would not be necessary as long as the SQL Server executables are not corrupted or your system databases are not corrupted. I would be more concerned about ensuring your databases are free of corruption. If you are unable to resolve the corruption then I would consider building a skeletal database and importing the data and objects into a fresh database. Good luck!


Do you have comments on this Ask the Expert Q&A? Let us know.

This was first published in September 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: