SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Rebuild Indexs in Backup Strategy?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

viperbyte
Posting Yak Master

USA
132 Posts

Posted - 12/09/2012 :  18:18:43  Show Profile  Reply with Quote
Is rebuilding indexs in a backup maintenance plan adviseable?

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 12/09/2012 :  20:09:17  Show Profile  Reply with Quote
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

India
620 Posts

Posted - 12/17/2012 :  07:45:06  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
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

USA
195 Posts

Posted - 12/27/2012 :  05:10:16  Show Profile  Visit prett's Homepage  Reply with Quote
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

USA
8 Posts

Posted - 01/03/2013 :  07:39:59  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2019 Posts

Posted - 01/03/2013 :  08:29:12  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000