Wednesday, July 25, 2007

Change logical filename of SQL database

Perform this query to change the logical filename of both the data and logfile of you database.

USE MASTER
GO
ALTER DATABASE MyDatabase
MODIFY FILE
(NAME = <DBFileName_DATA>, NEWNAME='NewDBFileName_Data')
GO

ALTER DATABASE MyDatabase
MODIFY FILE
(NAME = DBFileName_Log, NEWNAME='NewDBFileName_Log')
GO

No comments:

Post a Comment