SQL Logical Name Change by ALTER DATABASE


Warning: count(): Parameter must be an array or an object that implements Countable in /nfs/c01/h05/mnt/6385/domains/uhleeka.com/html/blog/wp-content/plugins/uhleeka-codebox/uhleeka-codebox.php on line 65

Use the following code snippits to identify and rename logical file names in Microsoft SQL Server.

Determine the logical file names

USE [database_name]
GO
sp_helpfile
GO

Rename logical file names

USE master
GO
ALTER DATABASE database_name
MODIFY FILE  ( NAME = 'current_logical_name', 
NEWNAME = 'new_logical_name')
GO

SQL 2008 returns the following confirmation:

The file name 'new_logical_name' has been set.

One Comment

Comments are closed.