December 21, 2009 at 12:36 pm
Presently we are taking daily full backups, diff backups for every 6 hours, tlog backup for every 10 min.
Sofar no issues with SQL Server 2005
As per basic maintenance tasks,...i am planning to setup CHECKDB, REbuild index, Re-organize, Updatestats.
Please guide me on order of these tasks and shcedule time too. Thank you
December 21, 2009 at 4:09 pm
If you rebuild your indexes, you don't need to re-organize them. Also, there is no need to update statistics on index statistics after a rebuild. However, if you reorganize your indexes the statistics are not updated and you need to perform that operation.
I would review the scripts on this site - and also look at SQL Fool's script for re-indexing.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 22, 2009 at 6:14 am
Also it's depends on the size of the Database too. If the database is too large than re-orgeanize will be helpful so that there will not be any blocking etc. Also if you are using SQL 2005 Enterprise Edition you can reindex online. And maintenance should be scheduled when there will be minimal activities on the server.
Script on this site might also help you to achieve your goal.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 22, 2009 at 8:18 am
Hi,
Read and use the De-fragmentation script added in my signature.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply