SQL SERVER | Modificare il nome logico del database

19 febbraio 2015 1 min di lettura Database Microsoft SQL Server Windows

USE MASTER GO ALTER DATABASE DatabaseName MODIFY FILE (NAME = ‘LogicalName\_Data’, NEWNAME=’NEWLogicalName\_Data’) GO ALTER DATABASE DatabaseName MODIFY FILE (NAME = ‘LogicalName\_Log’, NEWNAME=’NEWLogicalName\_Log’) GO

USE MASTER
GO

ALTER DATABASE DatabaseName
MODIFY FILE (NAME = 'LogicalName_Data', NEWNAME='NEWLogicalName_Data')
GO
 
ALTER DATABASE DatabaseName
MODIFY FILE (NAME = 'LogicalName_Log', NEWNAME='NEWLogicalName_Log')
GO