|
|
Posted by Erland Sommarskog on 08/09/06 22:21
Ryan (ryanofford@hotmail.com) writes:
> I'm trying to restore about 70 databases onto a new SQL server and
> wanted to script the creation and restore. I've done the creation with
> no problems, but on the restore, the logical names (of the original
> data) are all over the place and were historically wrong.
If I understand this correctly, you first run CREATE DATABASE for a
database, and then RESTORE for the same database for you. I've bad news
for you: the script for CREATE DATABASE was in vein. RESTORE will create
the database if it does not exist. And if it exists, it will throw the
old one away.
> So, even though I've been neat creating the database, it gets
> overwritten with the odl rubbish name. How can I change the logical
> name so that I can have a nice and neat naming convention ?
ALTER DATBASE db MODIFY FILE oldname NAME = oldname, NEWNAME = newname
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|