Taking a database offline is probably less invasive than a detach-move files-reattach sequence. — Get file name and current location of files. SELECT name AS LogicalFileName, physical_name AS FileLocation, state_desc AS Status FROM sys.master_files WHERE database_id = DB_ID(‘RedgateMonitor’); USE MASTER — Alter … Continue reading →