Restore and data and index reorg

Hi
A friend asked me if SQL Server 2000 restore reorganizes data and indexes. I
don't believe it does. What do you think?
Regards,
AndrsNo it doesn't. It pretty much just copies the pages as they are from
the backup media to the physical database files. If he wants to
reorganise or rebuild indexes he'll need to use DBCC INDEXDEFRAG or
DBCC DBREINDEX respectively (or copy the data in afresh using bcp, DTS,
etc. if he wants to do it the hard way).
*mike hodgson*
http://sqlnerd.blogspot.com
AFG wrote:

> Hi
> A friend asked me if SQL Server 2000 restore reorganizes data and
> indexes. I don't believe it does. What do you think?
> Regards,
> Andrs