I have a situation right now.
There is a database in SIMPLE recovery model.
1. Compression is not enabled which will be enabled pretty soon. 2. SQL Server 2012 SP3
BackupSize: 8GB (Usually)<br/> Last Saturday BackupSize: 73GB (yes, 73 !!)
This is because of an application that left 2 transactions open.
Right now the LOG file is 154GB.
Transaction: So far it inserted 90M records to a not so large table)
- In a FULL backup, how much LOG information is recorded if there is an open transaction?
- When the FULL backup is restored, does it ROLLBACK the actions by the OPEN transaction?
- If so, why does FULL backup even bother to backup the LOG for an OPEN transaction when it is still open after the backup is finished (on a SIMPLE recovery model though).
- If I kill the spid from SQL Server, does it need more LOG space to ROLLBACK? We are already out of space here !!