0
votes
0answers
9 views

Does a database backup reduce size/increase free space of the log file?

N00b question, sorry! Got a SQL database and the log file is massive and keeps growing every day. I've archived data from the database and then done a full backup...I was expecting the log to then ...
10
votes
2answers
1k views

SQL Server transaction log backups: test whether tail log follows last known log backup

We are using SQL Server with full recovery mode. Given a full backup and a series of log backups, we would like to be able to check whether the log chain is complete from the last full backup to the ...
2
votes
2answers
2k views

Transaction log has grown huge after maintenance plan to rebuild idex

A couple of days ago I was testing some stuff using the Maintenance Plans in SQL Server 2008. I created one to rebuild indexes and take a full backup every week. (I know, bad thing I've found out ...