My database as 430 MB in the data file and 10GB in the Log file.
I want to live the database in full recovery model, because i want to be able to do recovery in time.
I will do what you told me (truncate the log file, then shrink it) and then make another full backup to this database.
What does the backup log with_notruncate do exactly?
thank you