How to change logical file name of a Database in SQL ?


 --change log file name
ALTER DATABASE [TESTDB] MODIFY FILE (NAME = TESTDB_log,
NEWNAME = TESTDBNEW_log);


--change data file name
ALTER DATABASE [TESTDB] MODIFY FILE (NAME = TESTDB_DATA,
NEWNAME = TESTDBNEW_DATA);




Post a Comment

0 Comments