January 23, 2002 at 12:12 pm
I want to rename a database on a single server. Three approaches come to mind:
1. Use sp_renamedb
2. Use the more involved approach described in "How to restore a database with a new name (Transact-SQL)" in Books Online.
3. Backup the original database, create a new database with the desired name, and restore the backup to tha new database.
Is there anything wrong with option 1? I'll go with simplicity whenever I can.
TIA,
Bill
January 23, 2002 at 12:16 pm
January 24, 2002 at 4:53 am
Take a look at the code in sp_renamedb - nothing too involved going on really, I'd go that way also.
Andy
January 24, 2002 at 4:53 am
I think the restore with different name is mostly useful for making a copy of a db.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply