I have a drive holding the transaction logs, and am running full backups. The drive is filling.
The procedure outlined below allows me to shrink it
BACKUP LOG <DatabaseName> TO DISK = '<BackupFile>'
DBCC SHRINKFILE (<FileName>)
I don't get why the following does not work for me. Unsure why I'd even need any of the log specific things below.
right click DB, tasks, backup, full
right click DB, tasks, backup, Transaction Log
right click DB, tasks, shrink, db
right click DB, tasks, shrink, files, change to log
Also we have set up a maintanance plan to backup and shrink but the logs keep expanding regardless.
My understanding is that the only thing that shrinks transaction logs is the shrink command. Transaction log items are no longer needed once a backup is performed, and shrinking the log returns this space to the OS. I assume a full backup backs up the transaction log as well as the database.
I'm obviously missing something though and any insight you can give is greatly appreciated.
The procedure outlined below allows me to shrink it
BACKUP LOG <DatabaseName> TO DISK = '<BackupFile>'
DBCC SHRINKFILE (<FileName>)
I don't get why the following does not work for me. Unsure why I'd even need any of the log specific things below.
right click DB, tasks, backup, full
right click DB, tasks, backup, Transaction Log
right click DB, tasks, shrink, db
right click DB, tasks, shrink, files, change to log
Also we have set up a maintanance plan to backup and shrink but the logs keep expanding regardless.
My understanding is that the only thing that shrinks transaction logs is the shrink command. Transaction log items are no longer needed once a backup is performed, and shrinking the log returns this space to the OS. I assume a full backup backs up the transaction log as well as the database.
I'm obviously missing something though and any insight you can give is greatly appreciated.