Sunday, June 25, 2023

SQL Server: alter physical file names

select 'ALTER DATABASE ' + d.name +' MODIFY FILE ( NAME = ' + f.name + ', FILENAME = ''' + f.physical_name +''' );'
from sys.master_files f, sys.databases d
where f.database_id > 4
and f.database_id = d.database_id
and f.physical_name like 'C:\ClusterStorage\Test UDB\Data\%'
order by d.name

No comments:

Post a Comment