Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Rebuild Indexs in Backup Strategy?

Author  Topic 

viperbyte
Posting Yak Master

132 Posts

Posted - 2012-12-09 : 18:18:43
Is rebuilding indexs in a backup maintenance plan adviseable?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-09 : 20:09:17
Instead of rebuilding indexes I would check for fragmentation of indexes and then rebuild or reorganize.Check for Tara's script.
Go to Top of Page

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2012-12-17 : 07:45:06
you need to monitor the index usage and then decide which indexes to be rebuilt.
rebuilding unused indexes will be a overhead.
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2012-12-27 : 05:10:16
Please check this link: http://justgeeks.blogspot.in/2012/07/sql-server-maintenance-plan-best.html

The topic covers all useful steps for 'SQL Server Maintenance Plan'.
Go to Top of Page

lopez
Starting Member

8 Posts

Posted - 2013-01-03 : 07:39:59
For increase your server performance it is advisable but you need to distinguish between rebuilding the index & reorganising the indexes
refer the following discussion

http://www.sqlservercentral.com/Forums/Topic1400334-1550-1.aspx?Update=1
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-01-03 : 08:29:12
Following on from ahmeds08 - consider implementing a regular review of index usage - which is all basic information available via DMVs. During these reviews - work ith the app owners to discuss and analyse indexes that have have large amount of writes with very little or no reads. Usually a hint that that the index is added to but then not read. Of course, make sure there is a good understanding of the queries - before you start dropping indexes.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

EsmondNorton
Starting Member

5 Posts

Posted - 2014-11-07 : 05:13:00
Check these site: http://www.sql.recoverytoolbox.com/ & download demo Recovery Toolbox for SQL Server.
Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.[url][/url]
Go to Top of Page

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-11-07 : 11:48:05
I dont see any benefit in including Index rebuild in backup plan. MP behaves little erratically when multiple steps are there. I would like you to create separate plan because backup is MUST task for every day while same is not the case with index rebuild. Only rebuild when index is fragmented and having sufficient page count

Hope this helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-11-11 : 01:43:55
In a busy production environment - where there can be a requirement for a 24 x 7 requirement on database servers - the backup window can be narrow. Adding index rebuilds increases the window.
Index management is a priority but is more flexible if you can break the tasks down

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -