How do you shrink a log file in SQL Management Studio Express?
Got a database with a huge log file (3 gb) after running for a long time without backup.
Normally the backup software will shrink the log file after backup, but this doesn't happens when I now run backup. Also tried to use Backup Exec and select "backup log file" ,but this doesn't either shrink the file. The backupfile is only 2MB, but when I try to restore, the log file gets the same size (3 gb).
So clearly there isn't 3 gb of data in the logfile. It has just reserved the amount of disk space.
I think I remember something about setting the "Recovery model" to "Simple" and than run backup?
The main thing is that I don't' loose any data if there still is something that hasn't been moved to the main database file.