Solved

SQLServer 2008

Posted on 2011-03-17
5
272 Views
Last Modified: 2012-05-11
Hello, I move a database from a SQL server 2005 to a SQL Server 2008 by doing a backup and restore.
I would like to know if the indexes must be rebuild on the database in the SQL Server 2008 and if so how do I do this.

Thanks
0
Comment
Question by:vera2006
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 4

Assisted Solution

by:LeDaouk
LeDaouk earned 200 total points
ID: 35155034
no you don't have to rebuild them
0
 
LVL 4

Assisted Solution

by:LeDaouk
LeDaouk earned 200 total points
ID: 35155044
also you can do it by de-attach database from sql 2005 and re-attach the database in sql 2008 it is fater if you have huge databases. but make bake to be on the safe side
0
 
LVL 4

Assisted Solution

by:qasim_md
qasim_md earned 100 total points
ID: 35155045
In case you want to rebuild indexes anytime the syntax is

dbcc dbreindex(table_name)
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 200 total points
ID: 35155049
No, indexes are in the backup. So after restore you'll retain indexes at the same state.
For reindexing you have DBCC DBREINDEX
http://msdn.microsoft.com/en-us/library/ms181671.aspx
0
 
LVL 14

Assisted Solution

by:Daniel_PL
Daniel_PL earned 200 total points
ID: 35155072
If you are interested I can recommend to you great scripts for reindex, statistics update and backup scripts from Ola Hallegren:
http://ola.hallengren.com/

Take care,
Daniel
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question