I am currently doing a Backup Plan for my Databases.(FULL Mode)
I have a database of 28MB but its log file is around 8000MB! How will i manage to clear the Logs?
I tried the following:
1. Full backup of the Database.
(Size of Full Backup: 28MB)
2. Backing up the Transaction Log.(Radio button: 'Truncate the Trasaction Log' Ticked).
(Size of Transaction Log Backup: around 8000MB)
3. Shrinking up Transaction Log to 4000MB and 2000MB repeatedly.
(Right Click on the Database --> Tasks --> Shrink --> Files --> Data Type: Log --> Shrink To 2000MB
But the Transaction Remains around 8000MB!
is it safe to just delete the Log after i performed a Full backup of the Database even if its only 28MB?
Thanks in advance and Happy Easter.