/*
* create a database of equal size to the one you're trying to attach
* shutdown the server
* swap in the old mdf file
* bring up the server and let the database attempt to be recovered and then go into suspect mode
* put the database into emergency mode with ALTER DATABASE
* run DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS) which will rebuild the log and run full repair
*/

alter database template set emergency
go
alter database template set single_user;
go

dbcc checkdb ('template',REPAIR_ALLOW_DATA_LOSS)
go

alter database template set multi_user

exec sp_detach_db 'global'
execute sp_attach_db @filename1 = 'C:\Databases\\global.mdf', @filename2 = 'C:\Databases\\global_log.ldf', @dbname = global;
exec sp_detach_db 'local'
execute sp_attach_db @filename1 = 'C:\Databases\\local.mdf', @filename2 = 'C:\Databases\\local_log.ldf', @dbname = local;
exec sp_detach_db 'history'
execute sp_attach_db @filename1 = 'C:\Databases\\history.mdf', @filename2 = 'C:\Databases\\history_log.ldf', @dbname = history;

... куча селектов вида
select top 1 * from images
select top 1 * from series
select top 1 * from studies

BACKUP DATABASE [local] TO DISK = 'S:\Disk\Databases\local.bak' WITH FORMAT
BACKUP DATABASE [global] TO DISK = 'S:\Disk\Databases\global.bak' WITH FORMAT
BACKUP DATABASE [history] TO DISK = 'S:\Disk\Databases\history.bak' WITH FORMAT

SELECT COUNT( DISTINCT FILLCOMPPATIENT.ID) FROM "FILLCOMPPATIENT"('TOMO002')   FILLCOMPPATIENT
WHERE  ( FILLCOMPPATIENT.ARCHIV <> 0 OR FILLCOMPPATIENT.KOLZAP = 2 )
AND ( ( DATLASTREC BETWEEN '16.05.2013' AND '17.05.2013')  OR DATLASTREC IS NULL )
ORDER BY  KOLZAP DESC,  DATLASTREC DESC

BEGIN  
FOR  SELECT ATRPATIENT.FIRSTNAME AS FIRSTNAME, ATRPATIENT.SECONDNAME AS SNAME, ATRPATIENT.TREENAME AS TNAME,  
PATIENT.DATLASTREC AS DATLASTREC,( SELECT NAME FROM SEX WHERE SEX.SEX = ATRPATIENT.SEX ) AS SEX,  
ATRPATIENT.DATEBIRTH AS DATEBIRTH,  
( SELECT NAME FROM CONTINGENT WHERE CONTINGENT.ID = ATRPATIENT.STATUS )    AS ALLSTATUS,  
ATRPATIENT.PASSPORT AS PASSPORT, ATRPATIENT.NUMERIB AS NUMIB, ATRPATIENT.POLIC AS POLIC,  
( SELECT NAME FROM FACTORY    WHERE FACTORY.ID    = ATRPATIENT.IDFACTORY ) AS FACTORY,  
( SELECT NAME FROM REGION     WHERE REGION.ID     = ATRPATIENT.IDREGION)   AS REGION,  
( SELECT NAME FROM TOWN       WHERE TOWN.ID       = ATRPATIENT.IDTOWN)     AS TOWN,  
ATRPATIENT.STREET   AS STREET, PATIENT.ID AS ID , ATRPATIENT.TELEFON AS TELEFON,  
( SELECT NAME FROM FACELEMENT WHERE FACELEMENT.ID = ATRPATIENT.IDFACELEMENT ) AS FACELEMENT,  
ATRPATIENT.WORKS AS WORKS,     ( SELECT NAME FROM POST       WHERE POST.ID       = ATRPATIENT.IDPOST ) AS POST,  
ATRPATIENT.COMM AS COMM, ATRPATIENT.FREE1 AS FREE1, ATRPATIENT.FREE2   AS FREE2,  
( SELECT NAME FROM PATIENTDOP1 WHERE PATIENTDOP1.ID   = ATRPATIENT.IDFREE1 )   AS CBFREE1,  
( SELECT NAME FROM PATIENTDOP2 WHERE PATIENTDOP2.ID   = ATRPATIENT.IDFREE2 )   AS CBFREE2,  
( SELECT NAME FROM MILITARY WHERE MILITARY.ID = ATRPATIENT.IDMILITARY) AS MILITARY,  
( SELECT NAME FROM MEDCOM   WHERE MEDCOM.ID   = ATRPATIENT.IDMEDCOM )  AS MEDCOM,  
( SELECT NAME FROM COUNTRY  WHERE COUNTRY.ID  = ATRPATIENT.IDCOUNTRY)  AS COUNTRY,  
ATRPATIENT.DATEB AS DATEB, ATRPATIENT.IDCOUNTRY AS IDCOUNTRY,  ATRPATIENT.IDREGION AS IDREGION, ATRPATIENT.IDTOWN AS IDTOWN,  
ATRPATIENT.IDFACTORY AS IDFACTORY, ATRPATIENT.IDMEDCOM AS IDMEDCOM, PATIENT.DATCR AS DATCR,  
PATIENT.DiAGNOS AS BMP, PATIENT.ARCHIV AS ARCHIV, ATRPATIENT.STATUS, PATIENT.KOLZAP, PATIENT.WARD,  
ATRPATIENT.TEXTPROTEC, PATIENT.PROTEC, ATRPATIENT.TEXTSTOR, ATRPATIENT.TEXTDIAG  
FROM ATRPATIENT  
INNER JOIN PATIENT ON  ATRPATIENT.IDPAT = PATIENT.ID  
INNER JOIN BMP ON BMP.IDPAT = PATIENT.ID INNER JOIN PARAPP ON PARAPP.TYPES  = BMP.IDCAMERA  
  WHERE BMP.IDPAT =  PATIENT.ID  AND PARAPP.COMP = :COMP  
  UNION  
