This blog is used for logging strange problems that I encounter and how I have or have not solve the problem. Since I program in .NET, the blog are mostly .NET related. I hope this blog would help people out if they encountered the same issue that I went though.
May 14, 2011
Never Upgrade Database Schema When Disk Drive is Defragmented
My company's Data Warehouse development has finally completed for this release. The architecture team is now at the client site and deploying the Data Warehouse solution. We had estimated we will only take 4 hrs to upgrade the Live Database. We will be performing the first ETL offline. Unfortunately we failed the upgrade last time, not because of incorrect script or any technical error. it is because of the following: Instead of taking 4 hrs to do the database upgrade, we have to bail out after 6 hrs of waiting for the upgrade script to complete. Next time, check the hard drive fragmentation first before doing any database upgrade!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment