sp_msforeachdb 'use ? if (select count(filename) from sysfiles where groupid = 0 and filename like ''f:\%'') = 1 begin set nocount on select ''exec sp_detach_db '''''' + db_Name() + '''''''' select ''exec xp_cmdshell '''''' + ''copy '' + rtrim(filename) + '' '' + replace(replace(rtrim(filename),''f:\'',''e:\''),''data'',''log'') + '''''''' from sysfiles where groupid = 0 select ''exec sp_attach_db '''''' + db_Name() + '''''','' select '''''''' + rtrim(filename) + '''''','' from sysfiles where groupid = 1 select '''''''' + replace(replace(rtrim(filename),''f:\'',''e:\''),''data'',''log'') + '''''''' from sysfiles where groupid = 0 end select char(13) + char(10)'