How to rename the logical name of a database in SQL 2008?
The blow TSQL will rename the logical name of your databases
ALTER DATABASE [yourdatabses]
MODIFY FILE (NAME = 'oldlogicalname', NEWNAME = 'newloggicalname')
In the above example [yourdatabses] can be replaced with your databases name,’oldlogicalname' can be replaced with the existing logical name of your database and 'newloggicalname' name can be replaced with the new logical name for your databases.
Reference
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300
No comments:
Post a Comment