Logical Data File Names

It is a good practice to have logical data file names that make sense.  Often a non-production database gets ‘promoted’ as is to production.  So what you end up with is logical names that contain ‘dev’ in production.  I don’t know of a way to alter the logical name via SSMS there is an alter database command that does the trick.

ALTER DATABASE <DatabaseName>

MODIFY FILE (NAME = <CurrentName>, NEWNAME = <NewName>)

Advertisements
This entry was posted in Database Administration and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s