Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Best practices: If I backup a DB and restore the DB on..
- Thread starter SteveMe
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
In either case there is no need to re-index the database just because you restored it.
When you restore the database the indexes from the other server are brought accross. As soon as you start accessing the tables and indexes the data will be loaded into memory as needed.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
When you restore the database the indexes from the other server are brought accross. As soon as you start accessing the tables and indexes the data will be loaded into memory as needed.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question