[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

SQLServer 2008

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
vera2006
Asked:
vera2006
  • 2
  • 2
5 Solutions
 
LeDaoukCommented:
no you don't have to rebuild them
0
 
LeDaoukCommented:
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
 
qasim_mdCommented:
In case you want to rebuild indexes anytime the syntax is

dbcc dbreindex(table_name)
0
 
Daniel_PLDB Expert/ArchitectCommented:
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
 
Daniel_PLDB Expert/ArchitectCommented:
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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now