Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

renameing a database

Status
Not open for further replies.
Jun 26, 2002
102
US
can you rename a database, i have a corrupt db and want to rename it so i can restore from tape, is it possible to rename a database to something else???
 
why dont u first restore it properly
take bcp out of all tables...
create a database with a new name
bcp in all the relevant tables
that u will have a stable database rather than an
unstable one

ali.reza@ushacomm.co.in

 
i used sp_renamedb and that worked, i didnt want to blow it away becasue we are giving it to sybas to evaluate
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top