river-653653 (9/29/2009)
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
When you lookup DBCC SHRINKFILE, you will probaby want to shrink the transaction log to a size between 50 to 100 MB, that is about 10 to 20% the size of your database.
You also need to be sure to setup regularly scheduled transaction log backups between your full and differential backups. It is the regularly scheduled transaction og backups that will keep your transaction log from growing to 10 GB again, and will provide you with point in time recovery. If you don't have transaction log backups, you don't have the ability to performa point in time restore.
Please take the time to read BACKUP LOG in BOL. It will provide you with information regarding the options.