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.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 reclaim Disk space by truncating TLOG

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-26 : 12:24:20


Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -