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
691 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
205 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
2079 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

EsmondNorton
Starting Member

5 Posts

Posted - 11/07/2014 :  05:13:00  Show Profile  Reply with Quote
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.
Go to Top of Page

Shanky
Yak Posting Veteran

United Kingdom
84 Posts

Posted - 11/07/2014 :  11:48:05  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2079 Posts

Posted - 11/11/2014 :  01:43:55  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  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.08 seconds. Powered By: Snitz Forums 2000