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.