Moving indexes from one server to another

I moved my Sql Server Database from one sever to another ,Is there any way to
regenerate the indexes on the server we moved to without having to recreate
them?
TIA,
Vinny"Vinny Vinn" <VinnyVinn@.discussions.microsoft.com> wrote in message
news:67FC6662-F011-49DB-B623-A66CE2075F3A@.microsoft.com...
> I moved my Sql Server Database from one sever to another ,Is there any way
to
> regenerate the indexes on the server we moved to without having to
recreate
> them?
> TIA,
> Vinny
>
The indexes are objects stored in the database itself. When you moved the
database to the new server, the indexes should have come with you.
Rick Sawtell
MCT, MCSD, MCDBA|||Hi,
As soon as you Restore the database using RESTORE DATABASE or SP_ATTACH_DB
automatically data and all the objects will be restored.
Thanks
Hari
SQL Server MVP
"Vinny Vinn" <VinnyVinn@.discussions.microsoft.com> wrote in message
news:67FC6662-F011-49DB-B623-A66CE2075F3A@.microsoft.com...
>I moved my Sql Server Database from one sever to another ,Is there any way
>to
> regenerate the indexes on the server we moved to without having to
> recreate
> them?
> TIA,
> Vinny
>