-- Set Database offline script

Alter Database ION_DATA
SET offline With ROLLBACK IMMEDIATE 
GO

-- Set Database online 

ALTER DATABASE ion_data SET ONLINE
GO

-- Verify new location script

SELECT name, physical_name AS NewLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'ION_Data')



--Alter location script 

ALTER DATABASE ION_DATA
MODIFY FILE ( NAME = ION_Data_Data, FILENAME = "C:\MD\ION_DATA.mdf" )
GO
ALTER DATABASE ION_DATA
MODIFY FILE ( NAME = ION_Data_Log, FILENAME = "C:\LDF\ION_DATA.ldf" )
Go


--Script used to verify integrity

DBCC CHECKDB("ION_DATA")
GO