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.


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

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