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