use WGD
delete from [BackupFilePath]
delete from [PacsMovedImages]
delete from [UnsendedImage]
delete from [Image]
delete from [Series]
delete from [Study]
delete from [Patient]
delete from [PatientDetailed]
delete from [ModifiedPatient]
delete from [ModifiedPatientHistory]
delete from [EventLog]
delete from [DeleteRecordLog]
delete from [DeletedImages]
delete from [CanceledStudy]

@echo off
set startdisk=%~d0
set startdir=%~dp0
set scriptname=%~dp0%~nx0
set name=%~dp0%~n0
set logfile=%name%.log
set tempdir=%name%_tmp
set tempfile=%name%.tmp
%startdisk%
cd /d %startdir%

@echo Äτ¿ßΓ¬á íáºδ SQL
@echo ä½∩ »«ñΓóÑαªñÑ¡¿∩ ¡áª¼¿ΓÑ ½εíπε ¬½áó¿Φπ
pause >nul
@sqlcmd -S %computername%\sqlexpress -i clearAll.sql -U elsa -P Luda7Sasha > errors.txt
if exist d:\Epo\Images\. rd /S /Q d:\Epo\Images\
if not exist  d:\Epo\Images\. md d:\Epo\Images\
echo ...ºáóÑαΦÑ¡«.
timeout /T 5 >nul

Changed database context to 'WGD'.

(«íαáí«Γá¡« ßΓ᫬: 0)
æ««íΘÑ¡¿Ñ 547, πα«óÑ¡∞ 16, ß«ßΓ«∩¡¿Ñ 1, ßÑαóÑα LAB01\SQLEXPRESS, ßΓ᫬á 7
The DELETE statement conflicted with the REFERENCE constraint "FK_StudyApr_Study". The conflict occurred in database "WGD", table "dbo.StudyApr", column 'StudyId'.
The statement has been terminated.
æ««íΘÑ¡¿Ñ 547, πα«óÑ¡∞ 16, ß«ßΓ«∩¡¿Ñ 1, ßÑαóÑα LAB01\SQLEXPRESS, ßΓ᫬á 8
The DELETE statement conflicted with the REFERENCE constraint "FK_STUDY_REFERENCE_PATIENT". The conflict occurred in database "WGD", table "dbo.Study", column 'PatientId'.
The statement has been terminated.
æ««íΘÑ¡¿Ñ 547, πα«óÑ¡∞ 16, ß«ßΓ«∩¡¿Ñ 1, ßÑαóÑα LAB01\SQLEXPRESS, ßΓ᫬á 9
The DELETE statement conflicted with the REFERENCE constraint "FK_Patient_PatientDetailed". The conflict occurred in database "WGD", table "dbo.Patient", column 'DetailedId'.
The statement has been terminated.

delete FROM [WGD].[dbo].[Image]
where
datediff(d,datecreation,getdate())>100

BACKUP DATABASE [Master]
TO DISK='E:\backup\Database\Master.bak' WITH
FORMAT