Email this to a friend
posted on March 8th 2011, at 10:24
by lunarg
It's possible to rename the logical names of MS-SQL databases through the SQL-prompt (osql.exe).

Log in to your database using osql:

> osql -S SERVERINSTANCE -d MyDB -U sa

First, query the current logical names; you will need them in order to rename them.

1> SELECT * FROM sysfiles2> GOfileid groupid size maxsize growth status perf name filename1 1 106224 -1 10 1048578 0 OldName_Data D:\SQL2000\Data\MyDB_Data.mdf2 0 128 -1 10 1048642 0 OldName_Log D:\SQL2000\Data\MyDB_Log.ldf

The name column specifies the logical names. Use the following SQL statement to rename them.

1> ALTER DATABASE [MyDB] MODIFY FILE (NAME = 'OldName_Data', NEWNAME = 'NewName_Data'  ...

Send a link to this post to yourself or a friend.

Send to e-mail:
Your name:
Your e-mail:
Type the letters and numbers as shown.
Not readable? Get another.
Information entered is solely used for sending a one-time e-mail, and is not retained and/or passed on to a third party.