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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy