Promena fizičkog imena fajla na SQL serveru

-- Detach Current Database
USE [master]
GO
EXEC master.dbo.sp_detach_db @dbname = N'MyDB'
GO
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
-- To Rename Physical Files */
EXEC xp_cmdshell 'RENAME "D:\SQLData\MSSQL10_50.SQL2008\MSSQL\DATA\MyDB.mdf", "MyDB_NEW.mdf"'
GO
EXEC xp_cmdshell 'RENAME "D:\SQLData\MSSQL10_50.SQL2008\MSSQL\DATA\MyDB.ldf", "MyDB_NEW_log.ldf"'
GO
-- Attach Renamed ProductsDB Database Online */
CREATE DATABASE MyDB ON
( FILENAME = N'D:\SQLData\MSSQL10_50.SQL2008\MSSQL\DATA\MyDB_NEW.mdf' ),
( FILENAME = N'D:\SQLData\MSSQL10_50.SQL2008\MSSQL\DATA\MyDB_NEW_log.ldf' )
FOR ATTACH
GO