SELECT ATRPATIENT.FIRSTNAME AS FIRSTNAME, ATRPATIENT.SECONDNAME AS SNAME, ATRPATIENT.TREENAME AS TNAME,  
  PATIENT.DATLASTREC AS DATLASTREC,( SELECT NAME FROM SEX WHERE SEX.SEX = ATRPATIENT.SEX ) AS SEX,  
  ATRPATIENT.DATEBIRTH AS DATEBIRTH,  
  ( SELECT NAME FROM CONTINGENT WHERE CONTINGENT.ID = ATRPATIENT.STATUS )    AS ALLSTATUS,  
  ATRPATIENT.PASSPORT AS PASSPORT, ATRPATIENT.NUMERIB AS NUMIB, ATRPATIENT.POLIC AS POLIC,  
  ( SELECT NAME FROM FACTORY    WHERE FACTORY.ID    = ATRPATIENT.IDFACTORY ) AS FACTORY,  
  ( SELECT NAME FROM REGION     WHERE REGION.ID     = ATRPATIENT.IDREGION)   AS REGION,  
  ( SELECT NAME FROM TOWN       WHERE TOWN.ID       = ATRPATIENT.IDTOWN)     AS TOWN,  
  ATRPATIENT.STREET   AS STREET, PATIENT.ID AS ID , ATRPATIENT.TELEFON AS TELEFON,  
  ( SELECT NAME FROM FACELEMENT WHERE FACELEMENT.ID = ATRPATIENT.IDFACELEMENT ) AS FACELEMENT,  
  ATRPATIENT.WORKS AS WORKS,  ( SELECT NAME FROM POST       WHERE POST.ID       = ATRPATIENT.IDPOST ) AS POST,  
  ATRPATIENT.COMM AS COMM, ATRPATIENT.FREE1 AS FREE1, ATRPATIENT.FREE2   AS FREE2,  
  ( SELECT NAME FROM PATIENTDOP1 WHERE PATIENTDOP1.ID   = ATRPATIENT.IDFREE1 )   AS CBFREE1,  
  ( SELECT NAME FROM PATIENTDOP2 WHERE PATIENTDOP2.ID   = ATRPATIENT.IDFREE2 )   AS CBFREE2,  
  ( SELECT NAME FROM MILITARY WHERE MILITARY.ID = ATRPATIENT.IDMILITARY) AS MILITARY,  
  ( SELECT NAME FROM MEDCOM   WHERE MEDCOM.ID   = ATRPATIENT.IDMEDCOM )  AS MEDCOM,  
  ( SELECT NAME FROM COUNTRY  WHERE COUNTRY.ID  = ATRPATIENT.IDCOUNTRY)  AS COUNTRY,  
   ATRPATIENT.DATEB AS DATEB, ATRPATIENT.IDCOUNTRY AS IDCOUNTRY,  ATRPATIENT.IDREGION AS IDREGION, ATRPATIENT.IDTOWN AS IDTOWN,  
   ATRPATIENT.IDFACTORY AS IDFACTORY, ATRPATIENT.IDMEDCOM AS IDMEDCOM, PATIENT.DATCR AS DATCR,  
   PATIENT.DiAGNOS AS BMP, PATIENT.ARCHIV AS ARCHIV, ATRPATIENT.STATUS, PATIENT.KOLZAP, PATIENT.WARD,  
   ATRPATIENT.TEXTPROTEC, PATIENT.PROTEC, ATRPATIENT.TEXTSTOR, ATRPATIENT.TEXTDIAG  
   FROM ATRPATIENT  
   INNER JOIN PATIENT ON  ATRPATIENT.IDPAT = PATIENT.ID WHERE PATIENT.KOLZAP = 2   
   INTO :FIRSTNAME, :SNAME, :TNAME, :DATLASTREC, :SEX, :DATEBIRTH, :ALLSTATUS, :PASSPORT, :NUMIB, :POLIC, :FACTORY, :REGION,  :TOWN,  
  :STREET, :ID, :TELEFON, :FACELEMENT, :WORKS, :POST, :COMM, :FREE1, :FREE2, :CBFREE1, :CBFREE2,  
   :MILITARY, :MEDCOM, :COUNTRY, :DATEB, :IDCOUNTRY, :IDREGION, :IDTOWN, :IDFACTORY, :IDMEDCOM,   
   :DATCR, :BMP, :ARCHIV, :STATUS, :KOLZAP, :IDWARD, :TEXTPROTEC, :PROTEC, :TEXTSTOR, :TEXTDIAG   
   DO   
   SUSPEND;   
   END