Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2015-02-25 : 14:27:15
|
| I have a SQL Server 2012 DB in Full recovery mode that has never had a TLOG backup. the log is huge 200+GB.I tried doing a transaction log backup but there is not enough space on the Disk. How can I reclaim this log space in SQL Server 2012? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-25 : 14:36:05
|
| Switch the recovery model to simple and then shrink it down using DBCC SHRINKFILE (or the GUI).Then decide what your recovery model should be going forward.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2015-02-26 : 04:18:48
|
| Thank you !I did what you said, then changed the recovery model back to full and scheduled regular TLOG backups. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
reclaim Disk space by truncating TLOG
Tara Kizer