I have a database that has a transaction log that has gotten really large. The database is in full recovery model.
I ran the backup transaction log maintenance plan on this log file twice.
the first time. it created a backup file that was appropriate and large.
I go back to see the log file hoping that is has shrunk and it has not.
i run the maintenance plan again for grins.
this time the bak file for this transaction log is only a couple hundred kb which would indicate to me that the transaction log is small
i go back to the transaction log and it is still huge.........
Can someone give me some insight on this.