SQL Logical Name Change by ALTER DATABASE

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.

Comments

• Recently Written

  • JohnnyA WordPress malware on MediaTemple
  • Less than percent colon – code render blocks in ASP.NET
  • Essential Freeware
  • Generic List<T> to DataTable using Reflection
  • C# Serialization
  • VirtualBox 3.1 – Install Windows XP Guest on Ubuntu 9.04 Host
  • bubbletip! A jQuery Coda-style bubble tooltip plugin
  • VirtualBox BSOD p3.sys
  • Install Windows XP Guest on Ubuntu 9.04 Host
  • Limiting network file transfer throughput with rsync

• Categories

  • Code Snippits
  • Database
  • Helpful Applications
  • Installs and Configs
  • Malware
  • Scripting

• Monthly Archives

  • July 2010
  • May 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • May 2009
  • February 2009
  • November 2008
  • August 2008