Just realized one of our databases has been in Full Recovery mode but we've not been making log backups. On a nightly basis, we've been running a job that runs this T-SQL command to do the database backup:
BACKUP DATABASE [foo] TO DISK = N'J:\NAV Backup\foo.bak' WITH NOFORMAT, INIT, NAME = N'Foo-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
After searching the intertubes, I'm still uncertain about what would have happened if we would have had to restore with only just the
.bak file (no transactional log file or backup of the transaction log). Would we have been able to get back to the point of the last nightly backup?
Assuming a restore would have worked, would the new transaction log been has big as the old (lost) one (~300GB in our case)?