USE tmssmall GO DBCC SHRINKFILE(tmssmall_log, 1) BACKUP LOG tmssmall WITH TRUNCATE_ONLY DBCC SHRINKFILE(tmssmall_log, 1) GO tmssmall is name of database So… copy the above text entirely to Notepad Ctr+H Find what is ‘tmssmall’ Replace with is ‘yourdatabasename’ OK. Copy the new text and execute query Save space!!
My experiences with Object Oriented Programming