--step 1 take database backup either on disk or device backup database SMARTAPP to 'c:\backup\bkup1.dat' --step 2 take logs backup log SMARTAPP with no_log --step 3 shrink the database DBCC SHRINKDATABASE('SMARTAPP',TRUNCATEONLY)