I have a database that has a 33 gb transaction log. It is caused by the fact that the database is in full recovery mode has been used for over 5 years prior to the first backup.
I want to truncate and shrink the log file with the following command
Backup log dbname with truncate_only go DBCC shrinkfile('logicalfilename',100)
I want to know after I ran the above command, in the future, will I be able to do a restore to a point in time between Future full backup 1 and 2?
- Pre-Truncate Backup
- truncate and shrink
- Future full backup 1
- Future full backup 2