Moving indexes from one server to another

I moved my Sql Server Database from one sever to another ,Is there any way t
o
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
>