transferring indexes from other db

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

transferring indexes from other db

Author

Topic

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2005-10-24 : 00:46:52

Hi all,

I have deleted few index from my db accidently.
Now i want to transfer those indexes from other backdb.
how i can do it?

Thanks

mk_garg

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-24 : 00:57:55

Hi,
restore that db backup with another name and then fire sp_helptext 'objectname' then it will return the text of the index , then re create in the db where you wants to recreate it.

this is the quickfix .

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2005-10-24 : 01:13:29

when i run sp_helptext

i am getting message there is not text.
I am using sql server 7.0

Thanks

mk_garg

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-24 : 01:25:27

Hi,

create script of that table name with all objects(index too) then run(index code) in QA , or open EM -> open your old db(withnewname) -> right click on table -> then you will find index code ther tooo.

HTH

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2005-10-24 : 02:24:14

Thanks

mk_garg

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-24 : 02:29:05

Hi,

you are welcome

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources