Sunday, November 30, 2008

Change Logical Filenames

Change logical filenames of MS SQL databse

USE MASTER
GO
ALTER DATABASE [DatabaseName]
MODIFY FILE
(NAME = [OldFileName_Data], NEWNAME='NewFileName_Data')
GO

ALTER DATABASE [DatabaseName]
MODIFY FILE
(NAME = OldFileName_Log, NEWNAME=''NewFileName_Log')
GO