MS SQL 2000 Backup. where r my Indexes?

[R Camarda]

I used Enterpise manager to make a backup of a SQL Database. When I
restored it on another machine, I did not have any of my indexes. I
checked the backup wizard and I could not find any reference to
including or not indexes.
Are my indexes there, but not built? Maybe a stored procedure I need
to run to rebuild them?
TIA
Rob

[Greg D. Moore \(Strider\)]

"R Camarda" <rc******@cablespeed.com> wrote in message
news:d7**************************@posting.google.c om...

I used Enterpise manager to make a backup of a SQL Database. When I
restored it on another machine, I did not have any of my indexes. I
checked the backup wizard and I could not find any reference to
including or not indexes.
Are my indexes there, but not built? Maybe a stored procedure I need
to run to rebuild them?
This is very weird.

I'd try to do a backup and restore using query analyzer just to confirm
everything.

A restore should be an intact copy of the database.
TIA
Rob

[Dan Guzman]

A restored database is exactly like the original, although file locations
may be changed during the restore. You might check your backup file to see
if it contains multiple backup sets. By default, the first (oldest) backup
is restored and perhaps that version didn't have your indexes.

You can list the contents of your backup with RESTORE HEADERONLY. For
example:

RESTORE HEADERONLY FROM
DISK='C:\Backups\MyDatabase.bak'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R Camarda" <rc******@cablespeed.com> wrote in message
news:d7**************************@posting.google.c om...

I used Enterpise manager to make a backup of a SQL Database. When I
restored it on another machine, I did not have any of my indexes. I
checked the backup wizard and I could not find any reference to
including or not indexes.
Are my indexes there, but not built? Maybe a stored procedure I need
to run to rebuild them?
TIA
Rob