March 22, 2011 at 6:56 am
I have a SQL 2000 SP4 database, that is in dire need of some TLC. I am somewhat new to the DBA world and am not 100% sure of all the tasks that should be done and in what order. If everyone is wondering why this database has been neglected, not enough resources, economy, and from what I understand, this database was supposed to be migrated to 2005 a while back, but never got done for what ever reason (before my time with the company).
I have done some research and found Brad McGehee's presentation on using Ola's script, but this is only for rebuiling/reorganizing indexes, updating stats, etc, but these are all for SQL 2005 and above. I believe I need to do the following, but not sure of the best order and the best way to get this completed and there does not seem to be maintenance plans in SQL 2000.
Reorg/rebuild indexes
Defrag the database (or is this defrag the drive that the database files are on? or both?)
update statistics
Is there anything else I need to do? Thank you all so much for the help, it is greatly appreciated.
March 22, 2011 at 7:56 am
Ok, since I've posted this, I have found that they DBA before me did have jobs set up to check integrity, optimize the DB, re-index the tables, and update the statistics. They have all been running successfully.
I do have a question about using Windows to Defrag at the OS level...I checked to see how bad this disk was fragmented and the results were not very good. I am going to plan to defrag the drive that the database files is on. When I do this, does the SQL Server Service need to be stopped?
Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply