- -- Database status is open
- USE master;
- GO
- ALTER DATABASE AdventureWorks
- MODIFY FILE
- (
- NAME = LogicFilename,
- FILENAME = N'E:\NewPath\FileName.ndf'
- );
- GO
- -- Database offline
- USE [master]
- GO
- ALTER DATABASE AdventureWorks SET OFFLINE
- GO
- -- Move old data file to new path
- cmd> move oldPath\Filename newPath\Filename
- -- Database online
- USE [master]
- GO
- ALTER DATABASE AdventureWorks SET ONLINE
- GO